设置字体颜色容易,但不知怎样设置单元格背景色,忘指教

解决方案 »

  1.   

    用JXL
       WritableWorkbook wwb = Workbook.createWorkbook(excel);
       WritableSheet ws = wwb.createSheet("testexcel",1);
       Label lable = null;
       WritableFont wf = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false,UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
       WritableCellFormat wcf = new WritableCellFormat(wf);
       <h2>wcf.setBackground(Colour.WHITE);<h2>    // 设置单元格背景
       lable = new Label(0,1,"fdsl",wcf);
       ws.addCell(lable);