Example usage for org.apache.poi.hssf.usermodel HSSFRow createCell

List of usage examples for org.apache.poi.hssf.usermodel HSSFRow createCell

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFRow
  6. createCell

Introduction

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

Prototype

@Override
public HSSFCell createCell(int column)

Source Link

Document

Use this to create new cells within the row and return it.

Usage

From source file:com.qcadoo.mes.qualityControls.print.QualityControlForOrderXlsView.java

License:Open Source License

private void addOrderSeries(final Map<String, Object> model, final HSSFSheet sheet, final Locale locale) {
    int rowNum = 1;
    Map<Entity, List<Entity>> productOrders = qualityControlsReportService.getQualityOrdersForProduct(
            qualityControlsReportService.getOrderSeries(model, "qualityControlsForOrder"));
    productOrders = SortUtil.sortMapUsingComparator(productOrders, new EntityNumberComparator());
    for (Entry<Entity, List<Entity>> entry : productOrders.entrySet()) {
        List<Entity> orders = entry.getValue();
        Collections.sort(orders, new EntityNumberComparator());
        for (Entity order : orders) {
            HSSFRow row = sheet.createRow(rowNum++);
            row.createCell(0)
                    .setCellValue(entry.getKey() == null ? "" : entry.getKey().getStringField("number"));
            row.createCell(1).setCellValue(order.getStringField("number"));
            String result = "";
            String controlResult = order.getStringField("controlResult");
            if ("01correct".equals(controlResult)) {
                result = translationService
                        .translate("qualityControls.qualityForOrder.controlResult.value.01correct", locale);
            } else if ("02incorrect".equals(controlResult)) {
                result = translationService
                        .translate("qualityControls.qualityForOrder.controlResult.value.02incorrect", locale);
            } else if ("03objection".equals(controlResult)) {
                result = translationService
                        .translate("qualityControls.qualityForOrder.controlResult.value.03objection", locale);
            }// w  w  w . j  a va  2 s  .  com
            row.createCell(2).setCellValue(result);
        }
    }
    sheet.autoSizeColumn((short) 0);
    sheet.autoSizeColumn((short) 1);
    sheet.autoSizeColumn((short) 2);
}

From source file:com.qcadoo.mes.qualityControls.print.QualityControlForUnitXlsView.java

License:Open Source License

private void addOrderHeader(final HSSFSheet sheet, final Locale locale) {
    HSSFRow header = sheet.createRow(0);
    HSSFCell cell0 = header.createCell(0);
    cell0.setCellValue(/*from  w w  w . j  a v a 2 s. co m*/
            translationService.translate("qualityControls.qualityControl.report.product.number", locale));
    xlsHelper.setCellStyle(sheet, cell0);
    HSSFCell cell1 = header.createCell(1);
    cell1.setCellValue(translationService.translate(
            "qualityControls.qualityControlForUnitDetails.window.mainTab.qualityControlForUnit.number.label",
            locale));
    xlsHelper.setCellStyle(sheet, cell1);
    HSSFCell cell2 = header.createCell(2);
    cell2.setCellValue(translationService.translate(
            "qualityControls.qualityControlForUnitDetails.window.mainTab.qualityControlForUnit.controlledQuantity.label",
            locale));
    xlsHelper.setCellStyle(sheet, cell2);
    HSSFCell cell3 = header.createCell(3);
    cell3.setCellValue(translationService.translate(
            "qualityControls.qualityControlForUnitDetails.window.mainTab.qualityControlForUnit.rejectedQuantity.label",
            locale));
    xlsHelper.setCellStyle(sheet, cell3);
    HSSFCell cell4 = header.createCell(4);
    cell4.setCellValue(translationService.translate(
            "qualityControls.qualityControlForUnitDetails.window.mainTab.qualityControlForUnit.acceptedDefectsQuantity.label",
            locale));
    xlsHelper.setCellStyle(sheet, cell4);
}

From source file:com.qcadoo.mes.qualityControls.print.QualityControlForUnitXlsView.java

License:Open Source License

