急,使用jxl生成excel文件,设置单元格对象类型的问题!
FileOutputStream fstream = null;
fstream= new FileOutputStream("I:\\xtbg\\model\\test.xls");
//create a writable workbook by copying the old one
try{
jxl.write.WritableWorkbook book = Workbook.createWorkbook(fstream); //新建工作表
jxl.write.WritableSheet ws = book.createSheet("report", 0);
//遍历表格中的所有单元格
for (int i = 0; i < v.size(); i++) {
ws.addCell( (jxl.write.Number) v_cell.get(0));
}
}
其中v_cell是个Vector,存了对象jxl.write.Number,我在循环到第92行的第3列后,addCell方法加入number型对象报Warning: Maximum number of format records exceeded. Using default format.生成的文件中此后的单元格内的对象都被自动转为文本型了,之前的number型都是正常的
。高人,求助啦。十万火急