try{
//创建工作薄、工作表
WritableWorkbook wwb = Workbook.createWorkbook(new File(in_fileDialog.getDirectory()+"result.xls"));
WritableSheet ws = wwb.createSheet("result",0);
Number labelN = new Number(0,1,3.1415926);
ws.addCell(labelN);
NumberFormat nf = new NumberFormat("#.##");
WritableCellFormat wcfN = new WritableCellFormat(nf);
Number labelNF = new jxl.write.Number(1,1,3.1415926,wcfN);
ws.addCell(labelNF);
Boolean labelB = new jxl.write.Boolean(0,2,false);
ws.addCell(labelB);
jxl.write.DateTime labelDT = new jxl.write.DateTime(0,3,new java.util.Date());
ws.addCell(labelDT);
DateFormat df = new DateFormat("dd MM yyyy hh:mm:ss");
WritableCellFormat wcfDF = new WritableCellFormat(df);
DateTime labelDTF = new DateTime(1,3,new java.util.Date(),wcfDF);
ws.addCell(labelDTF);
}catch(IOException ioe)
{
System.out.println(ioe.toString());
}
从EXCEL中读入,创建都是可以的,唯独写入没有反应,请高手帮忙,谢谢!
//创建工作薄、工作表
WritableWorkbook wwb = Workbook.createWorkbook(new File(in_fileDialog.getDirectory()+"result.xls"));
WritableSheet ws = wwb.createSheet("result",0);
Number labelN = new Number(0,1,3.1415926);
ws.addCell(labelN);
NumberFormat nf = new NumberFormat("#.##");
WritableCellFormat wcfN = new WritableCellFormat(nf);
Number labelNF = new jxl.write.Number(1,1,3.1415926,wcfN);
ws.addCell(labelNF);
Boolean labelB = new jxl.write.Boolean(0,2,false);
ws.addCell(labelB);
jxl.write.DateTime labelDT = new jxl.write.DateTime(0,3,new java.util.Date());
ws.addCell(labelDT);
DateFormat df = new DateFormat("dd MM yyyy hh:mm:ss");
WritableCellFormat wcfDF = new WritableCellFormat(df);
DateTime labelDTF = new DateTime(1,3,new java.util.Date(),wcfDF);
ws.addCell(labelDTF);
}catch(IOException ioe)
{
System.out.println(ioe.toString());
}
从EXCEL中读入,创建都是可以的,唯独写入没有反应,请高手帮忙,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货