private void addOrderSeries(final Map<String, Object> model, final HSSFSheet sheet) {
    int rowNum = 1;
    Map<Entity, List<Entity>> productOrders = qualityControlsReportService.getQualityOrdersForProduct(
            qualityControlsReportService.getOrderSeries(model, "qualityControlsForUnit"));
    productOrders = SortUtil.sortMapUsingComparator(productOrders, new EntityNumberComparator());
    for (Entry<Entity, List<Entity>> entry : productOrders.entrySet()) {
        List<Entity> orders = entry.getValue();
        Collections.sort(orders, new EntityNumberComparator());
        for (Entity order : orders) {
            HSSFRow row = sheet.createRow(rowNum++);
            row.createCell(0)
                    .setCellValue(entry.getKey() == null ? "" : entry.getKey().getStringField("number"));
            row.createCell(1).setCellValue(order.getStringField("number"));
            row.createCell(2).setCellValue(
                    numberService.setScale(order.getDecimalField("controlledQuantity")).doubleValue());
            row.createCell(3).setCellValue(
                    numberService.setScale(order.getDecimalField("rejectedQuantity")).doubleValue());
            row.createCell(4).setCellValue(
                    numberService.setScale(order.getDecimalField("acceptedDefectsQuantity")).doubleValue());
        }//from  ww  w  . ja v a 2 s. co  m
    }
    sheet.autoSizeColumn((short) 0);
    sheet.autoSizeColumn((short) 1);
    sheet.autoSizeColumn((short) 2);
    sheet.autoSizeColumn((short) 3);
    sheet.autoSizeColumn((short) 4);
}

From source file:com.qcadoo.mes.simpleMaterialBalance.internal.print.SimpleMaterialBalanceXlsService.java

License:Open Source License

@Override
protected void addHeader(final HSSFSheet sheet, final Locale locale, final Entity entity) {
    HSSFRow header = sheet.createRow(0);
    HSSFCell cell0 = header.createCell(0);
    cell0.setCellValue(translationService
            .translate("simpleMaterialBalance.simpleMaterialBalance.report.columnHeader.number", locale));
    xlsHelper.setCellStyle(sheet, cell0);
    HSSFCell cell1 = header.createCell(1);
    cell1.setCellValue(translationService
            .translate("simpleMaterialBalance.simpleMaterialBalance.report.columnHeader.name", locale));
    xlsHelper.setCellStyle(sheet, cell1);
    HSSFCell cell2 = header.createCell(2);
    cell2.setCellValue(translationService.translate("basic.product.unit.label", locale));
    xlsHelper.setCellStyle(sheet, cell2);
    HSSFCell cell3 = header.createCell(3);
    cell3.setCellValue(translationService
            .translate("simpleMaterialBalance.simpleMaterialBalance.report.columnHeader.needed", locale));
    xlsHelper.setCellStyle(sheet, cell3);
    HSSFCell cell4 = header.createCell(4);
    cell4.setCellValue(translationService
            .translate("simpleMaterialBalance.simpleMaterialBalance.report.columnHeader.inLocation", locale));
    xlsHelper.setCellStyle(sheet, cell4);
    HSSFCell cell5 = header.createCell(5);
    cell5.setCellValue(translationService
            .translate("simpleMaterialBalance.simpleMaterialBalance.report.columnHeader.balance", locale));
    xlsHelper.setCellStyle(sheet, cell5);
}

From source file:com.qcadoo.mes.simpleMaterialBalance.internal.print.SimpleMaterialBalanceXlsService.java

License:Open Source License

@Override
protected void addSeries(final HSSFSheet sheet, final Entity simpleMaterialBalance) {
    int rowNum = 1;
    List<Entity> simpleMaterialBalanceOrdersComponents = simpleMaterialBalance
            .getHasManyField(L_SIMPLE_MATERIAL_BALANCE_ORDERS_COMPONENTS);
    MrpAlgorithm mrpAlgorithm = MrpAlgorithm.parseString(simpleMaterialBalance.getStringField("mrpAlgorithm"));

    Map<Long, BigDecimal> neededProductQuantities = productQuantitiesService
            .getNeededProductQuantitiesForComponents(simpleMaterialBalanceOrdersComponents, mrpAlgorithm);

    List<Entity> simpleMaterialBalanceLocationComponents = simpleMaterialBalance
            .getHasManyField(L_SIMPLE_MATERIAL_BALANCE_LOCATIONS_COMPONENTS);

    // TODO LUPO fix comparator
    // neededProductQuantities = SortUtil.sortMapUsingComparator(neededProductQuantities, new EntityNumberComparator());

    for (Entry<Long, BigDecimal> neededProductQuantity : neededProductQuantities.entrySet()) {
        Entity product = productQuantitiesService.getProduct(neededProductQuantity.getKey());

        HSSFRow row = sheet.createRow(rowNum++);
        row.createCell(0).setCellValue(product.getField(L_NUMBER).toString());
        row.createCell(1).setCellValue(product.getField(L_NAME).toString());
        row.createCell(2).setCellValue(product.getField(L_UNIT).toString());
        row.createCell(3).setCellValue(numberService.format(neededProductQuantity.getValue()));
        BigDecimal available = BigDecimal.ZERO;
        for (Entity simpleMaterialBalanceLocationComponent : simpleMaterialBalanceLocationComponents) {
            available = available.add(//www  .  jav a  2s  .c o m
                    materialFlowService.calculateShouldBeInLocation(
                            simpleMaterialBalanceLocationComponent.getBelongsToField(L_LOCATION).getId(),
                            product.getId(), (Date) simpleMaterialBalance.getField(L_DATE)),
                    numberService.getMathContext());
        }
        row.createCell(4).setCellValue(numberService.format(available));
        row.createCell(5).setCellValue(numberService
                .format(available.subtract(neededProductQuantity.getValue(), numberService.getMathContext())));
    }
    sheet.autoSizeColumn((short) 0);
    sheet.autoSizeColumn((short) 1);
    sheet.autoSizeColumn((short) 2);
    sheet.autoSizeColumn((short) 3);
    sheet.autoSizeColumn((short) 4);
    sheet.autoSizeColumn((short) 5);
}

