使用POI导入数据到Excel数据量过大报错解决方案

导出excel报不能超过4000行错误 

 POI操作Excel中，导出的数据不是很大时，则不会有问题，而数据很多或者比较多时，

就会报以下的错误，是由于cell styles太多create造成，故一般可以把cellstyle设置放到循环外面 报错如下：

java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:1162)

错误示例

for (int i = 0; i < 10000; i++) {  
    Row row = sheet.createRow(i);   
    Cell cell = row.createCell((short) 0);   
    CellStyle style = workbook.createCellStyle();  
    Font font = workbook.createFont();   
    font.setBoldweight(Font.BOLDWEIGHT_BOLD);   
    style.setFont(font);   
    cell.setCellStyle(style);  
}  

改正后正确代码

CellStyle style = workbook.createCellStyle();  
Font font = workbook.createFont();  
font.setBoldweight(Font.BOLDWEIGHT_BOLD);  
style.setFont(font);  
for (int i = 0; i < 10000; i++) {   
    Row row = sheet.createRow(i);   
    Cell cell = row.createCell((short) 0);   
    cell.setCellStyle(style);  
} 

以下是生成excel核心代码：

public static void export( ExcelBean excelBean, HttpServletResponse response) throws IOException {
        String filename = excelBean.getName();
        filename = new String(filename.replaceAll("\\s|;", "").getBytes("gbk"), "ISO8859-1");

        response.setContentType("application/octet-stream;charset=utf-8");
        response.setCharacterEncoding("utf-8&#