根据模板excel文件生成了一个目标文件,用下面的代码把数据插进了目标文件内
public boolean setCell(int row,int column,long data){
//label = new Label(row, column, java.lang.Long.toString(data));
jxl.write.WritableFont wf2 = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, false);
jxl.write.WritableCellFormat wcfF2 = new jxl.write.WritableCellFormat(wf2);
number = new jxl.write.Number(column,row,data,wcfF2);
try{
sheet.addCell(number);
return true ;
}catch(Exception exc){
exc.printStackTrace();
return false ;
}
}
数据插入成功,可相邻cell(单元格)的边框线不见了问该怎样解决。
public boolean setCell(int row,int column,long data){
//label = new Label(row, column, java.lang.Long.toString(data));
jxl.write.WritableFont wf2 = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, false);
jxl.write.WritableCellFormat wcfF2 = new jxl.write.WritableCellFormat(wf2);
number = new jxl.write.Number(column,row,data,wcfF2);
try{
sheet.addCell(number);
return true ;
}catch(Exception exc){
exc.printStackTrace();
return false ;
}
}
数据插入成功,可相邻cell(单元格)的边框线不见了问该怎样解决。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货