Example usage for org.apache.poi.hssf.usermodel HSSFCell getStringCellValue

List of usage examples for org.apache.poi.hssf.usermodel HSSFCell getStringCellValue

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFCell
  6. getStringCellValue

Introduction

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

Prototype

public String getStringCellValue()

Source Link

Document

get the value of the cell as a string - for numeric cells we throw an exception.

Usage

From source file:com.ibm.asset.trails.service.impl.CauseCodeServiceImpl.java

private Date convertTextToDate(HSSFCell cell) {
    Date formattedDate = null;//  w w  w .  jav  a 2 s .co m

    if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
        String dateText = cell.getStringCellValue();
        if (dateText != null && !"".equals(dateText.trim())) {
            dateText = dateText.trim();
            int dateLen = dateText.length();
            if (dateLen == 10) {
                boolean dashFormat = dateText.indexOf(DASH) != -1;
                if (dashFormat) {//DASH Date Format: YYYY-MM-DD
                    SimpleDateFormat format = new SimpleDateFormat(DATE_FORMAT1);
                    try {
                        format.setLenient(false);
                        formattedDate = format.parse(dateText);
                    } catch (ParseException e) {
                        formattedDate = null;
                    }
                } else {
                    SimpleDateFormat format = new SimpleDateFormat(DATE_FORMAT2);//SLASH Date Format: YYYY/MM/DD
                    try {
                        format.setLenient(false);
                        formattedDate = format.parse(dateText);
                    } catch (ParseException e) {
                        format = new SimpleDateFormat(DATE_FORMAT3);//SLASH Date Format: MM/DD/YYYY
                        try {
                            format.setLenient(false);
                            formattedDate = format.parse(dateText);
                        } catch (ParseException ex) {
                            formattedDate = null;
                        }
                    }
                }
            }
        }

    }

    return formattedDate;
}

From source file:com.ibm.asset.trails.service.impl.CauseCodeServiceImpl.java

@SuppressWarnings("unchecked")
private boolean isAlertCauseExists(HSSFCell cell) {
    String alertCause;/*ww  w  .j ava2  s . c  o m*/
    if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
        alertCause = cell.getStringCellValue();
    } else {
        return false;
    }

    if (alertCause.length() > 128) {
        alertCause = alertCause.substring(0, 128);
    }

    if (alertCause == null || "".equals(alertCause)) {
        return false;
    }

    List<AlertCause> acList = null;
    try {
        acList = getEntityManager().createNamedQuery("findActiveAlertCauseByNameAndTypeId")
                .setParameter("alertCauseName", alertCause.trim().toUpperCase())
                .setParameter("alertTypeId", this.getAlertTypeIdByCode(colIndexes.getAlertTypeCode()))
                .getResultList();
    } catch (Exception e) {
        log.error(e.getMessage(), e);
    }
    return acList.size() >= 1;
}

From source file:com.ibm.asset.trails.service.impl.CauseCodeServiceImpl.java

private Long parseCauseCodeIdCell(HSSFCell cell) {

    long causeCodeId;
    if (cell != null && cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
        String content = cell.getStringCellValue();
        Pattern pattern = Pattern.compile("[0-9]*");
        if (!pattern.matcher(content).matches()) {
            return null;
        }// w  w w  . j av  a2s  .c  om
        causeCodeId = Long.valueOf(content);
    } else if (cell != null && cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
        causeCodeId = Math.round(cell.getNumericCellValue());
    } else {
        return null;
    }
    return causeCodeId;
}

From source file:com.ideaspymes.arthyweb.ventas.web.controllers.VentasCantadasBean.java

