Excel导出超出65536行报错

一：报错

Invalidrownumber(65536)outsideallowablerange(0..65535)
原因：excel03的限制就是65536行，超过行数就报错
二：解决方案-创立多个sheet
publicStringexport(Listlist,Stringf){
Stringname=””;
HSSFWorkbookbook=newHSSFWorkbook();
HSSFSheetsheet=book.createSheet(“stud”);
//声明一行
HSSFRowrow=sheet.createRow(0);
row=sheet.createRow(0);
row.createCell(0).setCellValue(“身份”);
row.createCell(1).setCellValue(“信誉”);
intindex=0;//记录额外创立的sheet数量
for(inti=0;i<list.size();i++){
if((i+1)%65535==0){
sheet=book.createSheet(“stud”+index);
row=sheet.createRow(0);
row.createCell(0).setCellValue(“身份”);
row.createCell(1).setCellValue(“信誉”);
index++;
}
row=sheet.createRow((i+1)-(index*65535));
//第四步，创立单元格，并设置值
row.createCell((short)0).setCellValue(list.get(i).getStr(“info”));
row.createCell((short)1).setCellValue(list.get(i).getStr(“score”));
}
//第六步，将文件存到指定位置
StringfileName=””;
try{
fileName=f+”/download/导出.xls”;
name=”导出.xls”;
Filefile=newFile(fileName);
if(file.exists()){
file.delete();
}
FileOutputStreamfout=newFileOutputStream(fileName);
book.write(fout);
fout.close();
}catch(Exceptione){
e.printStackTrace();
}
returnname;
}