java写excel 行数限制_poi excel超出65536行数限制自动扩展Invalid row number (65536) outside allow...

importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFCellStyle;importorg.apache.poi.hssf.usermodel.HSSFDataFormat;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.ss.usermodel.CellStyle;importorg.apache.poi.ss.usermodel.Font;importorg.apache.poi.ss.util.CellRangeAddress;importcom.google.gson.JsonArray;importcom.google.gson.JsonObject;public classExcelUtil { public staticHSSFWorkbook getHSSFWorkbook(String sheetName, JsonArray title,

String[][] values, HSSFWorkbook wb) {//第一步，创建一个HSSFWorkbook，对应一个Excel文件

if (wb == null) {

wb= newHSSFWorkbook();

}//-个sheet限制存65536条，此处仅存60000

System.out.println(values.length);final int sheetNum = (int) Math.ceil((float) values.length / 60000);for (int n = 1; n <= sheetNum; n+&#