导出Excel,行数太多,可以使用SXSSFWorkbook
jxl.write.biff.RowsExceptin:the maximun number of rows permitted on a worksheet been exceeded
使用org.apache.poi.xssf.streaming.SXSSFWorkbook这个类
SXSSFWorkbook wb = new SXSSFWorkbook(1000);
Sheet sheet = wb.createSheet("sheet");
sheet.setColumnWidth(i,“列名”.getBytes().length * 256);
或者分不同的sheet页