List of usage examples for org.apache.poi.ss.usermodel Sheet addMergedRegion
int addMergedRegion(CellRangeAddress region);
From source file:com.griffinslogistics.document.excel.BookLabelGenerator.java
private static void generateTitle(Sheet sheet, Map<String, CellStyle> styles, BookLabelModel bookLabelModel) { sheet.addMergedRegion(CellRangeAddress.valueOf("$A6:A7")); sheet.addMergedRegion(CellRangeAddress.valueOf("$D6:D7")); sheet.addMergedRegion(CellRangeAddress.valueOf("$A16:A17")); sheet.addMergedRegion(CellRangeAddress.valueOf("$D16:D17")); String isbn = bookLabelModel.getISBN() != null ? bookLabelModel.getISBN() : ""; String titleISBNString = String.format("%s %s", bookLabelModel.getTitle(), isbn); Row row6 = sheet.getRow(5);/*from w w w.j av a 2 s . c o m*/ Row row7 = sheet.getRow(6); Cell a6 = row6.createCell(0); a6.setCellStyle(styles.get(STYLE_LABEL)); a6.setCellValue(TITLE); Cell a7 = row7.createCell(0); a7.setCellStyle(styles.get(STYLE_LABEL)); Cell b6 = row6.createCell(1); b6.setCellStyle(styles.get(STYLE_CONTENT)); b6.setCellValue(titleISBNString); Cell b7 = row7.createCell(1); b7.setCellStyle(styles.get(STYLE_CONTENT)); b7.setCellValue(bookLabelModel.getBookNumber()); Cell d6 = row6.createCell(3); d6.setCellStyle(styles.get(STYLE_LABEL)); d6.setCellValue(TITLE); Cell d7 = row7.createCell(3); d7.setCellStyle(styles.get(STYLE_LABEL)); Cell e6 = row6.createCell(4); e6.setCellStyle(styles.get(STYLE_CONTENT)); e6.setCellValue(titleISBNString); Cell e7 = row7.createCell(4); e7.setCellStyle(styles.get(STYLE_CONTENT)); e7.setCellValue(bookLabelModel.getBookNumber()); Row row16 = sheet.getRow(15); Row row17 = sheet.getRow(16); Cell a16 = row16.createCell(0); a16.setCellStyle(styles.get(STYLE_LABEL)); a16.setCellValue(TITLE); Cell a17 = row17.createCell(0); a17.setCellStyle(styles.get(STYLE_LABEL)); Cell b16 = row16.createCell(1); b16.setCellStyle(styles.get(STYLE_CONTENT)); b16.setCellValue(titleISBNString); Cell b17 = row17.createCell(1); b17.setCellStyle(styles.get(STYLE_CONTENT)); b17.setCellValue(bookLabelModel.getBookNumber()); Cell d16 = row16.createCell(3); d16.setCellStyle(styles.get(STYLE_LABEL)); d16.setCellValue(TITLE); Cell d17 = row17.createCell(3); d17.setCellStyle(styles.get(STYLE_LABEL)); Cell e16 = row16.createCell(4); e16.setCellStyle(styles.get(STYLE_CONTENT)); e16.setCellValue(titleISBNString); Cell e17 = row17.createCell(4); e17.setCellStyle(styles.get(STYLE_CONTENT)); e17.setCellValue(bookLabelModel.getBookNumber()); }
From source file:com.griffinslogistics.excel.BDLGenerator.java
/** * * @param sheet//w ww.j a v a2 s.c o m * @param leftStyle * @param middleStyle * @param rightStyle * @param footerStyle * @return index of the last table row created */ private static int insertTableBody(Sheet sheet, CellStyle leftStyle, CellStyle middleStyle, CellStyle rightStyle, CellStyle footerStyle, List<BookBoxModel> bookBoxModels) { Integer index = 18; Integer currentBookTitleIndex = 1; Set<Integer> rowsToSum = new HashSet<Integer>(); Set<Integer> totalsToSum = new HashSet<Integer>(); String cellMergeString; String cellFormula; try { int currentBookNumber = bookBoxModels.get(0).getBookNumber(); for (int i = 0; i < bookBoxModels.size(); i++) { index++; BookBoxModel currentModel = bookBoxModels.get(i); Row row = sheet.createRow(index); if (currentBookNumber != currentModel.getBookNumber()) { for (int j = 2; j <= 4; j++) { row.createCell(j).setCellStyle(footerStyle); } addTotalTitleRow(row, index, sheet, footerStyle, currentBookTitleIndex, rowsToSum, totalsToSum); index++; currentBookTitleIndex++; row = sheet.createRow(index); } for (int j = 2; j <= 4; j++) { row.createCell(j).setCellStyle(middleStyle); } //Book Title Row Cell titleCell = row.createCell(1); cellMergeString = String.format("$B$%s:$E$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(cellMergeString)); titleCell.setCellStyle(leftStyle); titleCell.setCellValue(currentModel.getTitle()); Cell quantityCell = row.createCell(5); quantityCell.setCellStyle(middleStyle); quantityCell.setCellValue(Double.parseDouble(currentModel.getBooksCount().toString())); Cell boxCountCell = row.createCell(6); boxCountCell.setCellStyle(middleStyle); boxCountCell.setCellValue(Double.parseDouble(currentModel.getBoxesCount().toString())); Cell totalQuantityCell = row.createCell(7); totalQuantityCell.setCellStyle(rightStyle); cellFormula = String.format("F%s*G%s", index + 1, index + 1); totalQuantityCell.setCellFormula(cellFormula); Cell palettesCountCell = row.createCell(8); palettesCountCell.setCellStyle(rightStyle); // excel is not 0-based! rowsToSum.add(index + 1); currentBookNumber = currentModel.getBookNumber(); } index++; Row row = sheet.createRow(index); for (int i = 2; i <= 4; i++) { row.createCell(i).setCellStyle(footerStyle); } addTotalTitleRow(row, index, sheet, footerStyle, currentBookTitleIndex, rowsToSum, totalsToSum); //Total row index++; Row footerTotalRow = sheet.createRow(index); Cell footerTotalRowTitleCell = footerTotalRow.createCell(1); for (int i = 2; i <= 4; i++) { footerTotalRow.createCell(i).setCellStyle(footerStyle); } cellMergeString = String.format("$B$%s:$E$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(cellMergeString)); footerTotalRowTitleCell.setCellStyle(footerStyle); footerTotalRowTitleCell.setCellValue("Total"); Cell footerTotalRowQuantityCell = footerTotalRow.createCell(5); footerTotalRowQuantityCell.setCellStyle(footerStyle); Cell footerTotalRowBoxCountCell = footerTotalRow.createCell(6); footerTotalRowBoxCountCell.setCellStyle(footerStyle); Cell footerTotalRowTotalQuantityCell = footerTotalRow.createCell(7); footerTotalRowTotalQuantityCell.setCellStyle(footerStyle); Cell footerTotalRowPalettesCountCell = footerTotalRow.createCell(8); footerTotalRowPalettesCountCell.setCellStyle(footerStyle); //build cell formulas StringBuilder totalBoxesCountformulaBuilder = new StringBuilder(); StringBuilder totalBooksCountformulaBuilder = new StringBuilder(); StringBuilder totalPaletsCountformulaBuilder = new StringBuilder(); // Example: SUM(H22;H25;H28;H31;H34) totalBoxesCountformulaBuilder.append("SUM("); totalBooksCountformulaBuilder.append("SUM("); totalPaletsCountformulaBuilder.append("SUM("); for (Integer integer : totalsToSum) { totalBoxesCountformulaBuilder.append("G").append(integer).append(","); totalBooksCountformulaBuilder.append("H").append(integer).append(","); totalPaletsCountformulaBuilder.append("I").append(integer).append(","); } totalBoxesCountformulaBuilder.deleteCharAt(totalBoxesCountformulaBuilder.length() - 1); totalBooksCountformulaBuilder.deleteCharAt(totalBooksCountformulaBuilder.length() - 1); totalPaletsCountformulaBuilder.deleteCharAt(totalPaletsCountformulaBuilder.length() - 1); totalBoxesCountformulaBuilder.append(")"); totalBooksCountformulaBuilder.append(")"); totalPaletsCountformulaBuilder.append(")"); footerTotalRowBoxCountCell.setCellFormula(totalBoxesCountformulaBuilder.toString()); footerTotalRowTotalQuantityCell.setCellFormula(totalBooksCountformulaBuilder.toString()); footerTotalRowPalettesCountCell.setCellFormula(totalPaletsCountformulaBuilder.toString()); } catch (Exception e) { e.printStackTrace(); } return index; }
From source file:com.griffinslogistics.excel.BDLGenerator.java
private static void insertFooter(Sheet sheet, CellStyle footerStyle, int index, String packageNumber, String deliveryAddress, String client) { String mergeString;//from w w w. java2s. c o m index += 2; Row transportNumberRow = sheet.createRow(index); Cell transportNumberCell = transportNumberRow.createCell(1); transportNumberCell.setCellValue("Num Tpt: " + packageNumber); transportNumberCell.setCellStyle(footerStyle); mergeString = String.format("$B$%s:$C$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(mergeString)); index += 2; Row addressLabelRow = sheet.createRow(index); Cell addressLabelCell = addressLabelRow.createCell(1); addressLabelCell.setCellValue("A livrer chez: "); addressLabelCell.setCellStyle(footerStyle); mergeString = String.format("$B$%s:$C$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(mergeString)); index += 1; Row addressRow = sheet.createRow(index); Cell addressCell = addressRow.createCell(1); addressCell.setCellValue(deliveryAddress); addressCell.setCellStyle(footerStyle); mergeString = String.format("$B$%s:$I$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(mergeString)); index += 3; Row clientLabelRow = sheet.createRow(index); Cell clientLabelCell = clientLabelRow.createCell(1); clientLabelCell.setCellValue("Pour le compte des Editions: "); clientLabelCell.setCellStyle(footerStyle); mergeString = String.format("$B$%s:$C$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(mergeString)); index += 1; Row clientRow = sheet.createRow(index); Cell clientCell = clientRow.createCell(1); clientCell.setCellValue(client); clientCell.setCellStyle(footerStyle); mergeString = String.format("$B$%s:$I$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(mergeString)); index += 4; Row dateRow = sheet.createRow(index); Cell dateCell = dateRow.createCell(1); dateCell.setCellValue("Date: ................"); dateCell.setCellStyle(footerStyle); mergeString = String.format("$B$%s:$C$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(mergeString)); index += 5; Row signatureRow = sheet.createRow(index); Cell signatureCell = signatureRow.createCell(1); signatureCell.setCellValue("Signature et tampon: ..................."); signatureCell.setCellStyle(footerStyle); mergeString = String.format("$B$%s:$C$%s", index + 1, index + 1); sheet.addMergedRegion(CellRangeAddress.valueOf(mergeString)); }
From source file:com.griffinslogistics.excel.BookLabelGenerator.java
private static void generateAddress(Sheet sheet, Map<String, CellStyle> styles, BookLabelModel bookLabelModel) { sheet.addMergedRegion(CellRangeAddress.valueOf("$A2:A3")); sheet.addMergedRegion(CellRangeAddress.valueOf("$A12:A13")); sheet.addMergedRegion(CellRangeAddress.valueOf("$D2:D3")); sheet.addMergedRegion(CellRangeAddress.valueOf("$D12:D13")); Row row2 = sheet.getRow(1);//from w ww .j a v a2s. c o m row2.setHeightInPoints(25); Row row3 = sheet.getRow(2); row3.setHeightInPoints(25); Cell a2 = row2.createCell(0); a2.setCellValue(ADDRESS); a2.setCellStyle(styles.get(STYLE_LABEL)); Cell a3 = row3.createCell(0); a3.setCellStyle(styles.get(STYLE_LABEL)); Cell d2 = row2.createCell(3); d2.setCellValue(ADDRESS); d2.setCellStyle(styles.get(STYLE_LABEL)); Cell d3 = row3.createCell(3); d3.setCellStyle(styles.get(STYLE_LABEL)); Cell b2 = row2.createCell(1); b2.setCellValue(bookLabelModel.getAddress()); b2.setCellStyle(styles.get(STYLE_CONTENT)); Cell b3 = row3.createCell(1); b3.setCellValue(bookLabelModel.getPostalCode()); b3.setCellStyle(styles.get(STYLE_CONTENT)); Cell e2 = row2.createCell(4); e2.setCellValue(bookLabelModel.getAddress()); e2.setCellStyle(styles.get(STYLE_CONTENT)); Cell e3 = row3.createCell(4); e3.setCellValue(bookLabelModel.getPostalCode()); e3.setCellStyle(styles.get(STYLE_CONTENT)); Row row12 = sheet.getRow(11); row12.setHeightInPoints(25); Row row13 = sheet.getRow(12); row13.setHeightInPoints(25); Cell a12 = row12.createCell(0); a12.setCellValue(ADDRESS); a12.setCellStyle(styles.get(STYLE_LABEL)); Cell a13 = row13.createCell(0); a13.setCellStyle(styles.get(STYLE_LABEL)); Cell d12 = row12.createCell(3); d12.setCellValue(ADDRESS); d12.setCellStyle(styles.get(STYLE_LABEL)); Cell d13 = row13.createCell(3); d13.setCellStyle(styles.get(STYLE_LABEL)); Cell b12 = row12.createCell(1); b12.setCellValue(bookLabelModel.getAddress()); b12.setCellStyle(styles.get(STYLE_CONTENT)); Cell b13 = row13.createCell(1); b13.setCellValue(bookLabelModel.getPostalCode()); b13.setCellStyle(styles.get(STYLE_CONTENT)); Cell e12 = row12.createCell(4); e12.setCellValue(bookLabelModel.getAddress()); e12.setCellStyle(styles.get(STYLE_CONTENT)); Cell e13 = row13.createCell(4); e13.setCellValue(bookLabelModel.getPostalCode()); e13.setCellStyle(styles.get(STYLE_CONTENT)); }
From source file:com.griffinslogistics.excel.BookLabelGenerator.java
private static void generateTitle(Sheet sheet, Map<String, CellStyle> styles, BookLabelModel bookLabelModel) { sheet.addMergedRegion(CellRangeAddress.valueOf("$A6:A7")); sheet.addMergedRegion(CellRangeAddress.valueOf("$D6:D7")); sheet.addMergedRegion(CellRangeAddress.valueOf("$A16:A17")); sheet.addMergedRegion(CellRangeAddress.valueOf("$D16:D17")); Row row6 = sheet.getRow(5);/*w w w . jav a2 s . co m*/ Row row7 = sheet.getRow(6); Cell a6 = row6.createCell(0); a6.setCellStyle(styles.get(STYLE_LABEL)); a6.setCellValue(TITLE); Cell a7 = row7.createCell(0); a7.setCellStyle(styles.get(STYLE_LABEL)); Cell b6 = row6.createCell(1); b6.setCellStyle(styles.get(STYLE_CONTENT)); b6.setCellValue(bookLabelModel.getTitle()); Cell b7 = row7.createCell(1); b7.setCellStyle(styles.get(STYLE_CONTENT)); b7.setCellValue(bookLabelModel.getBookNumber()); Cell d6 = row6.createCell(3); d6.setCellStyle(styles.get(STYLE_LABEL)); d6.setCellValue(TITLE); Cell d7 = row7.createCell(3); d7.setCellStyle(styles.get(STYLE_LABEL)); Cell e6 = row6.createCell(4); e6.setCellStyle(styles.get(STYLE_CONTENT)); e6.setCellValue(bookLabelModel.getTitle()); Cell e7 = row7.createCell(4); e7.setCellStyle(styles.get(STYLE_CONTENT)); e7.setCellValue(bookLabelModel.getBookNumber()); Row row16 = sheet.getRow(15); Row row17 = sheet.getRow(16); Cell a16 = row16.createCell(0); a16.setCellStyle(styles.get(STYLE_LABEL)); a16.setCellValue(TITLE); Cell a17 = row17.createCell(0); a17.setCellStyle(styles.get(STYLE_LABEL)); Cell b16 = row16.createCell(1); b16.setCellStyle(styles.get(STYLE_CONTENT)); b16.setCellValue(bookLabelModel.getTitle()); Cell b17 = row17.createCell(1); b17.setCellStyle(styles.get(STYLE_CONTENT)); b17.setCellValue(bookLabelModel.getBookNumber()); Cell d16 = row16.createCell(3); d16.setCellStyle(styles.get(STYLE_LABEL)); d16.setCellValue(TITLE); Cell d17 = row17.createCell(3); d17.setCellStyle(styles.get(STYLE_LABEL)); Cell e16 = row16.createCell(4); e16.setCellStyle(styles.get(STYLE_CONTENT)); e16.setCellValue(bookLabelModel.getTitle()); Cell e17 = row17.createCell(4); e17.setCellStyle(styles.get(STYLE_CONTENT)); e17.setCellValue(bookLabelModel.getBookNumber()); }
From source file:com.ideaspymes.proyecttemplate.stock.web.ProductoConsultaBean.java
@Override public Workbook getWorkBook() { Workbook wb = new XSSFWorkbook(); Sheet sheet = wb.createSheet("My Sample Excel"); List<CatalogoProductos> lista = (List<CatalogoProductos>) getDetalles(); sheet.setDefaultRowHeight((short) (sheet.getDefaultRowHeight() * new Short("6"))); org.apache.poi.ss.usermodel.Font fontTitulo = wb.createFont(); fontTitulo.setFontHeightInPoints((short) 12); fontTitulo.setBoldweight(org.apache.poi.ss.usermodel.Font.BOLDWEIGHT_BOLD); org.apache.poi.ss.usermodel.Font fontTituloPricipal = wb.createFont(); fontTituloPricipal.setFontHeightInPoints((short) 22); fontTituloPricipal.setBoldweight(org.apache.poi.ss.usermodel.Font.BOLDWEIGHT_BOLD); DataFormat format = wb.createDataFormat(); CellStyle styleTituloPrincipal = wb.createCellStyle(); styleTituloPrincipal.setFont(fontTituloPricipal); styleTituloPrincipal.setVerticalAlignment(CellStyle.VERTICAL_CENTER); styleTituloPrincipal.setAlignment(CellStyle.ALIGN_CENTER); CellStyle styleTitulo = wb.createCellStyle(); styleTitulo.setFont(fontTitulo);//from ww w.jav a 2s . c o m styleTitulo.setVerticalAlignment(CellStyle.VERTICAL_CENTER); styleTitulo.setFillForegroundColor(IndexedColors.BLUE_GREY.getIndex()); styleTitulo.setFillPattern(CellStyle.SOLID_FOREGROUND); styleTitulo.setWrapText(true); CellStyle styleNumero = wb.createCellStyle(); styleNumero.setDataFormat(format.getFormat("#,##0")); styleNumero.setWrapText(true); styleNumero.setVerticalAlignment(CellStyle.VERTICAL_CENTER); styleNumero.setAlignment(CellStyle.ALIGN_CENTER); CellStyle styleFecha = wb.createCellStyle(); styleFecha.setDataFormat(format.getFormat("dd/MM/yyyy")); styleFecha.setVerticalAlignment(CellStyle.VERTICAL_CENTER); styleFecha.setAlignment(CellStyle.ALIGN_CENTER); CellStyle style = wb.createCellStyle(); style.setVerticalAlignment(CellStyle.VERTICAL_CENTER); style.setWrapText(true); CellStyle styleCenter = wb.createCellStyle(); styleCenter.setVerticalAlignment(CellStyle.VERTICAL_CENTER); styleCenter.setAlignment(CellStyle.ALIGN_CENTER); styleCenter.setWrapText(true); Row rowTitle = sheet.createRow(0); Cell cellTitle = rowTitle.createCell(1); cellTitle.setCellStyle(styleTituloPrincipal); sheet.addMergedRegion(new CellRangeAddress(0, //first row (0-based) 1, //last row (0-based) 1, //first column (0-based) 11 //last column (0-based) )); cellTitle.setCellValue("Listado de Activos"); int i = 2; Row row0 = sheet.createRow(i); row0.setHeight((short) 500); Cell cell1 = row0.createCell(1); cell1.setCellValue("Foto"); cell1.setCellStyle(styleTitulo); Cell cellFecha = row0.createCell(3); cellFecha.setCellValue("Fecha Ingreso"); cellFecha.setCellStyle(styleTitulo); Cell cellFechaCarga = row0.createCell(4); cellFechaCarga.setCellValue("Fecha Carga"); cellFechaCarga.setCellStyle(styleTitulo); Cell cell3 = row0.createCell(5); cell3.setCellValue("Nombre"); cell3.setCellStyle(styleTitulo); Cell cell4 = row0.createCell(6); cell4.setCellValue("Cdigo"); cell4.setCellStyle(styleTitulo); Cell cell5 = row0.createCell(7); cell5.setCellValue("Descripcin"); cell5.setCellStyle(styleTitulo); Cell cell6 = row0.createCell(8); cell6.setCellValue("Es Regalo?"); cell6.setCellStyle(styleTitulo); Cell cell7 = row0.createCell(9); cell7.setCellValue("Familia"); cell7.setCellStyle(styleTitulo); Cell cell8 = row0.createCell(10); cell8.setCellValue("Ubicaciones"); cell8.setCellStyle(styleTitulo); Cell cell9 = row0.createCell(11); cell9.setCellValue("Stock"); cell9.setCellStyle(styleTitulo); for (CatalogoProductos cp : lista) { int indexFila = i + 1; if (cp.getImagen() != null) { int pictureIdx = wb.addPicture(cp.getImagen(), Workbook.PICTURE_TYPE_PNG); CreationHelper helper = wb.getCreationHelper(); //Creates the top-level drawing patriarch. Drawing drawing = sheet.createDrawingPatriarch(); //Create an anchor that is attached to the worksheet ClientAnchor anchor = helper.createClientAnchor(); //set top-left corner for the image anchor.setCol1(1); anchor.setRow1(indexFila); //Creates a picture Picture pict = drawing.createPicture(anchor, pictureIdx); //Reset the image to the original size pict.resize(0.4); } Row row1 = sheet.createRow(indexFila); row1.setHeightInPoints(80f); Cell cellColFecha = row1.createCell(3); if (cp.getFecha() != null) { cellColFecha.setCellValue(cp.getFecha()); cellColFecha.setCellStyle(styleFecha); } else { cellColFecha.setCellValue(""); cellColFecha.setCellStyle(styleFecha); } Cell cellColFechaCarga = row1.createCell(4); if (cp.getFechaCarga() != null) { cellColFechaCarga.setCellValue(cp.getFechaCarga()); cellColFechaCarga.setCellStyle(styleFecha); } else { cellColFechaCarga.setCellValue(""); cellColFechaCarga.setCellStyle(styleFecha); } Cell cellCol1 = row1.createCell(5); cellCol1.setCellValue(cp.getProducto()); cellCol1.setCellStyle(style); Cell cellCol2 = row1.createCell(6); cellCol2.setCellValue(cp.getCodigo()); cellCol2.setCellStyle(styleNumero); Cell cellCol3 = row1.createCell(7); cellCol3.setCellValue(cp.getDescripcion()); cellCol3.setCellStyle(style); Cell cellCol4 = row1.createCell(8); cellCol4.setCellValue(cp.isEsRegalo() ? "SI" : "NO"); cellCol4.setCellStyle(styleCenter); Cell cellCol5 = row1.createCell(9); cellCol5.setCellValue(cp.getFamilia()); cellCol5.setCellStyle(style); Cell cellCol6 = row1.createCell(10); cellCol6.setCellValue(cp.getUbicaciones()); cellCol6.setCellStyle(style); Cell cellCol7 = row1.createCell(11); cellCol7.setCellValue(cp.getStock()); cellCol7.setCellStyle(styleNumero); i++; } sheet.setColumnWidth(1, 4000); sheet.setColumnWidth(2, 0); sheet.setColumnWidth(3, 4000); sheet.setColumnWidth(4, 4000); sheet.setColumnWidth(5, 10000); sheet.setColumnWidth(6, 3000); sheet.setColumnWidth(7, 10000); sheet.setColumnWidth(8, 3500); sheet.setColumnWidth(9, 6000); sheet.setColumnWidth(10, 10000); sheet.setColumnWidth(11, 2000); return wb; }
From source file:com.inet.web.service.spi.download.ExportEmailWriterSpiService.java
License:Open Source License
/** * write group header/*from w ww . j a va 2 s .c o m*/ * @param sheet * @param group */ private void writeGroupHeader(Sheet sheet, LdapGroup group, CellStyle style) { Row headerRow = sheet.createRow(index); headerRow.setHeightInPoints(12); Cell cell = headerRow.createCell(STT); cell.setCellValue(group.getName() + " - " + group.getDescription()); cell.setCellStyle(style); sheet.addMergedRegion(new CellRangeAddress(index, index++, STT, MOBILE)); }
From source file:com.l3.info.magenda.emplois_du_temps.Jour.java
void writeInSheet(Workbook workbook, Sheet sheet, int x_sem, int y_sem) { Row[] row = new Row[1 + this.getNbrLigne()]; row[0] = sheet.createRow(y_sem);// w w w . java 2 s . c o m for (int i = 1; i < 1 + this.getNbrLigne(); i++) { row[i] = sheet.createRow(y_sem + i); row[i].setHeight(Workbook.PixelsToTwips(64)); } int x = x_sem, y = 0; Cell cell = row[y].createCell(x); cell.setCellValue(this.nom_jour); cell.setCellStyle(workbook.getCellStyle("nom_du_jour")); x++; for (int i = START_HOUR_OF_DAY; i <= END_HOUR_OF_DAY; i++) { cell = row[y].createCell(x); cell.setCellValue(i + "h"); cell.setCellStyle(workbook.getCellStyle("case_gauche_jour")); cell = row[y].createCell(x + 1); cell.setCellStyle(workbook.getCellStyle("case_droite_jour")); x += 2; } for (int i = 1; i <= this.getNbrLigne(); i++) { x = x_sem + 1; for (int j = (END_HOUR_OF_DAY - START_HOUR_OF_DAY + 1); j > 0; j--) { cell = row[i].createCell(x); cell.setCellStyle(workbook.getCellStyle("case_gauche_jour")); cell = row[i].createCell(x + 1); cell.setCellStyle(workbook.getCellStyle("case_droite_jour")); x += 2; } } x = x_sem; y = y_sem; for (int i = 1; i <= this.getNbrLigne(); i++) { cell = row[i].createCell(x); cell.setCellStyle(workbook.getCellStyle("nom_du_jour")); } sheet.addMergedRegion(new CellRangeAddress(y + 1, y + getNbrLigne(), x, x)); x = x_sem + 1; y = y_sem + 1; for (Horaire h : horaire_du_jour) { cell = row[1 + h.getLigne()].createCell((x + h.getColonne())); cell.setCellValue(h.toString()); cell.setCellStyle(workbook.getCellStyle("Style_" + h.getExamen().getDiplome())); for (int i = 1; i < h.getPlage_horraire(); i++) { cell = row[1 + h.getLigne()].createCell((x + h.getColonne() + i)); cell.setCellStyle(workbook.getCellStyle("Style_" + h.getExamen().getDiplome())); } if (h.getPlage_horraire() > 1) { sheet.addMergedRegion(new CellRangeAddress(y + h.getLigne(), (y + h.getLigne()), (x + h.getColonne()), (int) (x + h.getColonne() + h.getPlage_horraire() - 1))); } } }
From source file:com.l3.info.magenda.emplois_du_temps.Semaine.java
void writeInSheet(Workbook workbook, int week_of_year) { XSSFWorkbook xssfWorkbook = workbook.getWorkbook(); Sheet sheet = xssfWorkbook.createSheet("Sem. " + week_of_year); Row row = sheet.createRow((short) 0); row.setHeight(Workbook.PixelsToTwips(64)); Cell cell = row.createCell((short) 0); // first row (0-based) - last row (0-based) - first column (0-based) -last column (0-based) sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, (20 - 7) * 2 + 2)); // Cree une nouvelle police Font font = xssfWorkbook.createFont(); font.setFontHeightInPoints((short) 18); font.setFontName("Arial"); // Fonts are set into a style so create a new one to use. XSSFCellStyle style = xssfWorkbook.createCellStyle(); style.setAlignment(HorizontalAlignment.CENTER); style.setFont(font);//from ww w . ja v a 2s. c o m // Create a cell and put a value in it. cell.setCellValue("Semaine " + this.num_semaine); cell.setCellStyle(style); sheet.setDefaultRowHeight((short) 500); int x = 0, y = 2; for (Jour day : days_of_week) { day.writeInSheet(workbook, sheet, x, y); y += 2 + day.getNbrLigne(); } }
From source file:com.linus.excel.poi.MergingCells.java
License:Apache License
public static void main(String[] args) throws Exception { Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook(); Sheet sheet = wb.createSheet("new sheet"); Row row = sheet.createRow((short) 1); Cell cell = row.createCell((short) 1); cell.setCellValue(new XSSFRichTextString("This is a test of merging")); sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 2)); // Write the output to a file FileOutputStream fileOut = new FileOutputStream("excel/merging_cells.xlsx"); wb.write(fileOut);// ww w. j av a 2s . c o m fileOut.close(); }