java poi 添加列数据_java用POI写Excel按列数据

写第二行数据：

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);