Example usage for org.apache.poi.hssf.usermodel HSSFSheet createRow

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFSheet createRow.

Prototype

@Override
public HSSFRow createRow(int rownum)

Source Link

Document

Create a new row within the sheet and return the high level representation

Usage

From source file:com.kcs.action.PositionReportAction.java

@Override
public String export() throws Exception {
    positionReportList = service/*from w w  w.  j av a 2 s  .c om*/
            .findMainList(DateUtil.getDateFromString(dataSetDate, DateUtil.DEFAULT_DATE_FORMAT));
    logger.debug("exportExcel : begin...");
    logger.debug("exportExcel : list >>> " + positionReportList.size());

    DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet("Position Report");
    setFileName("Position Report_" + dateFormat.format(new Date()) + "excel".concat(".xls"));

    if (null != positionReportList && positionReportList.size() > 0) {
        int rownum = 0;
        Row row = mySheet.createRow(rownum++);
        int cellnum = 0;

        row.createCell(cellnum++).setCellValue("dataSetDate");
        row.createCell(cellnum++).setCellValue("curr");
        row.createCell(cellnum++).setCellValue("bankNoteAmt");
        row.createCell(cellnum++).setCellValue("nostroAmt");
        row.createCell(cellnum++).setCellValue("plcmentAmt");
        row.createCell(cellnum++).setCellValue("fibAmt");
        row.createCell(cellnum++).setCellValue("exportAmt");
        row.createCell(cellnum++).setCellValue("loanAmt");
        row.createCell(cellnum++).setCellValue("otherAmt");
        row.createCell(cellnum++).setCellValue("fwdbAmt");
        row.createCell(cellnum++).setCellValue("vostroAmt");
        row.createCell(cellnum++).setCellValue("brAmt");
        row.createCell(cellnum++).setCellValue("firAmt");
        row.createCell(cellnum++).setCellValue("fwdsAmt");

        for (PositionReport obj : positionReportList) {
            Row rowData = mySheet.createRow(rownum++);
            cellnum = 0;
            rowData.createCell(cellnum++).setCellValue(obj.getDataSetDate() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCurr() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getBankNoteAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getNostroAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getPlcmentAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getFibAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getExportAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getLoanAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getOtherAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getFwdbAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getVostroAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getBrAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getFirAmt() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getFwdsAmt() + "");
        }

        for (int j = 0; j < cellnum; j++) {
            mySheet.autoSizeColumn(j);
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    logger.debug("exportExcel : end...");
    return "excel";
}

From source file:com.kcs.action.report.BotExchangeRateAction.java

@Override
public String export() throws Exception {
    List<BexRate> list = reportService.findBotExRateForOject(exchangeRateDate);

    String tmp = exchangeRateDate.replaceAll("/", "");
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet(tmp);
    setFileName(DateUtil.getCurrentDateString(tmp).concat(".xls"));

    int rowNum = 0;
    Row headerRow = mySheet.createRow(rowNum++);

    if (null != list && list.size() > 0) {
        /* create header excel */
        int i = 0;
        Map mapHedder = (Map) list.get(0);
        Set h = mapHedder.keySet();
        Iterator it = h.iterator();
        while (it.hasNext()) {
            String its = (String) it.next();
            Cell titleCell = headerRow.createCell(i++);
            titleCell.setCellValue(DmsConstant.BEX_RATE.valueOf(its).getDesc());
        }//w w  w .j a v  a  2  s  .com

        /* create content excel */
        HSSFRow myRow = null;
        for (Iterator iter = list.iterator(); iter.hasNext();) {
            Map map = (Map) iter.next();
            Set s = map.keySet();
            Iterator o = s.iterator();
            myRow = mySheet.createRow(rowNum++);

            int j = 0;
            while (o.hasNext()) {
                String its = (String) o.next();
                String str = String.valueOf(map.get(its));
                Cell cell = myRow.createCell(j++);
                cell.setCellValue(str);
            }
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    return "excel"; //To change body of generated methods, choose Tools | Templates.
}

From source file:com.kcs.action.report.ForwardContractAction.java

@Override
public String export() throws Exception {

    setList(getService().findMaturitySummaryByCriteria(DateUtil.convertDateFromJsp(getDataSetDate())));

    getLogger().debug("exportExcel : begin...");
    getLogger().debug("exportExcel : list >>> " + getList());

    DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet("Journal");
    setFileName("Export Data Maturity (Summary) " + dateFormat.format(new Date()) + "excel".concat(".xls"));

    if (null != getList() && getList().size() > 0) {
        int rownum = 0;
        Row row = mySheet.createRow(rownum++);
        //  mySheet.addMergedRegion(rowFrom,rowTo,colFrom,colTo);
        int cellnum = 0;

        row.createCell(cellnum++).setCellValue("MaturityGroup");
        row.createCell(cellnum++).setCellValue("Ccy");
        row.createCell(cellnum++).setCellValue("BuyAmt");
        row.createCell(cellnum++).setCellValue("SellAmt");
        row.createCell(cellnum++).setCellValue("TranType");
        row.createCell(cellnum++).setCellValue("Proc Date");

        for (Maturity obj : getList()) {
            Row rowData = mySheet.createRow(rownum++);
            cellnum = 0;/* w  w w.j  a v  a2s .  c  o  m*/
            rowData.createCell(cellnum++).setCellValue(obj.getMATURITY_GROUP() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCCY() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getBUY_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getSELL_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getTRANS_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getPROC_DATE() + "");
        }
        for (int j = 0; j < cellnum; j++) {
            mySheet.autoSizeColumn(j);
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    getLogger().debug("exportExcel : end...");
    return "excel";
}

From source file:com.kcs.action.report.MaturityMediumAction.java

@Override
public String export() throws Exception {

    setList(getService().findMaturityMediumByCriteria(DateUtil.convertDateFromJsp(getDataSetDate())));

    getLogger().debug("exportExcel : begin...");
    getLogger().debug("exportExcel : list >>> " + getList());

    DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet("Journal");
    setFileName("Export Data Maturity (Medium) " + dateFormat.format(new Date()) + "excel".concat(".xls"));

    if (null != getList() && getList().size() > 0) {
        int rownum = 0;
        Row row = mySheet.createRow(rownum++);
        int cellnum = 0;

        row.createCell(cellnum++).setCellValue("MaturityGroup");
        row.createCell(cellnum++).setCellValue("Ccy");
        row.createCell(cellnum++).setCellValue("BuyAmt");
        row.createCell(cellnum++).setCellValue("SellAmt");
        row.createCell(cellnum++).setCellValue("ReportType");
        row.createCell(cellnum++).setCellValue("TranType");
        row.createCell(cellnum++).setCellValue("IpType");
        row.createCell(cellnum++).setCellValue("ClNmThai");
        row.createCell(cellnum++).setCellValue("Proc Date");

        for (Maturity obj : getList()) {
            Row rowData = mySheet.createRow(rownum++);
            cellnum = 0;//from  www  .j a  va2s . co  m
            rowData.createCell(cellnum++).setCellValue(obj.getMATURITY_GROUP() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCCY() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getBUY_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getSELL_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getREPORT_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getTRANS_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getIP_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCL_NM_THAI() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getPROC_DATE() + "");
        }
        for (int j = 0; j < cellnum; j++) {
            mySheet.autoSizeColumn(j);
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    getLogger().debug("exportExcel : end...");
    return "excel";
}

From source file:com.kcs.action.report.MaturitySummaryAction.java

@Override
public String export() throws Exception {

    setList(getService().findMaturitySummaryByCriteria(DateUtil.convertDateFromJsp(getDataSetDate())));

    getLogger().debug("exportExcel : begin...");
    getLogger().debug("exportExcel : list >>> " + getList());

    DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet("Journal");
    setFileName("Export Data Maturity (Summary) " + dateFormat.format(new Date()) + "excel".concat(".xls"));

    if (null != getList() && getList().size() > 0) {
        int rownum = 0;
        Row row = mySheet.createRow(rownum++);
        int cellnum = 0;

        row.createCell(cellnum++).setCellValue("MaturityGroup");
        row.createCell(cellnum++).setCellValue("Ccy");
        row.createCell(cellnum++).setCellValue("BuyAmt");
        row.createCell(cellnum++).setCellValue("SellAmt");
        row.createCell(cellnum++).setCellValue("TranType");
        row.createCell(cellnum++).setCellValue("Proc Date");

        for (Maturity obj : getList()) {
            Row rowData = mySheet.createRow(rownum++);
            cellnum = 0;//w  ww .  j a  v  a2 s .co m
            rowData.createCell(cellnum++).setCellValue(obj.getMATURITY_GROUP() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCCY() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getBUY_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getSELL_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getTRANS_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getPROC_DATE() + "");
        }
        for (int j = 0; j < cellnum; j++) {
            mySheet.autoSizeColumn(j);
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    getLogger().debug("exportExcel : end...");
    return "excel";
}

From source file:com.kcs.action.report.ReportJournalAction.java

@Override
public String export() throws Exception {

    list = service.findByCriteria(DateUtil.convertDateFromJsp(dataSetDate));

    getLogger().debug("exportExcel : begin...");
    getLogger().debug("exportExcel : list >>> " + list);

    DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet("Journal");
    setFileName("Export Data Journal" + dateFormat.format(new Date()) + "excel".concat(".xls"));

    if (null != list && list.size() > 0) {
        int rownum = 0;
        Row row = mySheet.createRow(rownum++);
        int cellnum = 0;

        row.createCell(cellnum++).setCellValue("JournalGroup");
        row.createCell(cellnum++).setCellValue("Ccy");
        row.createCell(cellnum++).setCellValue("BuyAmt");
        row.createCell(cellnum++).setCellValue("SellAmt");
        row.createCell(cellnum++).setCellValue("ReportType");
        row.createCell(cellnum++).setCellValue("TranType");
        row.createCell(cellnum++).setCellValue("IpType");
        row.createCell(cellnum++).setCellValue("ClNmThai");

        for (Journal obj : list) {
            Row rowData = mySheet.createRow(rownum++);
            cellnum = 0;/*from   w  w w.  j av a  2 s  . c o m*/
            rowData.createCell(cellnum++).setCellValue(obj.getJOURNAL_GROUP() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCCY() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getBUY_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getSELL_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getREPORT_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getTRANS_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getIP_TYPE() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCL_NM_THAI() + "");
        }
        for (int j = 0; j < cellnum; j++) {
            mySheet.autoSizeColumn(j);
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    getLogger().debug("exportExcel : end...");
    return "excel";
}

From source file:com.kcs.action.report.ReportJournalSummaryAction.java

@Override
public String export() throws Exception {

    list = service.findJournalSummaryByCriteria(DateUtil.convertDateFromJsp(dataSetDate));

    getLogger().debug("exportExcel : begin...");
    getLogger().debug("exportExcel : list >>> " + list);

    DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet("Journal");
    setFileName("Export Data Journal (Summary)" + dateFormat.format(new Date()) + "excel".concat(".xls"));

    if (null != list && list.size() > 0) {
        int rownum = 0;
        Row row = mySheet.createRow(rownum++);
        int cellnum = 0;

        row.createCell(cellnum++).setCellValue("JournalGroup");
        row.createCell(cellnum++).setCellValue("Ccy");
        row.createCell(cellnum++).setCellValue("BuyAmt");
        row.createCell(cellnum++).setCellValue("SellAmt");
        row.createCell(cellnum++).setCellValue("TranType");

        for (Journal obj : list) {
            Row rowData = mySheet.createRow(rownum++);
            cellnum = 0;/* w  w w . j a  v a2s.  c  o  m*/
            rowData.createCell(cellnum++).setCellValue(obj.getJOURNAL_GROUP() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getCCY() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getBUY_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getSELL_AMT() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getTRANS_TYPE() + "");
        }
        for (int j = 0; j < cellnum; j++) {
            mySheet.autoSizeColumn(j);
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    getLogger().debug("exportExcel : end...");
    return "excel";
}

From source file:com.kcs.action.ReportCompareUtilizeFwdAction.java

public String export() throws Exception {
    logger.debug("= = = = = EXPORT = = = = =");
    logger.debug("PALM : processDate >>> " + DateUtil.convertDateFromJsp(processDate) + "   reportType >>> "
            + reportType);//from   w ww  . j a  v a 2  s  .  c o  m

    list = reportCompareUtilizeFWDService.findWithCriteriaService(reportType,
            DateUtil.convertDateFromJsp(processDate));
    fileType = "XLS";

    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet("Utilize_FWD");

    if ("RPT_TYP1_41".equals(reportType)) {
        fileName = "Report_FWD_not_found_EES_(Trade_Finance)_CBS_(Remittance)_" + hidDate + ".xls";
        Row rowHeader1 = mySheet.createRow(0);
        rowHeader1.createCell(0).setCellValue(
                "? FWD ? EES (Trade Finance) & CBS (Remittance)");
    } else if ("RPT_TYP2_41".equals(reportType)) {
        fileName = "Report_EES_(Trade_Finance)_CBS_(Remittance)_not_found_FWD_" + hidDate + ".xls";
        Row rowHeader1 = mySheet.createRow(0);
        rowHeader1.createCell(0).setCellValue(
                "? EES (Trade Finance) & CBS (Remittance)? FWD");
    }
    //        Cell cell1 = CellUtil.createCell(rowHeader1, 0,"? FWD ? EES (Trade Finance) & CBS (Remittance)");
    //        CellUtil.setAlignment(cell1, myWorkBook, CellStyle.ALIGN_CENTER);

    Row rowHeader2 = mySheet.createRow(1);
    rowHeader2.createCell(0).setCellValue(processDate);
    //        Cell cell2 = CellUtil.createCell(rowHeader2, 1,processDate);
    //        CellUtil.setAlignment(cell2, myWorkBook, CellStyle.ALIGN_CENTER);

    mySheet.addMergedRegion(new CellRangeAddress(0, //first row (0-based)
            0, //last row  (0-based)
            0, //first column (0-based)
            2 //last column  (0-based)
    ));
    mySheet.addMergedRegion(new CellRangeAddress(1, //first row (0-based)
            1, //last row  (0-based)
            0, //first column (0-based)
            2 //last column  (0-based)
    ));

    if (null != list && list.size() > 0) {
        int rownum = 2;
        Row row = mySheet.createRow(rownum++);
        int cellnum = 0;

        row.createCell(cellnum++).setCellValue("Curr");
        row.createCell(cellnum++).setCellValue("Fi Arrg No");
        row.createCell(cellnum++).setCellValue("Amount");

        for (ReportCompareUtilizeFwd obj : list) {
            Row rowData = mySheet.createRow(rownum++);
            cellnum = 0;
            rowData.createCell(cellnum++).setCellValue(obj.getCURR() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getFI_ARRG_NO() + "");
            rowData.createCell(cellnum++).setCellValue(obj.getAMT() + "");
        }

        for (int j = 0; j < cellnum; j++) {
            mySheet.autoSizeColumn(j);
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    logger.debug("exportExcel : end...");
    return "excel";

    //        return REPORT;
}

From source file:com.kcs.core.actions.ExportDataAction.java

public String exportExcel() throws Exception {
    logger.debug("exportExcel : begin...");
    list = manageService.findListDinamicSql(sql);
    logger.debug("exportExcel : list >>> " + list);

    Calendar calendar = Calendar.getInstance();
    HSSFWorkbook myWorkBook = new HSSFWorkbook();
    HSSFSheet mySheet = myWorkBook.createSheet(DateUtil.getCurrentDateString(DateUtil.DATE_FORMAT_YYYYMMDD));
    setFileName(DateUtil.getCurrentDateString(DateUtil.DATE_FORMAT_YYYYMMDD).concat(".xls"));

    Row headerRow = mySheet.createRow(0);
    if (null != list && list.size() > 0) {
        /* create header excel */
        int i = 0;
        Map mapHedder = (Map) list.get(0);
        Set h = mapHedder.keySet();
        Iterator it = h.iterator();
        while (it.hasNext()) {
            String its = (String) it.next();
            Cell titleCell = headerRow.createCell(i++);
            titleCell.setCellValue(its);
        }/*w w w.ja va  2  s.  co m*/

        /* create content excel */
        int rowNum = 1;
        HSSFRow myRow = null;
        for (Iterator iter = list.iterator(); iter.hasNext();) {
            Map map = (Map) iter.next();
            Set s = map.keySet();
            Iterator tmp = s.iterator();
            myRow = mySheet.createRow(rowNum++);

            logger.debug("***************************************************");
            int j = 0;
            while (tmp.hasNext()) {
                String its = (String) tmp.next();
                String str = String.valueOf(map.get(its));
                //                    logger.debug("str["+j+"] >>> "+str);

                Cell cell = myRow.createCell(j++);
                cell.setCellValue(str);
            }
        }
    }

    ByteArrayOutputStream boas = new ByteArrayOutputStream();
    myWorkBook.write(boas);
    setExcelStream(new ByteArrayInputStream(boas.toByteArray()));

    logger.debug("exportExcel : end...");
    return "excel";
}

From source file:com.kiwisoft.db.export.ExcelExporter.java

License:Open Source License

public void exportTable(JTable table, SQLStatement statement, File file, ExportConfiguration configuration)
        throws Exception {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet("Query");
    TableColumnModel columnModel = table.getColumnModel();
    ResultSetTableModel tableModel = (ResultSetTableModel) table.getModel();
    HSSFFont headerFont = workbook.createFont();
    headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
    HSSFCellStyle headerStyle = workbook.createCellStyle();
    headerStyle.setFont(headerFont);/*from   w w  w. j  a v  a 2 s .  com*/
    headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    int rowNum = 0;
    HSSFRow row = sheet.createRow(rowNum++);
    sheet.createFreezePane(0, 1);
    int columnCount = columnModel.getColumnCount();
    for (short i = 0; i < columnCount; i++) {
        TableColumn column = columnModel.getColumn(i);
        int columnIndex = column.getModelIndex();
        HSSFCell cell = row.createCell(i);
        cell.setCellStyle(headerStyle);
        String columnName = tableModel.getColumnName(columnIndex);
        cell.setCellValue(columnName);
    }
    for (int j = 0; j < tableModel.getRowCount(); j++) {
        row = sheet.createRow(rowNum++);
        for (short i = 0; i < columnCount; i++) {
            TableColumn column = columnModel.getColumn(i);
            int columnIndex = column.getModelIndex();
            Object cellValue = tableModel.getValueAt(j, columnIndex);
            HSSFCell cell = row.createCell(i);
            if (cellValue instanceof Number)
                cell.setCellValue(((Number) cellValue).doubleValue());
            else if (cellValue instanceof Date) {

                HSSFCellStyle style = workbook.createCellStyle();
                style.setDataFormat((short) 14);
                cell.setCellValue((Date) cellValue);
                cell.setCellStyle(style);
            } else if (cellValue instanceof Boolean)
                cell.setCellValue(((Boolean) cellValue).booleanValue());
            else if (cellValue != null)
                cell.setCellValue(cellValue.toString());
        }
    }
    FileOutputStream out = new FileOutputStream(file);
    workbook.write(out);
    Field field = ClassLoader.class.getDeclaredField("classes");
    field.setAccessible(true);
    Vector classes = (Vector) field.get(HSSFWorkbook.class.getClassLoader());
    field.setAccessible(false);
    System.out.println("classes = " + StringUtils.enumerate(classes, "\n"));
    out.close();
}