Saturday, July 24, 2010

Writing Excel File With Java (Apache POI API)

public void exportToExcel(String fileName, String sheetName, Vector resultBeans) {
        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