java 操作(创建)excel，jxl加边框，jxl合并单元格,单元格的设置，单元格居中
jxl加边框
WritableWorkbook ? wwb ? = ? Workbook.createWorkbook(os);
WritableSheet ? ws ? = ? wwb.createSheet( "Test ? Sheet ? 1 ",0);WritableFont ? wf ? = ? new ? WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true);
WritableCellFormat ? wcf ? = ? new ? WritableCellFormat(wf);
wcf.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);
Label ? labelcf ? = ? new ? Label(1,0, "this ? is ? a ? label ? with ? border ? test ",wcf);
ws.addCell(labelcf);
wwb.write();
wwb.close();
?
jxl合并单元格
public static void writeExcel(OutputStream os )throws Exception
? ?{
? ? ? ?? ? try
? ? ? ?? ? {
? ? ? ?? ?
? ? ? ?? ???jxl.write.WritableWorkbook wwb=Workbook.createWorkbook(os);
//? ? ? ? ? ? ? ? jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1", 0);
? ? ? ? ? ? ? ? jxl.write.WritableSheet ws =wwb.createSheet("testsheet1",0);
? ? ? ? ? ? ? ? jxl.write.Label labelC =new jxl.write.Label(0,0,"我爱中国");
? ?? ???ws.addCell(labelC);
? ? ? ? ? ? ? ? labelC =new jxl.write.Label(1,2,"我爱中国1,2");
? ?? ???ws.addCell(labelC);
? ? ? ? ? ? ? ? jxl.write.WritableFont wfc =new jxl.write.WritableFont(WritableFont.ARIAL,20,
? ? ? ? ? ? ? ? ? ? ? ? WritableFont.BOLD,false,
? ? ? ? ? ? ? ? ? ? ? ? UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.GREEN);
? ? ? ? ? ? ? ? jxl.write.WritableCellFormat wcfFc =new jxl.write.WritableCellFormat(wfc);
? ? ? ? ? ? ? ???labelC =new jxl.write.Label(6,0,"中国我爱",wcfFc);
? ? ? ? ? ? ? ? ws.addCell(labelC);
? ? ? ? ? ? ? ? WritableFont wf_merge = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,
? ? ? ? ? ? ? ? ? ? ? ? false,UnderlineStyle.DOUBLE_ACCOUNTING,jxl.format.Colour.GREEN);
? ?WritableCellFormat wff_merge = new WritableCellFormat(wf_merge);
??// wff_merge.setBackground(jxl.format.Colour.BLACK);
? ?jxl.write.Label label30 = new Label(3,0,"Label30",wff_merge);? ?
? ?ws.addCell(label30);
? ?//合并单元格
? ? ws.mergeCells(3,0,4,0);
? ? ? ? ? ? ? ? wwb.write();
? ? ? ? ? ? ? ? wwb.close();
? ? ? ? ? ? ? ? ? ? ? ?
? ? ? ?? ? }
? ? ? ?? ? catch (Exception e )
? ? ? ?? ? {
? ? ? ? ? ? ? ?? ? throw e;
? ? ? ?? ? }
? ?}
使用WritableCellFormat 的setWrap(true)可以设成自动换行，然后再用WritableSheet的setRowView设置行的高度，setColumnView设置列的宽度
行高和列宽
WritableSheet.setRowView(int i,int height);
作用是指定第i+1行的高度，比如：
//将第一行的高度设为200
sheet.setRowView(0,200);
WritableSheet.setColumnView(int i,int width);
作用是指定第i+1列的宽度，比如：
//将第一列的宽度设为30
sheet.setColumnView(0,30);
?
单元格居中
Label label=new Label(column,row,labelValue);
???????WritableCellFormat cellFormat=new WritableCellFormat();
???????cellFormat.setAlignment(jxl.format.Alignment.CENTER);
???????label.setCellFormat(cellFormat);
???????sheetWrite.addCell(label);
