将数据写好格式,转化为字符型,设为变量"ttt"再用下面代码:
/* 将划好格式的Excel模板的某一个单元格的格式取出 */
CellFormat cf = sheet.getCell(col, row).getCellFormat();
Label label = new Label(col,row,"ttt",cf);sheet.add(label);
/* 将划好格式的Excel模板的某一个单元格的格式取出 */
CellFormat cf = sheet.getCell(col, row).getCellFormat();
Label label = new Label(col,row,"ttt",cf);sheet.add(label);
cwcfN.setBorder(Border.All, BorderLineStyle.THIN);
new jxl.write.WritableCellFormat(cnf);cwcfN.setBorder(Border.All, BorderLineStyle.THIN);
jxl.write.Number clabel = new jxl.write.Number(2, 37, c38, cwcfN);
结贴!