String [] str =new String[]{……}; //创建预选的列头
HSSFSheet sheet = workbook.createSheet("sheet1");
HSSFRow row = sheet.createRow(0);
for (int i = 0; i < str.length; i++) {
HSSFCell cell = row.createCell((short) i);
cell.setCellValue(new HSSFRichTextString(str[i]));
}
//把数据封装成 Map<Integer, Map<Integer, String>> 类型 然后用两个循环进行写数据
Map<Integer, Map<Integer, String>> map =(Map<Integer, Map<Integer, String>>) helper.getResult("map");
//对应创建与 string 数组相同列的 excel 报表
for (Map.Entry<Integer, Map<Integer, String>> entry : map.entrySet()) {
//创建 row
HSSFRow _row = sheet.createRow(entry.getKey());
Map<Integer, String> value = entry.getValue();
//创建cell
for (Map.Entry<Integer, String> _entry : value.entrySet()) {
HSSFCell _cell = _row.createCell(_entry.getKey().shortValue());
_cell.setCellValue(new HSSFRichTextString(_entry.getValue()));
}
}
}