private void generarTotal3(HSSFRow rowTotal3, int indexFinGrupo, CellStyle style, HSSFCell cellTerr,
        HSSFSheet sheet) {//w ww .  j a  v  a2  s.co m
    HSSFCell cellTotal3Territorio = rowTotal3.createCell(indexCol);
    sheet.addMergedRegion(CellRangeAddress.valueOf("$" + CellReference.convertNumToColString(indexCol) + "$"
            + indexRow + ":$" + CellReference.convertNumToColString(indexCol + 1) + "$" + indexRow));
    cellTotal3Territorio.setCellValue("Part. De Emb / " + cellTerr.getStringCellValue());
    cellTotal3Territorio.setCellStyle(styleTerritorioTotal3);

    HSSFCell cellTotal3Territorio1 = rowTotal3.createCell(indexCol + 1);
    cellTotal3Territorio1.setCellStyle(styleTerritorioTotal3);

    HSSFCell cellTotal3Boletas = rowTotal3.createCell(indexCol + 2);
    cellTotal3Boletas.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Red20g = rowTotal3.createCell(indexCol + 3);
    cellTotal3Red20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Red20g.setCellFormula(CellReference.convertNumToColString(indexCol + 3) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Red20g.setCellStyle(style);

    HSSFCell cellTotal3Red20c = rowTotal3.createCell(indexCol + 4);
    cellTotal3Red20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Blue20g = rowTotal3.createCell(indexCol + 5);
    cellTotal3Blue20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Blue20g.setCellFormula(CellReference.convertNumToColString(indexCol + 5) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Blue20g.setCellStyle(style);

    HSSFCell cellTotal3Blue20c = rowTotal3.createCell(indexCol + 6);
    cellTotal3Blue20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Green20g = rowTotal3.createCell(indexCol + 7);
    cellTotal3Green20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Green20g.setCellFormula(CellReference.convertNumToColString(indexCol + 7) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Green20g.setCellStyle(style);

    HSSFCell cellTotal3Green20c = rowTotal3.createCell(indexCol + 8);
    cellTotal3Green20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Tres20g = rowTotal3.createCell(indexCol + 9);
    cellTotal3Tres20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Tres20g.setCellFormula(CellReference.convertNumToColString(indexCol + 9) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Tres20g.setCellStyle(style);

    HSSFCell cellTotal3Tres20c = rowTotal3.createCell(indexCol + 10);
    cellTotal3Tres20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Duo20g = rowTotal3.createCell(indexCol + 11);
    cellTotal3Duo20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Duo20g.setCellFormula(CellReference.convertNumToColString(indexCol + 11) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Duo20g.setCellStyle(style);

    HSSFCell cellTotal3Duo20c = rowTotal3.createCell(indexCol + 12);
    cellTotal3Duo20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Red10g = rowTotal3.createCell(indexCol + 13);
    cellTotal3Red10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Red10g.setCellFormula(CellReference.convertNumToColString(indexCol + 13) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Red10g.setCellStyle(style);

    HSSFCell cellTotal3Red10c = rowTotal3.createCell(indexCol + 14);
    cellTotal3Red10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Blue10g = rowTotal3.createCell(indexCol + 15);
    cellTotal3Blue10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Blue10g.setCellFormula(CellReference.convertNumToColString(indexCol + 15) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Blue10g.setCellStyle(style);

    HSSFCell cellTotal3Blue10c = rowTotal3.createCell(indexCol + 16);
    cellTotal3Blue10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Green10g = rowTotal3.createCell(indexCol + 17);
    cellTotal3Green10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Green10g.setCellFormula(CellReference.convertNumToColString(indexCol + 17) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Green10g.setCellStyle(style);

    HSSFCell cellTotal3Green10c = rowTotal3.createCell(indexCol + 18);
    cellTotal3Green10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Tres10g = rowTotal3.createCell(indexCol + 19);
    cellTotal3Tres10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Tres10g.setCellFormula(CellReference.convertNumToColString(indexCol + 19) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Tres10g.setCellStyle(style);

    HSSFCell cellTotal3Tres10c = rowTotal3.createCell(indexCol + 20);
    cellTotal3Tres10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3Duo10g = rowTotal3.createCell(indexCol + 21);
    cellTotal3Duo10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3Duo10g.setCellFormula(CellReference.convertNumToColString(indexCol + 21) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3Duo10g.setCellStyle(style);

    HSSFCell cellTotal3Duo10c = rowTotal3.createCell(indexCol + 22);
    cellTotal3Duo10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3SM20g = rowTotal3.createCell(indexCol + 23);
    cellTotal3SM20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3SM20g.setCellFormula(CellReference.convertNumToColString(indexCol + 23) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3SM20g.setCellStyle(style);

    HSSFCell cellTotal3SM20c = rowTotal3.createCell(indexCol + 24);
    cellTotal3SM20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3SM10g = rowTotal3.createCell(indexCol + 25);
    cellTotal3SM10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3SM10g.setCellFormula(CellReference.convertNumToColString(indexCol + 25) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3SM10g.setCellStyle(style);

    HSSFCell cellTotal3SM10c = rowTotal3.createCell(indexCol + 26);
    cellTotal3SM10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3SMSoftg = rowTotal3.createCell(indexCol + 27);
    cellTotal3SMSoftg.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3SMSoftg.setCellFormula(CellReference.convertNumToColString(indexCol + 27) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3SMSoftg.setCellStyle(style);

    HSSFCell cellTotal3SMSoftc = rowTotal3.createCell(indexCol + 28);
    cellTotal3SMSoftc.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3K20g = rowTotal3.createCell(indexCol + 29);
    cellTotal3K20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3K20g.setCellFormula(CellReference.convertNumToColString(indexCol + 29) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3K20g.setCellStyle(style);

    HSSFCell cellTotal3K20c = rowTotal3.createCell(indexCol + 30);
    cellTotal3K20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3K10g = rowTotal3.createCell(indexCol + 31);
    cellTotal3K10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3K10g.setCellFormula(CellReference.convertNumToColString(indexCol + 31) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3K10g.setCellStyle(style);

    HSSFCell cellTotal3K10c = rowTotal3.createCell(indexCol + 32);
    cellTotal3K10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3KSoftg = rowTotal3.createCell(indexCol + 33);
    cellTotal3KSoftg.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3KSoftg.setCellFormula(CellReference.convertNumToColString(indexCol + 33) + (indexFinGrupo + 1)
            + "/$" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3KSoftg.setCellStyle(style);

    HSSFCell cellTotal3KSoftc = rowTotal3.createCell(indexCol + 34);
    cellTotal3KSoftc.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal3g = rowTotal3.createCell(indexCol + 35);
    cellTotal3g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal3g.setCellFormula(CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1) + "/$"
            + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1));
    cellTotal3g.setCellStyle(style);

    HSSFCell cellTotal3c = rowTotal3.createCell(indexCol + 36);
    cellTotal3c.setCellStyle(styleCantidadGris);

    HSSFCell cellTotal3caja = rowTotal3.createCell(indexCol + 37);
    cellTotal3caja.setCellStyle(styleCantidadNegrita);

    HSSFCell cellTotal3gr = rowTotal3.createCell(indexCol + 38);
    cellTotal3gr.setCellStyle(styleCantidadNegrita);

}

From source file:com.ideaspymes.arthyweb.ventas.web.controllers.VentasCantadasBean.java

private void generarTotal2(HSSFRow rowTotal2, int indexFinGrupo, String[] aColsGrue, HSSFCell cellTerr) {
    HSSFCell cellTotal2Territorio = rowTotal2.createCell(indexCol);
    cellTotal2Territorio.setCellValue("Total " + cellTerr.getStringCellValue() + " - Cajas");
    cellTotal2Territorio.setCellStyle(styleTerritorioTotal1);

    HSSFCell cellTotal2Boletas = rowTotal2.createCell(indexCol + 2);
    cellTotal2Boletas.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Red20g = rowTotal2.createCell(indexCol + 3);
    cellTotal2Red20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Red20g/*from w ww  .  j ava 2s.  co  m*/
            .setCellFormula(CellReference.convertNumToColString(indexCol + 3) + (indexFinGrupo + 1) + "/50");
    cellTotal2Red20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Red20c = rowTotal2.createCell(indexCol + 4);
    cellTotal2Red20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Blue20g = rowTotal2.createCell(indexCol + 5);
    cellTotal2Blue20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Blue20g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 5) + (indexFinGrupo + 1) + "/50");
    cellTotal2Blue20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Blue20c = rowTotal2.createCell(indexCol + 6);
    cellTotal2Blue20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Green20g = rowTotal2.createCell(indexCol + 7);
    cellTotal2Green20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Green20g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 7) + (indexFinGrupo + 1) + "/50");
    cellTotal2Green20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Green20c = rowTotal2.createCell(indexCol + 8);
    cellTotal2Green20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Tres20g = rowTotal2.createCell(indexCol + 9);
    cellTotal2Tres20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Tres20g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 9) + (indexFinGrupo + 1) + "/50");
    cellTotal2Tres20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Tres20c = rowTotal2.createCell(indexCol + 10);
    cellTotal2Tres20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Duo20g = rowTotal2.createCell(indexCol + 11);
    cellTotal2Duo20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Duo20g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 11) + (indexFinGrupo + 1) + "/50");
    cellTotal2Duo20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Duo20c = rowTotal2.createCell(indexCol + 12);
    cellTotal2Duo20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Red10g = rowTotal2.createCell(indexCol + 13);
    cellTotal2Red10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Red10g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 13) + (indexFinGrupo + 1) + "/50");
    cellTotal2Red10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Red10c = rowTotal2.createCell(indexCol + 14);
    cellTotal2Red10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Blue10g = rowTotal2.createCell(indexCol + 15);
    cellTotal2Blue10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Blue10g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 15) + (indexFinGrupo + 1) + "/50");
    cellTotal2Blue10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Blue10c = rowTotal2.createCell(indexCol + 16);
    cellTotal2Blue10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Green10g = rowTotal2.createCell(indexCol + 17);
    cellTotal2Green10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Green10g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 17) + (indexFinGrupo + 1) + "/50");
    cellTotal2Green10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Green10c = rowTotal2.createCell(indexCol + 18);
    cellTotal2Green10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Tres10g = rowTotal2.createCell(indexCol + 19);
    cellTotal2Tres10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Tres10g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 19) + (indexFinGrupo + 1) + "/50");
    cellTotal2Tres10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Tres10c = rowTotal2.createCell(indexCol + 20);
    cellTotal2Tres10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Duo10g = rowTotal2.createCell(indexCol + 21);
    cellTotal2Duo10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2Duo10g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 21) + (indexFinGrupo + 1) + "/50");
    cellTotal2Duo10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2Duo10c = rowTotal2.createCell(indexCol + 22);
    cellTotal2Duo10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2SM20g = rowTotal2.createCell(indexCol + 23);
    cellTotal2SM20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2SM20g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 23) + (indexFinGrupo + 1) + "/50");
    cellTotal2SM20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2SM20c = rowTotal2.createCell(indexCol + 24);
    cellTotal2SM20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2SM10g = rowTotal2.createCell(indexCol + 25);
    cellTotal2SM10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2SM10g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 25) + (indexFinGrupo + 1) + "/50");
    cellTotal2SM10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2SM10c = rowTotal2.createCell(indexCol + 26);
    cellTotal2SM10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2SMSoftg = rowTotal2.createCell(indexCol + 27);
    cellTotal2SMSoftg.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2SMSoftg
            .setCellFormula(CellReference.convertNumToColString(indexCol + 27) + (indexFinGrupo + 1) + "/50");
    cellTotal2SMSoftg.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2SMSoftc = rowTotal2.createCell(indexCol + 28);
    cellTotal2SMSoftc.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2K20g = rowTotal2.createCell(indexCol + 29);
    cellTotal2K20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2K20g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 29) + (indexFinGrupo + 1) + "/50");
    cellTotal2K20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2K20c = rowTotal2.createCell(indexCol + 30);
    cellTotal2K20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2K10g = rowTotal2.createCell(indexCol + 31);
    cellTotal2K10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2K10g
            .setCellFormula(CellReference.convertNumToColString(indexCol + 31) + (indexFinGrupo + 1) + "/50");
    cellTotal2K10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2K10c = rowTotal2.createCell(indexCol + 32);
    cellTotal2K10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal2KSoftg = rowTotal2.createCell(indexCol + 33);
    cellTotal2KSoftg.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2KSoftg
            .setCellFormula(CellReference.convertNumToColString(indexCol + 33) + (indexFinGrupo + 1) + "/50");
    cellTotal2KSoftg.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal22KSoftc = rowTotal2.createCell(indexCol + 34);
    cellTotal22KSoftc.setCellStyle(styleCantidadAzul);

    String formTotal2Cajas = "";
    for (int i = 0; i < aColsGrue.length; i++) {
        formTotal2Cajas += aColsGrue[i] + (indexFinGrupo + 2) + "+";
    }
    formTotal2Cajas += "0";

    HSSFCell cellTotal2g = rowTotal2.createCell(indexCol + 35);
    cellTotal2g.setCellStyle(styleCantidadGris);

    HSSFCell cellTotal2c = rowTotal2.createCell(indexCol + 36);
    cellTotal2c.setCellStyle(styleCantidadGris);

    HSSFCell cellTotal2caja = rowTotal2.createCell(indexCol + 37);
    cellTotal2caja.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal2caja.setCellFormula(formTotal2Cajas);
    cellTotal2caja.setCellStyle(styleCantidadNegrita);

    HSSFCell cellTotal2gr = rowTotal2.createCell(indexCol + 38);
    cellTotal2gr.setCellStyle(styleCantidadNegrita);

}

