JAVA处理Excel

jxl
java生成excel表格

private static WritableSheet writeNumberToWs(WritableSheet ws,jxl.write.WritableCellFormat wcfN, int row, int j,
  double titlesDoubleValue) {
 jxl.write.Number labelNF = new jxl.write.Number(j, row,
   titlesDoubleValue, wcfN); // 格式化数值
 try {
  ws.addCell(labelNF);
 } catch (Exception e1) {
  e1.printStackTrace();
 } 
 return ws;
}
public static void zxf() {
 try {
  //创建Excel文件
  File file =new File("X:\\javaFile\\20200507\\zxfexcel\\src\\zxftestfile1.xls");
  file.createNewFile();
  //创建工作簿,然后进行
   jxl.write.WritableWorkbook workbook =jxl.Workbook.createWorkbook(file);
  //创建sheet
  jxl.write.WritableSheet sheet =workbook.createSheet("zxf" , 0);
  jxl.write.WritableSheet sheet1 =workbook.createSheet("wx" , 1);
  jxl.write.WritableSheet sheet2 =workbook.createSheet("zs" , 2);
  jxl.write.WritableSheet sheet3 =workbook.createSheet("333" , 3);
  jxl.write.WritableSheet sheet4 =workbook.createSheet("444" , 4);
  jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#0.00"); // 设置数字格式
  jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf); // 设置表单格式
  //第一行设置列名:创建数组
  String[] title={"编号","姓名","性别","年龄"};
  jxl.write.Label label =null ;
  //设置列名
  String[] AEADnameTemp ={"1110","1111","1112","1113","1114","1115","1116","1117","1118","1119","11110","11111","11112","11113","11114","11115","11116","11117","11118","11119","11120","11121","11122","11123","11124",};
  for (int i = 0; i < 20; i++) {
   double titlesDoubleValue = Double.parseDouble(AEADnameTemp[i]);
   sheet = writeNumberToWs(sheet, wcfN, 1, i,titlesDoubleValue);
  // label = new jxl.write.Label(0,i, AEADnameTemp[i]);
  //  sheet.addCell(label); 
  }
  //追加数据
  /*
  for (int i = 1; i <=30; i++) {
   label=new jxl.write.Label(0,i,"id"+i);
   sheet.addCell(label);
   label= new Label(1,i,"张"+i);
   sheet.addCell(label);
   label=new Label(2,i,"男");
   sheet.addCell(label);
   label=new Label(3,i,"18"+i);
   sheet.addCell(label); 
  }*/
  //写入数据
  workbook.write();
  workbook.close();
 } catch (Exception e) {
  e.printStackTrace();
 }
 System.out.println("创建完毕");
   
}