Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook write

List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook write

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFWorkbook
  6. write

Introduction

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

Prototype

private void write(POIFSFileSystem fs) throws IOException

Source Link

Document

Writes the workbook out to a brand new, empty POIFS

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  o m
            .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  .co m*/

        /* 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;/*from ww w .  j  av a  2s  .  c  om*/
            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;/* w ww.j  a  v a2s . c  om*/
            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;/*from   w  w w.  ja  v a 2s  .  c  om*/
            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;/*ww w  .  ja v  a2  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;//from   w ww . java  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.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 ww  w  .  j av a 2s .  c  om*/

    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);
        }/*from www.  j av a2 s . c om*/

        /* 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);/*  ww  w  .  j a va2 s.c  o m*/
    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();
}