写第二行数据:
for (int i = 0; i < dictInfo.size(); i++) {
HSSFRow dataRow = sheet.createRow(i + 1);
dataRow.setHeight((short) (15 * 20));
JavaList l = (JavaList) dictInfo.getKeys();
String s = (String) l.get(i);
JavaList ll = (JavaList) dictInfo.get(s); //获取列数据
for (int j = 0; j < ll.size(); j++) {
Cell dataCell = dataRow.createCell(j);
HSSFFont dataFont = wb.createFont();
dataFont.setFontName("华文细黑");
dataFont.setFontHeightInPoints((short) 10);
dataFont.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
HSSFCellStyle dataStyle = wb.createCellStyle();
dataStyle.setAlignment(HSSFCellStyle.ALIGN_LEFT);
dataStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
dataStyle.setFont(dataFont);
dataCell.setCellStyle(dataStyle);
dataCell.setCellValue(ll.get(j).toString());
}
}
dictInfo中数据:
{
"ordercode":["订单号0","订单号1"],
"tradeno":["交易号0","交易号1"],
"procode":["技术产品代码0","技术产品代码"],
"proname":["技术产品名称0","技术产品名称1"]
}