From source file:com.ideaspymes.arthyweb.ventas.web.controllers.VentasCantadasBean.java

private void generarTotal1(HSSFRow rowTotal1, int indexInicioGrupo, int indexFinGrupo, String[] aColsGrue,
        String[] aCols20, String[] aCols10, HSSFCell cellTerr) {
    HSSFCell cellTotal1Territorio = rowTotal1.createCell(indexCol);
    cellTotal1Territorio.setCellValue("Total " + cellTerr.getStringCellValue());
    cellTotal1Territorio.setCellStyle(styleTerritorioTotal1);

    HSSFCell cellTotal1Boleta = rowTotal1.createCell(indexCol + 2);
    cellTotal1Boleta.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Boleta.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 2)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 2) + indexFinGrupo + ")");
    cellTotal1Boleta.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Red20g = rowTotal1.createCell(indexCol + 3);
    cellTotal1Red20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Red20g.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 3)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 3) + indexFinGrupo + ")");
    cellTotal1Red20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Red20c = rowTotal1.createCell(indexCol + 4);
    cellTotal1Red20c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Red20c.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 4)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 4) + indexFinGrupo + ")");
    cellTotal1Red20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Blue20g = rowTotal1.createCell(indexCol + 5);
    cellTotal1Blue20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Blue20g.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 5)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 5) + indexFinGrupo + ")");
    cellTotal1Blue20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Blue20c = rowTotal1.createCell(indexCol + 6);
    cellTotal1Blue20c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Blue20c.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 6)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 6) + indexFinGrupo + ")");
    cellTotal1Blue20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Green20g = rowTotal1.createCell(indexCol + 7);
    cellTotal1Green20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Green20g.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 7)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 7) + indexFinGrupo + ")");
    cellTotal1Green20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Green20c = rowTotal1.createCell(indexCol + 8);
    cellTotal1Green20c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Green20c.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 8)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 8) + indexFinGrupo + ")");
    cellTotal1Green20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Tres20g = rowTotal1.createCell(indexCol + 9);
    cellTotal1Tres20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Tres20g.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 9)
            + indexInicioGrupo + ":" + CellReference.convertNumToColString(indexCol + 9) + indexFinGrupo + ")");
    cellTotal1Tres20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Tres20c = rowTotal1.createCell(indexCol + 10);
    cellTotal1Tres20c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Tres20c/* www .  j  a  va 2s.c  om*/
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 10) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 10) + indexFinGrupo + ")");
    cellTotal1Tres20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Duo20g = rowTotal1.createCell(indexCol + 11);
    cellTotal1Duo20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Duo20g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 11) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 11) + indexFinGrupo + ")");
    cellTotal1Duo20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Duo20c = rowTotal1.createCell(indexCol + 12);
    cellTotal1Duo20c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Duo20c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 12) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 12) + indexFinGrupo + ")");
    cellTotal1Duo20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Red10g = rowTotal1.createCell(indexCol + 13);
    cellTotal1Red10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Red10g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 13) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 13) + indexFinGrupo + ")");
    cellTotal1Red10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Red10c = rowTotal1.createCell(indexCol + 14);
    cellTotal1Red10c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Red10c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 14) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 14) + indexFinGrupo + ")");
    cellTotal1Red10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Blue10g = rowTotal1.createCell(indexCol + 15);
    cellTotal1Blue10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Blue10g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 15) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 15) + indexFinGrupo + ")");
    cellTotal1Blue10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Blue10c = rowTotal1.createCell(indexCol + 16);
    cellTotal1Blue10c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Blue10c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 16) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 16) + indexFinGrupo + ")");
    cellTotal1Blue10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Green10g = rowTotal1.createCell(indexCol + 17);
    cellTotal1Green10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Green10g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 17) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 17) + indexFinGrupo + ")");
    cellTotal1Green10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Green10c = rowTotal1.createCell(indexCol + 18);
    cellTotal1Green10c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Green10c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 18) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 18) + indexFinGrupo + ")");
    cellTotal1Green10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Tres10g = rowTotal1.createCell(indexCol + 19);
    cellTotal1Tres10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Tres10g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 19) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 19) + indexFinGrupo + ")");
    cellTotal1Tres10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Tres10c = rowTotal1.createCell(indexCol + 20);
    cellTotal1Tres10c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Tres10c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 20) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 20) + indexFinGrupo + ")");
    cellTotal1Tres10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Duo10g = rowTotal1.createCell(indexCol + 21);
    cellTotal1Duo10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Duo10g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 21) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 21) + indexFinGrupo + ")");
    cellTotal1Duo10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1Duo10c = rowTotal1.createCell(indexCol + 22);
    cellTotal1Duo10c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1Duo10c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 22) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 22) + indexFinGrupo + ")");
    cellTotal1Duo10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1SM20g = rowTotal1.createCell(indexCol + 23);
    cellTotal1SM20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1SM20g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 23) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 23) + indexFinGrupo + ")");
    cellTotal1SM20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1SM20c = rowTotal1.createCell(indexCol + 24);
    cellTotal1SM20c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1SM20c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 24) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 24) + indexFinGrupo + ")");
    cellTotal1SM20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1SM10g = rowTotal1.createCell(indexCol + 25);
    cellTotal1SM10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1SM10g
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 25) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 25) + indexFinGrupo + ")");
    cellTotal1SM10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1SM10c = rowTotal1.createCell(indexCol + 26);
    cellTotal1SM10c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1SM10c
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 26) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 26) + indexFinGrupo + ")");
    cellTotal1SM10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1SMSoftg = rowTotal1.createCell(indexCol + 27);
    cellTotal1SMSoftg.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1SMSoftg
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 27) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 27) + indexFinGrupo + ")");
    cellTotal1SMSoftg.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1SMSoftc = rowTotal1.createCell(indexCol + 28);
    cellTotal1SMSoftc.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1SMSoftc
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 28) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 28) + indexFinGrupo + ")");
    cellTotal1SMSoftc.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1K20g = rowTotal1.createCell(indexCol + 29);
    cellTotal1K20g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1K20g.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 29) + indexInicioGrupo
            + ":" + CellReference.convertNumToColString(indexCol + 29) + indexFinGrupo + ")");
    cellTotal1K20g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1K20c = rowTotal1.createCell(indexCol + 30);
    cellTotal1K20c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1K20c.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 30) + indexInicioGrupo
            + ":" + CellReference.convertNumToColString(indexCol + 30) + indexFinGrupo + ")");
    cellTotal1K20c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1K10g = rowTotal1.createCell(indexCol + 31);
    cellTotal1K10g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1K10g.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 31) + indexInicioGrupo
            + ":" + CellReference.convertNumToColString(indexCol + 31) + indexFinGrupo + ")");
    cellTotal1K10g.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1K10c = rowTotal1.createCell(indexCol + 32);
    cellTotal1K10c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1K10c.setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 32) + indexInicioGrupo
            + ":" + CellReference.convertNumToColString(indexCol + 32) + indexFinGrupo + ")");
    cellTotal1K10c.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1KSoftg = rowTotal1.createCell(indexCol + 33);
    cellTotal1KSoftg.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1KSoftg
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 33) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 33) + indexFinGrupo + ")");
    cellTotal1KSoftg.setCellStyle(styleCantidadAzul);

    HSSFCell cellTotal1KSoftc = rowTotal1.createCell(indexCol + 34);
    cellTotal1KSoftc.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1KSoftc
            .setCellFormula("SUM(" + CellReference.convertNumToColString(indexCol + 34) + indexInicioGrupo + ":"
                    + CellReference.convertNumToColString(indexCol + 34) + indexFinGrupo + ")");
    cellTotal1KSoftc.setCellStyle(styleCantidadAzul);

    String formTotal1Grue = "";
    for (int i = 0; i < aColsGrue.length; i++) {
        formTotal1Grue += aColsGrue[i] + (indexFinGrupo + 1) + "+";
    }
    formTotal1Grue += "0";

    String formTotal120 = "";
    for (int i = 0; i < aCols20.length; i++) {
        formTotal120 += aCols20[i] + (indexFinGrupo + 1) + "+";
    }

    formTotal120 += "0";
    String formTotal110 = "";
    for (int i = 0; i < aCols10.length; i++) {
        formTotal110 += aCols10[i] + (indexFinGrupo + 1) + "+";
    }
    formTotal110 += "0";

    HSSFCell cellTotal1g = rowTotal1.createCell(indexCol + 35);
    cellTotal1g.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1g.setCellFormula(
            "(INT((" + formTotal120 + ")/10))+" + "(INT((" + formTotal110 + ")/20)) +(" + formTotal1Grue + ")");
    cellTotal1g.setCellStyle(styleCantidadGris);

    HSSFCell cellTotal1c = rowTotal1.createCell(indexCol + 36);
    cellTotal1c.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1c.setCellFormula("MOD((" + formTotal110 + "),20)+ MOD((" + formTotal120 + "),10)");
    cellTotal1c.setCellStyle(styleCantidadGris);

    HSSFCell cellTotal1ca = rowTotal1.createCell(indexCol + 37);
    cellTotal1ca.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1ca.setCellFormula(
            "(INT(" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1) + "/50))");
    cellTotal1ca.setCellStyle(styleCantidadNegrita);

    HSSFCell cellTotal1gr = rowTotal1.createCell(indexCol + 38);
    cellTotal1gr.setCellType(HSSFCell.CELL_TYPE_FORMULA);
    cellTotal1gr.setCellFormula(
            "(MOD(" + CellReference.convertNumToColString(indexCol + 35) + (indexFinGrupo + 1) + ",50))");
    cellTotal1gr.setCellStyle(styleCantidadNegrita);

}