From source file:com.qcadoo.mes.technologies.print.TechnologiesTechnologyDetailsXlsView.java

License:Open Source License

private void addOrderHeader(final HSSFSheet sheet, final Locale locale) {
    HSSFRow header = sheet.createRow(0);
    int columnCounter = 0;
    for (String headerText : newArrayList("level", "name", "direction", "productNumber", "productName",
            L_QUANTITY, "unit")) {
        HSSFCell cell = header.createCell(columnCounter);
        cell.setCellValue(translationService.translate(
                "technologies.technologiesTechnologyDetails.report.columnHeader." + headerText, locale));
        xlsHelper.setCellStyle(sheet, cell);
        columnCounter++;/*from  www . j a va  2s.c o m*/
    }
}

From source file:com.qcadoo.mes.technologies.print.TechnologiesTechnologyDetailsXlsView.java

License:Open Source License

private void addOrderSeries(final Map<String, Object> model, final HSSFSheet sheet, final Locale locale) {
    checkState(model.get("id") != null, "Unable to generate report for unsaved technology! (missing id)");

    DataDefinition technologyDD = dataDefinitionService.get(PLUGIN_IDENTIFIER, MODEL_TECHNOLOGY);

    Entity technology = technologyDD.get(valueOf(model.get("id").toString()));

    EntityTree technologyTree = technology.getTreeField(TechnologyFields.OPERATION_COMPONENTS);
    treeNumberingService.generateTreeNumbers(technologyTree);

    List<Entity> technologyOperationsList = entityTreeUtilsService.getSortedEntities(technologyTree);

    int rowNum = 1;
    for (Entity technologyOperation : technologyOperationsList) {
        String nodeNumber = technologyOperation.getStringField(TechnologyOperationComponentFields.NODE_NUMBER);
        String operationName = technologyOperation
                .getBelongsToField(TechnologyOperationComponentFields.OPERATION)
                .getStringField(OperationFields.NAME);

        List<Entity> operationProductComponents = Lists.newLinkedList();

        operationProductComponents.addAll(technologyOperation
                .getHasManyField(TechnologyOperationComponentFields.OPERATION_PRODUCT_IN_COMPONENTS));
        operationProductComponents.addAll(technologyOperation
                .getHasManyField(TechnologyOperationComponentFields.OPERATION_PRODUCT_OUT_COMPONENTS));

        for (Entity operatonProductComponent : operationProductComponents) {
            HSSFRow row = sheet.createRow(rowNum++);

            Entity product = operatonProductComponent.getBelongsToField(L_PRODUCT);

            String productType = "technologies.technologiesTechnologyDetails.report.direction.out";

            if (operatonProductComponent.getDataDefinition().getName().equals("operationProductInComponent")) {
                productType = "technologies.technologiesTechnologyDetails.report.direction.in";
            }/*  w w  w . ja  va  2s. c  o  m*/

            row.createCell(0).setCellValue(nodeNumber);
            row.createCell(1).setCellValue(operationName);
            row.createCell(2).setCellValue(translationService.translate(productType, locale));
            row.createCell(3).setCellValue(product.getStringField(ProductFields.NUMBER));
            row.createCell(4).setCellValue(product.getStringField(ProductFields.NAME));
            row.createCell(5).setCellValue(operatonProductComponent.getField(L_QUANTITY).toString());
            row.createCell(6).setCellValue(product.getStringField(ProductFields.UNIT));
        }
    }

    sheet.autoSizeColumn((short) 0);
    sheet.autoSizeColumn((short) 1);
    sheet.autoSizeColumn((short) 2);
    sheet.autoSizeColumn((short) 3);
    sheet.autoSizeColumn((short) 4);
    sheet.autoSizeColumn((short) 5);
    sheet.autoSizeColumn((short) 6);
}

