List of usage examples for org.apache.poi.hssf.usermodel HSSFSheet createRow
@Override public HSSFRow createRow(int rownum)
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)/*from ww w . ja v a 2s. c o m*/ .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); } 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(// w w w .j a v a 2 s. c o 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)//from w w w .j a v a 2 s. co m .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()); } } 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(// ww w. j av a 2 s .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 ww w. j av a 2 s.c om } }
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 v a2s . c om 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.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 ww w. j a va 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.safetys.framework.jmesa.view.excel.ExcelView.java
License:Apache License
public Object render() { HSSFWorkbook workbook = new HSSFWorkbook(); Table table = this.getTable(); String caption = table.getCaption(); if (StringUtils.isEmpty(caption)) { caption = "JMesa Export"; }/*from w w w. j a va 2 s. co m*/ HSSFSheet sheet = workbook.createSheet(caption); Row row = table.getRow(); row.getRowRenderer(); List<Column> columns = table.getRow().getColumns(); // renderer header HSSFRow hssfRow = sheet.createRow(0); int columncount = 0; for (Column col : columns) { HSSFCell cell = hssfRow.createCell((short) columncount++); cell.setCellValue(new HSSFRichTextString(col.getTitle())); } // renderer body Collection<?> items = getCoreContext().getPageItems(); int rowcount = 1; for (Object item : items) { HSSFRow r = sheet.createRow(rowcount++); columncount = 0; for (Column col : columns) { HSSFCell cell = r.createCell((short) columncount++); Object value = col.getCellRenderer().render(item, rowcount); if (value == null) { value = ""; } if (value instanceof Number) { Double number = Double.valueOf(value.toString()); cell.setCellValue(number); } else { cell.setCellValue(new HSSFRichTextString(value.toString())); } } } return workbook; }
From source file:com.sammyun.ExcelView.java
License:Open Source License
/** * ?Excel/*from w ww .j av a 2 s. c o m*/ * * @param model ? * @param workbook workbook * @param request request * @param response response */ public void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception { Assert.notEmpty(properties); HSSFSheet sheet; if (StringUtils.isNotEmpty(sheetName)) { sheet = workbook.createSheet(sheetName); } else { sheet = workbook.createSheet(); } int rowNumber = 0; if (titles != null && titles.length > 0) { HSSFRow header = sheet.createRow(rowNumber); header.setHeight((short) 400); for (int i = 0; i < properties.length; i++) { HSSFCell cell = header.createCell(i); HSSFCellStyle cellStyle = workbook.createCellStyle(); cellStyle.setFillForegroundColor(HSSFColor.LIGHT_CORNFLOWER_BLUE.index); cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); HSSFFont font = workbook.createFont(); font.setFontHeightInPoints((short) 11); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); cellStyle.setFont(font); cell.setCellStyle(cellStyle); if (i == 0) { HSSFPatriarch patriarch = sheet.createDrawingPatriarch(); HSSFComment comment = patriarch .createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 1, 1, (short) 4, 4)); comment.setString(new HSSFRichTextString("P" + "o" + "w" + "e" + "r" + "e" + "d" + " " + "B" + "y" + " " + "M" + "o" + "S" + "ho" + "o" + "p")); cell.setCellComment(comment); } if (titles.length > i && titles[i] != null) { cell.setCellValue(titles[i]); } else { cell.setCellValue(properties[i]); } if (widths != null && widths.length > i && widths[i] != null) { sheet.setColumnWidth(i, widths[i]); } else { sheet.autoSizeColumn(i); } } rowNumber++; } if (data != null) { for (Object item : data) { HSSFRow row = sheet.createRow(rowNumber); for (int i = 0; i < properties.length; i++) { HSSFCell cell = row.createCell(i); if (converters != null && converters.length > i && converters[i] != null) { Class<?> clazz = PropertyUtils.getPropertyType(item, properties[i]); ConvertUtils.register(converters[i], clazz); cell.setCellValue(BeanUtils.getProperty(item, properties[i])); ConvertUtils.deregister(clazz); if (clazz.equals(Date.class)) { DateConverter dateConverter = new DateConverter(); dateConverter.setPattern(DEFAULT_DATE_PATTERN); ConvertUtils.register(dateConverter, Date.class); } } else { cell.setCellValue(BeanUtils.getProperty(item, properties[i])); } if (rowNumber == 0 || rowNumber == 1) { if (widths != null && widths.length > i && widths[i] != null) { sheet.setColumnWidth(i, widths[i]); } else { sheet.autoSizeColumn(i); } } } rowNumber++; } } if (contents != null && contents.length > 0) { rowNumber++; for (String content : contents) { HSSFRow row = sheet.createRow(rowNumber); HSSFCell cell = row.createCell(0); HSSFCellStyle cellStyle = workbook.createCellStyle(); HSSFFont font = workbook.createFont(); font.setColor(HSSFColor.GREY_50_PERCENT.index); cellStyle.setFont(font); cell.setCellStyle(cellStyle); cell.setCellValue(content); rowNumber++; } } response.setContentType("application/force-download"); if (StringUtils.isNotEmpty(filename)) { response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode(filename, "UTF-8")); } else { response.setHeader("Content-disposition", "attachment"); } }