From source file:com.inet.web.service.mail.utils.ImportUtil.java

License:Open Source License

/**
 * get String//  w  w w  . j  a  v  a 2  s.  c  o m
 * @param rowData
 * @param index
 * @return
 */
private static String getString(HSSFRow rowData, int index) {
    HSSFCell cell = rowData.getCell(index);
    if (cell == null) {
        return StringService.EMPTY_STRING;
    } else if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
        return cell.getStringCellValue();
    } else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
        return String.valueOf((new Double(cell.getNumericCellValue())).longValue());
    } else if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) {
        return StringService.EMPTY_STRING;
    } else {
        return StringService.EMPTY_STRING;
    }
}

From source file:com.inet.web.service.mail.utils.ImportUtil.java

License:Open Source License

/**
 * get Long/*from   w  w w. ja va2  s .  c o m*/
 * @param rowData
 * @param index
 * @return
 */
private static long getLong(HSSFRow rowData, int index) {
    HSSFCell cell = rowData.getCell(index);

    if (cell == null) {
        return 0L;
    } else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
        return (new Double(cell.getNumericCellValue())).longValue();
    } else if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
        return (new Double(cell.getStringCellValue())).longValue();
    } else {
        return 0L;
    }
}

From source file:com.isotrol.impe3.idx.oc.extractors.ExtractorMsExcel.java

