基本操作:
==
1.创建Excel文件:
WritableWorkbook book=Workbook.createWorkbook(new File("path"));
2.创建Sheet:
WritableSheet sheet=book.createSheet("sheetName",sheetIndex);
3.设置行宽、列高:
sheet.setRowView(row,height);
sheet.setColumnView(col,width);
4.设置单元格样式:
WritableCellFormat format=new WritableCellFormat();
format.setAlignment(Alignment.CENTER);//居中
format.setBorder(Border.ALL,BorderLindeStyle.THIN);//设置边框厚度
format.setBackground(jxl.format.Colour.RED);//设置单元格背景色
format.setFont(new WritableFont(WritableFont.Arial,16);//设置字体
5.创建单元格:
Label label=new Lable(col,row,value,format);
6.单元格新增到Sheet中:
sheet.addCell(label);
7.开始写入Excel文件
book.write();
8.关闭文件
book.close();
增值操作
==
设置自动换行:
format.setWrap(true);
设置默认宽度、高度:
sheet.getSettings().setDefaultColumnWidth(width);
sheet.getSettings().setDefaultRowHeight(height);
合并单元格:
sheet.mergeCells(firstCol,firstRow,lastCol,lastRow);
填充无格式数字:
jxl.write.Number number=new jxl.write.Number(col,row,value);
填充有格式数字:
jxl.write.NumberFormat nf=new jxl.write.NumberFormat("#.##");
jxl.write.WritableCellFormat format=new jxl.write.WritableCellFormat(nf);
jxl.write.Number number=new jxl.write.Number(col,row,value,format);
填充日期:
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
String dateStr=sdf.format(date);
label=new Label(col,row,dateStr);
填充布尔值:
jxl.write.Boolean bool=new jxl.write.Boolean(col,row,true/false);