XSSFWorkbook 导出问题.

Question

/**
* 导出excel格式数据
* @param dataBeanArr
* @return
*/
public static XSSFWorkbook doExcelExportWithNoConfig(LfwExportDataBean[] dataBeanArr) {
//XSSFWorkbook
//HSSFWorkBook
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("export");
XSSFCellStyle titleStyle = createTitleStyle(workbook);
//当前写的行数
int indexNum = 0;
if(null != dataBeanArr){
for(int k = 0;k<dataBeanArr.length;k++){
LfwExportDataBean mainBean = dataBeanArr[k];

            String[] titleArr = mainBean.getTitle();

            if(indexNum>0){
                indexNum++;
            }
            //标题写入
            if(null != titleArr){
                XSSFRow row = sheet.createRow(indexNum++);
                for(int i=0;i<titleArr.length;i++){
                    createCell(row, i, titleStyle, XSSFCell.CELL_TYPE_STRING, titleArr[i]);
                }
            }
            //数据
            List<Map<String,Object>> dataArr = mainBean.getData();//拿到数据
            String[] columnArr = mainBean.getColumnName();
            if(null != dataArr){
                //写入数据
                for (Map<String, Object> data : dataArr) {
                    XSSFRow row = sheet.createRow(indexNum++);
                    int columnArrleng = columnArr.length;
                    for(int j=0;j<columnArrleng;j++){
                        Object valueTemp = data.get(columnArr[j]);
                        XSSFCell cell = row.createCell(j);
                        cell.setCellValue(valueTemp==null?"":valueTemp.toString());
                    }
                }
            }
        }
    }

    return workbook;
}

帮忙看下我的代码可以怎样优化加快导出时间

Answer 1

http://www.cnblogs.com/kaiwanlin/p/5782834.html