HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet(sheetName);
int rowIdx = 0;
short cellIdx = 0;
rowIdx = 1;
for (ResultBean bean : resultBeans) {
cellIdx = 0;
HSSFRow hssfRow = sheet.createRow(rowIdx++);
HSSFCell hssfCellID = hssfRow.createCell(cellIdx++);
hssfCellID.setCellValue(bean.getStudentId());
HSSFCell hssfCellName = hssfRow.createCell(cellIdx++);
hssfCellName.setCellValue(bean.getStudentName());
HSSFCell hssfCellScore = hssfRow.createCell(cellIdx++);
hssfCellScore.setCellValue(bean.getScore());
}
wb.setSheetName(0, sheetName, HSSFWorkbook.ENCODING_COMPRESSED_UNICODE);
try {
FileOutputStream outs = new FileOutputStream(new File(fileName));
wb.write(outs);
outs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
No comments:
Post a Comment