License:Open Source License

/**
 * Extracts the text from the Excel table content.<p>
 * /*from   w  w w . jav  a2  s  .  co  m*/
 * @param in the document input stream
 * @return the extracted text
 * @throws IOException if something goes wring
 * @deprecated
 */
protected String extractTableContent(InputStream in) throws IOException {

    HSSFWorkbook excelWb = new HSSFWorkbook(in);
    StringBuffer result = new StringBuffer(4096);

    int numberOfSheets = excelWb.getNumberOfSheets();

    for (int i = 0; i < numberOfSheets; i++) {
        HSSFSheet sheet = excelWb.getSheetAt(i);
        int numberOfRows = sheet.getPhysicalNumberOfRows();
        if (numberOfRows > 0) {

            if (excelWb.getSheetName(i) != null && !excelWb.getSheetName(i).trim().equals("")) {
                // append sheet name to content
                if (i > 0) {
                    result.append("\n\n");
                }
                result.append(excelWb.getSheetName(i).trim());
                result.append(":\n\n");
            }

            Iterator<?> rowIt = sheet.rowIterator();
            while (rowIt.hasNext()) {
                HSSFRow row = (HSSFRow) rowIt.next();
                if (row != null) {
                    boolean hasContent = false;
                    Iterator<?> it = row.cellIterator();
                    while (it.hasNext()) {
                        HSSFCell cell = (HSSFCell) it.next();
                        String text = null;
                        try {
                            switch (cell.getCellType()) {
                            case HSSFCell.CELL_TYPE_BLANK:
                            case HSSFCell.CELL_TYPE_ERROR:
                                // ignore all blank or error cells
                                break;
                            case HSSFCell.CELL_TYPE_NUMERIC:
                                text = Double.toString(cell.getNumericCellValue());
                                break;
                            case HSSFCell.CELL_TYPE_BOOLEAN:
                                text = Boolean.toString(cell.getBooleanCellValue());
                                break;
                            case HSSFCell.CELL_TYPE_STRING:
                            default:
                                text = cell.getStringCellValue();
                                break;
                            }
                        } catch (Exception e) {
                            // ignore this cell
                        }
                        if ((text != null) && (text.length() != 0)) {
                            result.append(text.trim());
                            result.append(' ');
                            hasContent = true;
                        }
                    }
                    if (hasContent) {
                        // append a newline at the end of each row that has content
                        result.append('\n');
                    }
                }
            }
        }
    }

    return result.toString();
}

From source file:com.jitendrasinghnz.excelreadutility.ExcelReadStringArrayXSL.java

License:Open Source License

public String convertCellToString(HSSFCell cell) {
    int type;//from   w  w  w  . jav a 2s.c om
    if (cell == null) {
        type = Cell.CELL_TYPE_BLANK;
    } else {
        type = cell.getCellType();
    }
    Object result;
    switch (type) {
    case Cell.CELL_TYPE_STRING:
        result = cell.getStringCellValue();
        break;
    case Cell.CELL_TYPE_NUMERIC:
        result = cell.getNumericCellValue();
        break;
    case Cell.CELL_TYPE_BLANK:
        result = "";
        break;
    case Cell.CELL_TYPE_BOOLEAN:
        result = cell.getBooleanCellValue();
        break;
    case Cell.CELL_TYPE_ERROR:
        result = cell.getErrorCellValue();
        break;
    case Cell.CELL_TYPE_FORMULA:
        result = cell.getCellFormula();
        break;

    default:
        throw new RuntimeException("There are no support fot the cell type");
    }
    return result.toString();
}