From source file:com.qpark.eip.core.poi.ExcelFile.java

License:Open Source License

/**
 * Create a cell in the sheet row at index and set the value and apply style
 *
 * @param row/*w  w w .  j  ava  2s .  com*/
 *            the {@link HSSFRow}. the {@link HSSFRow}.
 * @param index
 *            the index index in row
 * @param value
 *            value object
 * @param style
 *            cell style
 * @return the {@link HSSFCell} created.
 */
private static HSSFCell createCell(final HSSFRow row, final int index, final Object value,
        final HSSFCellStyle style) {
    HSSFCell cell = row.createCell(index < 0 ? 0 : index);
    if (Objects.isNull(value)) {
        cell.setCellValue("---");
    } else if (Boolean.class.isInstance(value)) {
        cell.setCellValue(((Boolean) value));
    } else if (BigDecimal.class.isInstance(value)) {
        cell.setCellValue(((BigDecimal) value).doubleValue());
    } else if (BigInteger.class.isInstance(value)) {
        cell.setCellValue(((BigInteger) value).longValue());
    } else if (Integer.class.isInstance(value)) {
        cell.setCellValue(((Integer) value).longValue());
    } else if (Number.class.isInstance(value)) {
        cell.setCellValue(((Number) value).doubleValue());
    } else if (String.class.isInstance(value)) {
        cell.setCellValue(((String) value).trim());
    }
    cell.setCellStyle(style);
    return cell;
}

From source file:com.quix.aia.cn.imo.mapper.InterviewMaintenance.java

License:Open Source License

/**
 * <p>Method is used to create csv to store registration list for 3rd interview  </p>
 * @param  HttpServletRequest request /*from  w  ww . j  ava  2 s.co m*/
 * @return  csv path as String
 */
public String createCsv(ArrayList regList, HttpServletRequest request) {
    log.log(Level.INFO, "Csv Generation Starts");
    String xlsPath = "";
    DateFormat df = new SimpleDateFormat("yyyy-MM-dd_HH.mm.ss");
    FileWriter fw = null;
    /*BufferedWriter writer=null;
     String serverFilename = request.getRealPath("/");
     if(!serverFilename.endsWith("/"))
          serverFilename = serverFilename + File.separator;
     try{
             
    serverFilename = serverFilename + "resources" + File.separator +  "downloads" + File.separator + "csv";
            
     File dir = new File(serverFilename);
     if(!dir.exists())
        dir.mkdirs();
             
            
    serverFilename = serverFilename +  File.separator  +df.format(new Date()) + ".csv" ;
            
     File file = new File(serverFilename);
     if(!file.exists())
         file.createNewFile();
            
     writer = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(file), "UTF-8"));
             
     writer.write("Interview Session Name|");
     writer.write("Interview Date|");
     writer.write("Start Time|");
     writer.write("End Time|");
     writer.write("Candidate Name|");
     writer.write("Servicing Agent|");
     writer.write("Agent Name|");
     writer.write("BU|");
     writer.write("District|");
     writer.write("Branch|");
     writer.write("City|");              
     writer.write("Office|");
     writer.write("SSC|");
     writer.write("Agency Leader Code|");
     writer.write("Agency Leader Name|");
     writer.write("Source of Referral|");
     writer.write("Age|");
     writer.write("Date of Birth|");
     writer.write("Gender|");
     writer.write("Contact Number|");
     writer.write("CC Test Result|");
     writer.write("Recruitment Scheme|");
            
    writer.newLine();
             
     if(regList!=null && regList.size()>0){
        Iterator iteObj= regList.iterator();
         for(int i=0;i<regList.size();i++){
          Object [] obj= (Object []) iteObj.next();
               
           writer.write(obj[0]+"|"); //Interview Session Name
           if(obj[1]!=null )
     writer.write(LMSUtil.convertDateToString((Date)obj[1]) +"|"); //Interview Date
           else
     writer.write("|");
                   
           if(obj[2]!=null )
     writer.write(LMSUtil.converDateIntoHHMMAMPM((Date)obj[2]) +"|");//Start Time
           else
     writer.write("|");
           if(obj[3]!=null)
     writer.write(LMSUtil.converDateIntoHHMMAMPM((Date)obj[3]) +"|");//End Time
           else
     writer.write("|");
                   
           if(obj[4]!=null)writer.write(obj[4]+"|");else writer.write("|");//Candidate Name
           if(obj[5]!=null)writer.write(obj[5]+"|");else writer.write("|");//Servicing Agent
           if(obj[6]!=null)writer.write(obj[6]+"|");else writer.write("|");//Agent Name
           if(obj[7]!=null)writer.write(obj[7]+"|");else writer.write("|");//BU
           if(obj[8]!=null)writer.write(obj[8]+"|");else writer.write("|");//District
           if(obj[9]!=null)writer.write(obj[9]+"|");else writer.write("|");//Branch
           if(obj[10]!=null)writer.write(obj[10]+"|");else writer.write("|");//City
           if(obj[11]!=null)writer.write(obj[11]+"|");else writer.write("|");//Office
           if(obj[12]!=null)writer.write(obj[12]+"|");else writer.write("|");//SSC
           if(obj[13]!=null)writer.write(obj[13]+"|");else writer.write("|");//Agency Leader Code
           if(obj[14]!=null)writer.write(obj[14]+"|");else writer.write("|");//Agency Leader Name
           if(obj[15]!=null)writer.write(obj[15]+"|");else writer.write("|");//Source of Referral
           if(obj[16]!=null)writer.write(obj[16]+"|");else writer.write("|");//Age
           if(obj[17]!=null )
     writer.write(LMSUtil.convertDateToString((Date)obj[17]) +"|");//DOB
           else
     writer.write("|");
           String gender = "";
           if(obj[18]!=null){
     if("F".equalsIgnoreCase((String)obj[18]))
        gender = "Female";
     else if("M".equalsIgnoreCase((String)obj[18]))//Gender
        gender = "Male";
           }
           writer.write(gender+"|");
           if(obj[19]!=null)writer.write(obj[19]+"|");else writer.write("|");//Contact Number
           if(obj[20]!=null)writer.write(obj[20]+"|");else writer.write("|");//CC Test Result
           if(obj[21]!=null)writer.write(obj[21]+"|");else writer.write("|");//Recruitment Scheme
                   
           writer.newLine();
                   
        }
                 
                 
                 
     }else{
        log.log(Level.INFO,"InterviewMaintenace - > createCsv : No candidate registration for 3rd interview");
     }
            
     }catch(Exception e){
        log.log(Level.SEVERE, e.getMessage());
        e.printStackTrace();LogsMaintenance logsMain=new LogsMaintenance();
       StringWriter errors = new StringWriter();
       e.printStackTrace(new PrintWriter(errors));
       logsMain.insertLogs("InterViewMaintenance",Level.SEVERE+"",errors.toString());
     }finally{
          try{
    if(writer != null){
        writer.flush();
          }
    if(writer != null){
       writer.close();
    }
    if(fw!=null)
       fw.close();
            
          }catch(Exception ioExc){
    log.log(Level.SEVERE, ioExc.getMessage());
    ioExc.printStackTrace();
            
          }
    }
     */

    ArrayList arList = null;
    ArrayList al = null;
    String thisLine;
    int count = 0;

    try {

        xlsPath = request.getRealPath("/") + "resources" + File.separator + "downloads" + File.separator
                + "xls";

        File dir = new File(xlsPath);
        if (!dir.exists())
            dir.mkdirs(); //df.format(new Date())
        xlsPath = xlsPath + File.separator + df.format(new Date()) + ".xls";

        HSSFWorkbook hwb = new HSSFWorkbook();
        HSSFSheet sheet = (HSSFSheet) hwb.createSheet("Sheet1");
        int rownum = 0;
        HSSFRow row = sheet.createRow(rownum++);
        int cellnum = 0;
        HSSFCell cell = row.createCell((short) cellnum++);

        cell.setCellValue("? ?");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("? ");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("  ");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("?  ");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("  ??");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("??");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("????");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("?");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("?");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("?");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("SSC");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("??");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("??  ?");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("Age");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("?  ??");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("CC   ");
        cell = row.createCell((short) cellnum++);
        cell.setCellValue("?");
        cell = row.createCell((short) cellnum++);

        if (regList != null && regList.size() > 0) {
            Iterator iteObj = regList.iterator();
            for (int i = 0; i < regList.size(); i++) {
                row = sheet.createRow(rownum++);
                cellnum = 0;
                Object[] obj = (Object[]) iteObj.next();

                //writer.write(obj[0]+"|"); //Interview Session Name
                if (obj[0] instanceof String)
                    cell = row.createCell((short) cellnum++);
                cell.setCellValue((String) obj[0]);

                if (obj[1] != null) {
                    //writer.write(LMSUtil.convertDateToString((Date)obj[1]) +"|"); //Interview Date
                    if (obj[1] instanceof Date) {
                        cell = row.createCell((short) cellnum++);
                        cell.setCellValue(LMSUtil.convertDateToString((Date) obj[1]));
                    }
                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[2] != null) {
                    //writer.write(LMSUtil.converDateIntoHHMMAMPM((Date)obj[2]) +"|");//Start Time
                    if (obj[2] instanceof Date) {
                        cell = row.createCell((short) cellnum++);
                        cell.setCellValue(LMSUtil.converDateIntoHHMMAMPM((Date) obj[2]));
                    }
                } else {
                    //writer.write("|");
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[3] != null) {
                    //writer.write(LMSUtil.converDateIntoHHMMAMPM((Date)obj[3]) +"|");//End Time
                    if (obj[3] instanceof Date) {
                        cell = row.createCell((short) cellnum++);
                        cell.setCellValue(LMSUtil.converDateIntoHHMMAMPM((Date) obj[3]));
                    }
                } else {
                    //writer.write("|");
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[4] != null) {
                    //writer.write(obj[4]+"|");//Candidate Name
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[4]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[5] != null) {
                    //Servicing Agent
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[5]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[6] != null) {
                    //Agent Name
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[6]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[7] != null) {
                    //BU
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[7]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[8] != null) {
                    //District
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[8]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[9] != null) {
                    //Branch
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[9]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[10] != null) {
                    //City
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[10]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[11] != null) {
                    //Office
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[11]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[12] != null) {
                    //SSC
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[12]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[13] != null) {
                    //Agency Leader Code
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[13]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[14] != null) {
                    //Agency Leader Name
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[14]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[15] != null) {
                    //Source of Referral
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[15]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[16] != null) {
                    //Age
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((Integer) obj[16]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[17] != null) {
                    //writer.write(LMSUtil.convertDateToString((Date)obj[17]) +"|");//DOB
                    if (obj[3] instanceof Date) {
                        cell = row.createCell((short) cellnum++);
                        cell.setCellValue(LMSUtil.convertDateToString((Date) obj[17]));
                    }
                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                String gender = "";
                if (obj[18] != null) {
                    if ("F".equalsIgnoreCase((String) obj[18]))
                        gender = "Female";
                    else if ("M".equalsIgnoreCase((String) obj[18]))//Gender
                        gender = "Male";
                }
                cell = row.createCell((short) cellnum++);
                cell.setCellValue(gender);

                if (obj[19] != null) {
                    //Contact Number
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[19]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

                if (obj[20] != null) {
                    //CC Test Result
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[20]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }
                if (obj[21] != null) {
                    //Recruitment Scheme
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue((String) obj[21]);

                } else {
                    cell = row.createCell((short) cellnum++);
                    cell.setCellValue("");
                }

            }

        }

        FileOutputStream fileOut = new FileOutputStream(xlsPath);
        hwb.write(fileOut);
        fileOut.close();
        System.out.println("Your excel file has been generated");
    } catch (Exception ex) {
        ex.printStackTrace();
    } //main method ends

    return xlsPath;
}

From source file:com.rabbit.jfinal.ext.render.excel.PoiKit.java

License:Apache License

@SuppressWarnings("unchecked")
private static void processAsMap(String[] columns, HSSFRow row, Object obj) {
    HSSFCell cell;/*from   w  w  w  .ja  va  2 s .co m*/
    Map<String, Object> map = (Map<String, Object>) obj;
    if (columns.length == 0) {// 
        Set<String> keys = map.keySet();
        int columnIndex = 0;
        for (String key : keys) {
            cell = row.createCell(columnIndex);
            cell.setCellValue(map.get(key) == null ? "" : (map.get(key) + ""));
            columnIndex++;
        }
    } else {
        for (int j = 0, lenJ = columns.length; j < lenJ; j++) {
            cell = row.createCell(j);
            cell.setCellValue(map.get(columns[j]) == null ? "" : (map.get(columns[j]) + ""));
        }
    }
}