List of usage examples for org.apache.poi.xwpf.usermodel XWPFTable setCellMargins
public void setCellMargins(int top, int left, int bottom, int right)
From source file:genrate_doc.java
void create_tt_word(String fname, String[][] tt) throws FileNotFoundException, IOException { XWPFDocument doc = new XWPFDocument(); insert_title(doc);// ww w .j ava 2 s.c o m changeOrientation(doc, "landscape"); XWPFTable table = doc.createTable(7, 10); table.setCellMargins(200, 200, 200, 200); XWPFTableRow row0 = table.getRow(0); XWPFTableCell r0_cell0 = row0.getCell(0); r0_cell0.setText("DAY/TIME"); XWPFTableRow row1 = table.getRow(1); XWPFTableCell r1_cell0 = row1.getCell(0); r1_cell0.setText("MON"); XWPFTableRow row2 = table.getRow(2); XWPFTableCell r2_cell0 = row2.getCell(0); r2_cell0.setText("TUE"); XWPFTableRow row3 = table.getRow(3); XWPFTableCell r3_cell0 = row3.getCell(0); r3_cell0.setText("WED"); XWPFTableRow row4 = table.getRow(4); XWPFTableCell r4_cell0 = row4.getCell(0); r4_cell0.setText("THR"); XWPFTableRow row5 = table.getRow(5); XWPFTableCell r5_cell0 = row5.getCell(0); r5_cell0.setText("FRI"); XWPFTableRow row6 = table.getRow(6); XWPFTableCell r6_cell0 = row6.getCell(0); r6_cell0.setText("SAT"); XWPFTableCell r0_cell1 = row0.getCell(1); r0_cell1.setText("08:40-09:40"); XWPFTableCell r0_cell2 = row0.getCell(2); r0_cell2.setText("09:40-10:40"); XWPFTableCell r0_cell3 = row0.getCell(3); r0_cell3.setText("10:40-11:00"); XWPFTableCell r0_cell4 = row0.getCell(4); r0_cell4.setText("11:00-12:00"); XWPFTableCell r0_cell5 = row0.getCell(5); r0_cell5.setText("12:00-01:00"); XWPFTableCell r0_cell6 = row0.getCell(6); r0_cell6.setText("01:00-01:40"); XWPFTableCell r0_cell7 = row0.getCell(7); r0_cell7.setText("01:40-02:30"); XWPFTableCell r0_cell8 = row0.getCell(8); r0_cell8.setText("02:30-03:20"); XWPFTableCell r0_cell9 = row0.getCell(9); r0_cell9.setText("03:20-04:10"); // writing the time table /* XWPFTableCell r1_cell1 = row1.getCell(1); r1_cell1.setText(tt[0][0]); XWPFTableCell r1_cell2 = row1.getCell(2); r1_cell2.setText(tt[0][1]); XWPFTableCell r1_cell3 = row1.getCell(3); r1_cell3.setText(tt[0][2]); XWPFTableCell r1_cell4 = row1.getCell(4); r1_cell4.setText("B"); XWPFTableCell r1_cell5 = row1.getCell(5); r1_cell5.setText(tt[0][3]); XWPFTableCell r1_cell6 = row1.getCell(6); r1_cell6.setText(tt[0][4]);*/ XWPFTableRow row; XWPFTableCell cell; for (int i = 0; i < 6; i++) { row = table.getRow(i + 1); for (int j = 0; j < 9; j++) { cell = row.getCell(j + 1); cell.setText(tt[i][j]); } } FileOutputStream output = new FileOutputStream("timetable\\" + fname + ".docx"); doc.write(output); output.close(); }
From source file:genrate_doc.java
void teach_doc(String fname, String teach[][]) throws FileNotFoundException, IOException { File fp = new File("teacher files\\" + fname + ".docx"); if (fp.exists()) { return;/*from w w w . j av a2s. c o m*/ } XWPFDocument doc = new XWPFDocument(); insert_title(doc); changeOrientation(doc, "landscape"); XWPFTable table = doc.createTable(7, 10); table.setCellMargins(200, 200, 200, 200); XWPFTableRow row0 = table.getRow(0); XWPFTableCell r0_cell0 = row0.getCell(0); r0_cell0.setText("DAY/TIME"); XWPFTableRow row1 = table.getRow(1); XWPFTableCell r1_cell0 = row1.getCell(0); r1_cell0.setText("MON"); XWPFTableRow row2 = table.getRow(2); XWPFTableCell r2_cell0 = row2.getCell(0); r2_cell0.setText("TUE"); XWPFTableRow row3 = table.getRow(3); XWPFTableCell r3_cell0 = row3.getCell(0); r3_cell0.setText("WED"); XWPFTableRow row4 = table.getRow(4); XWPFTableCell r4_cell0 = row4.getCell(0); r4_cell0.setText("THR"); XWPFTableRow row5 = table.getRow(5); XWPFTableCell r5_cell0 = row5.getCell(0); r5_cell0.setText("FRI"); XWPFTableRow row6 = table.getRow(6); XWPFTableCell r6_cell0 = row6.getCell(0); r6_cell0.setText("SAT"); XWPFTableCell r0_cell1 = row0.getCell(1); r0_cell1.setText("08:40-09:40"); XWPFTableCell r0_cell2 = row0.getCell(2); r0_cell2.setText("09:40-10:40"); XWPFTableCell r0_cell3 = row0.getCell(3); r0_cell3.setText("10:40-11:00"); XWPFTableCell r0_cell4 = row0.getCell(4); r0_cell4.setText("11:00-12:00"); XWPFTableCell r0_cell5 = row0.getCell(5); r0_cell5.setText("12:00-01:00"); XWPFTableCell r0_cell6 = row0.getCell(6); r0_cell6.setText("01:00-01:40"); XWPFTableCell r0_cell7 = row0.getCell(7); r0_cell7.setText("01:40-02:30"); XWPFTableCell r0_cell8 = row0.getCell(8); r0_cell8.setText("02:30-03:20"); XWPFTableCell r0_cell9 = row0.getCell(9); r0_cell9.setText("03:20-04:10"); // writing the time table /* XWPFTableCell r1_cell1 = row1.getCell(1); r1_cell1.setText(tt[0][0]); XWPFTableCell r1_cell2 = row1.getCell(2); r1_cell2.setText(tt[0][1]); XWPFTableCell r1_cell3 = row1.getCell(3); r1_cell3.setText(tt[0][2]); XWPFTableCell r1_cell4 = row1.getCell(4); r1_cell4.setText("B"); XWPFTableCell r1_cell5 = row1.getCell(5); r1_cell5.setText(tt[0][3]); XWPFTableCell r1_cell6 = row1.getCell(6); r1_cell6.setText(tt[0][4]);*/ XWPFTableRow row; XWPFTableCell cell; for (int i = 0; i < 6; i++) { row = table.getRow(i + 1); for (int j = 0; j < 9; j++) { cell = row.getCell(j + 1); cell.setText(teach[i][j]); } } FileOutputStream output = new FileOutputStream("teacher files\\" + fname + ".docx"); doc.write(output); output.close(); }
From source file:AkashApplications.src.GenerateInvoice.java
public boolean printInvoice(boolean printCommand) throws FileNotFoundException, InvalidFormatException, IOException { XWPFDocument document = new XWPFDocument(); CTSectPr sectPr = document.getDocument().getBody().addNewSectPr(); CTPageMar pageMar = sectPr.addNewPgMar(); pageMar.setLeft(BigInteger.valueOf(720L)); pageMar.setTop(BigInteger.valueOf(460L)); pageMar.setRight(BigInteger.valueOf(720L)); pageMar.setBottom(BigInteger.valueOf(460L)); XWPFParagraph dateP = document.createParagraph(); XWPFRun dateRun = dateP.createRun(); dateRun.addBreak();/*from w ww . j av a 2 s . c om*/ dateRun.setText(copyType); dateRun.setFontSize(8); dateRun.setItalic(true); dateP.setAlignment(ParagraphAlignment.RIGHT); dateRun.addBreak(); XWPFParagraph title = document.createParagraph(); XWPFRun titleRun = title.createRun(); titleRun.addBreak(); titleRun.setText("Delivery Challan"); titleRun.setBold(true); title.setAlignment(ParagraphAlignment.CENTER); titleRun.addBreak(); //header table XWPFTable productTable = document.createTable(); productTable.setCellMargins(50, 50, 50, 50); productTable.getCTTbl().getTblPr().unsetTblBorders(); productTable.getCTTbl().addNewTblPr().addNewTblW().setW(BigInteger.valueOf(11000)); XWPFTableRow row1 = productTable.getRow(0); XWPFTableCell cellSellerBuyer = row1.getCell(0); cellSellerBuyer.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(5000)); CTTc ctTc = cellSellerBuyer.getCTTc(); CTTcPr tcPr = ctTc.getTcPr(); CTTcBorders border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); // border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFParagraph seller = cellSellerBuyer.addParagraph(); XWPFRun sellerRun = seller.createRun(); seller.setAlignment(ParagraphAlignment.LEFT); sellerRun.setText("Buyer :"); sellerRun.addBreak(); String[] ar = buyerAddress.split("\n"); for (String s : ar) { sellerRun.setText(s); sellerRun.addBreak(); } XWPFTableCell cellProductDesc = row1.createCell(); cellProductDesc.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(6000)); ctTc = cellProductDesc.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); //border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFParagraph productDesc = cellProductDesc.addParagraph(); productDesc.setAlignment(ParagraphAlignment.LEFT); XWPFRun runInvoice = productDesc.createRun(); // if(table.getRowCount() == 1) // { // runInvoice.addTab(); // runInvoice.addTab(); // runInvoice.addTab(); // String imgLoc = "Barcodes/"+ dtm.getValueAt(0, 6) +".jpg"; // FileInputStream image = new FileInputStream(imgLoc); // runInvoice.addPicture(image, XWPFDocument.PICTURE_TYPE_JPEG,imgLoc, Units.toEMU(200), Units.toEMU(50)); // runInvoice.addBreak(); // runInvoice.addBreak(); // } runInvoice.setText("Delivery Note : "); runInvoice.addTab(); runInvoice.setText(invoiceNote); runInvoice.addBreak(); runInvoice.addBreak(); runInvoice.addBreak(); runInvoice.setText("Date : "); runInvoice.addTab(); runInvoice.setText(date); runInvoice.addBreak(); runInvoice.addBreak(); //document.createParagraph().createRun().addBreak(); XWPFTable productDetails = document.createTable(); productDetails.setCellMargins(50, 50, 50, 50); //productDetails.getCTTbl().getTblPr().addNewJc().setVal(STJc.RIGHT); productDetails.getCTTbl().getTblPr().unsetTblBorders(); productDetails.getCTTbl().addNewTblPr().addNewTblW().setW(BigInteger.valueOf(11000)); XWPFTableRow pDetailHeader = productDetails.getRow(0); XWPFTableCell header0 = pDetailHeader.getCell(0); header0.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); XWPFParagraph headerText = header0.addParagraph(); XWPFRun run = headerText.createRun(); run.setText("Sl. No."); run.setBold(true); ctTc = header0.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFTableCell header1 = pDetailHeader.createCell(); header1.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); XWPFParagraph headerText1 = header1.addParagraph(); XWPFRun run1 = headerText1.createRun(); run1.setText("Description of Goods"); run1.setBold(true); ctTc = header1.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFTableCell header4 = pDetailHeader.createCell(); header4.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); XWPFParagraph headerText4 = header4.addParagraph(); XWPFRun run4 = headerText4.createRun(); run4.setText("Quantity"); run4.setBold(true); ctTc = header4.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); for (int i = 0; i < 1; i++) { XWPFTableRow fTableRow = productDetails.createRow(); for (int j = 0; j < 4; j++) { XWPFTableCell cell = fTableRow.getCell(j); try { ctTc = cell.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); //border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); if (i == 0) border.addNewTop().setVal(STBorder.SINGLE); } catch (Exception e) { System.err.println(e.getMessage()); } switch (j) { case 0: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); break; case 1: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); break; case 2: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); break; } } } int qty = 0; for (int i = 0; i < table.getRowCount(); i++) { XWPFTableRow fTableRow = productDetails.createRow(); for (int j = 0; j < table.getColumnCount() - 1; j++) { XWPFTableCell cell = fTableRow.getCell(j); try { ctTc = cell.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); if (i == table.getRowCount() - 1) border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); // border.addNewTop().setVal(STBorder.SINGLE); } catch (Exception e) { System.err.println(e.getMessage()); } switch (j) { case 0: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); cell.setText(String.valueOf(dtm.getValueAt(i, j))); break; case 1: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); cell.setText(String.valueOf(dtm.getValueAt(i, j))); break; case 2: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); cell.setText(String.valueOf(dtm.getValueAt(i, j))); qty += Integer.parseInt(String.valueOf(dtm.getValueAt(i, j))); break; } } } XWPFTableRow finalRow = productDetails.createRow(); XWPFTableCell fc0 = finalRow.getCell(0); fc0.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); XWPFTableCell fc3 = finalRow.getCell(1); fc3.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); XWPFParagraph fp1 = fc3.addParagraph(); XWPFRun fRun1 = fp1.createRun(); fRun1.setBold(true); fRun1.setText("TOTAL"); XWPFTableCell fc4 = finalRow.getCell(2); fc4.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); XWPFParagraph fp2 = fc4.addParagraph(); XWPFRun fRun2 = fp2.createRun(); fRun2.setBold(true); fRun2.setText(String.valueOf(qty)); ctTc = fc0.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); //border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); ctTc = fc3.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); //border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); ctTc = fc4.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFParagraph netPMethod = document.createParagraph(); XWPFRun pMethodRun = netPMethod.createRun(); pMethodRun.addBreak(); pMethodRun.addBreak(); pMethodRun.setItalic(true); pMethodRun.setFontSize(10); pMethodRun.setText("NB. - Goods sold to the above buyer is in " + paymentType + "."); try { File f = new File(filePath); if (!f.exists()) { f.mkdir(); } FileOutputStream outputStream = new FileOutputStream(filePath + File.separator + "Challan" + invoiceNote.replace("/", "_") + copyType.replace("/", "_") + ".docx"); document.write(outputStream); outputStream.close(); new InvoiceNoteManager().setProperty(); if (printCommand) printDocument(); } catch (Exception e) { System.err.println(e.getMessage()); } return true; }
From source file:ch.admin.isb.hermes5.business.word.TranslationWordAdapter.java
License:Apache License
public byte[] write(List<TranslateableText> texts, String lang) { XWPFDocument document = new XWPFDocument(); // insert text into first row XWPFTable table = document.createTable(); table.setCellMargins(0, 100, 0, 100); XWPFTableRow rowOne = table.getRow(0); TranslateableText first = texts.get(0); rowOne.getCell(0).setText(first.getElementIdentifier() + "/ " + first.getTextIdentifier()); rowOne.addNewTableCell().setText(getText(first, lang)); if (isDirty(first, lang)) { rowOne.getCell(1).setColor("FFFF99"); }/*from www .j av a 2 s .com*/ // add more rows and insert text if (texts.size() > 1) { for (int c = 1; c < texts.size(); c++) { TranslateableText text = texts.get(c); XWPFTableRow row = table.createRow(); row.getCell(0).setText(text.getElementIdentifier() + "/ " + text.getTextIdentifier()); row.getCell(1).setText(getText(text, lang)); if (isDirty(text, lang)) { row.getCell(1).setColor("FFFF99"); } } } try { ByteArrayOutputStream outStream = new ByteArrayOutputStream(); document.write(outStream); return outStream.toByteArray(); } catch (IOException e) { throw new RuntimeException(e); } }
From source file:cn.afterturn.easypoi.word.parse.excel.ExcelEntityParse.java
License:Apache License
private int createCells(int index, Object t, List<ExcelExportEntity> excelParams, XWPFTable table, short rowHeight) { try {/* w ww .java 2s. c om*/ ExcelExportEntity entity; XWPFTableRow row = table.insertNewTableRow(index); if (rowHeight != -1) { row.setHeight(rowHeight); } int maxHeight = 1, cellNum = 0; for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) { entity = excelParams.get(k); if (entity.getList() != null) { Collection<?> list = (Collection<?>) entity.getMethod().invoke(t, new Object[] {}); int listC = 0; for (Object obj : list) { createListCells(index + listC, cellNum, obj, entity.getList(), table, rowHeight); listC++; } cellNum += entity.getList().size(); if (list != null && list.size() > maxHeight) { maxHeight = list.size(); } } else { Object value = getCellValue(entity, t); if (entity.getType() == 1) { setCellValue(row, value, cellNum++); } } } // ???? cellNum = 0; for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) { entity = excelParams.get(k); if (entity.getList() != null) { cellNum += entity.getList().size(); } else if (entity.isNeedMerge() && maxHeight > 1) { table.setCellMargins(index, index + maxHeight - 1, cellNum, cellNum); cellNum++; } } return maxHeight; } catch (Exception e) { LOGGER.error("excel cell export error ,data is :{}", ReflectionToStringBuilder.toString(t)); throw new ExcelExportException(ExcelExportEnum.EXPORT_ERROR, e); } }
From source file:com.foc.vaadin.gui.mswordGenerator.FocMSWordLayout.java
License:Apache License
public void applyBorderAttribute(XWPFTable newTable) { String borderAtt = getXmlAttribute().getValue(FXML.ATT_BORDER); if (borderAtt != null && (borderAtt.toLowerCase().equals("true") || borderAtt.equals("1"))) { } else {/*from w w w . j av a 2 s . c o m*/ newTable.getCTTbl().getTblPr().unsetTblBorders(); newTable.setInsideHBorder(XWPFBorderType.NONE, 0, 0, null); newTable.setInsideVBorder(XWPFBorderType.NONE, 0, 0, null); newTable.setRowBandSize(200); } newTable.setCellMargins(0, 0, 0, 0); }
From source file:com.qihang.winter.poi.word.parse.excel.ExcelEntityParse.java
License:Apache License
private int createCells(int index, Object t, List<com.qihang.winter.poi.excel.entity.params.ExcelExportEntity> excelParams, XWPFTable table, short rowHeight) throws Exception { com.qihang.winter.poi.excel.entity.params.ExcelExportEntity entity; XWPFTableRow row = table.createRow(); row.setHeight(rowHeight);/*from w w w . j a v a2 s . c o m*/ int maxHeight = 1, cellNum = 0; for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) { entity = excelParams.get(k); if (entity.getList() != null) { Collection<?> list = (Collection<?>) entity.getMethod().invoke(t, new Object[] {}); int listC = 0; for (Object obj : list) { createListCells(index + listC, cellNum, obj, entity.getList(), table); listC++; } cellNum += entity.getList().size(); if (list != null && list.size() > maxHeight) { maxHeight = list.size(); } } else { Object value = getCellValue(entity, t); if (entity.getType() == 1) { setCellValue(row, value, cellNum++); } } } // ???? cellNum = 0; for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) { entity = excelParams.get(k); if (entity.getList() != null) { cellNum += entity.getList().size(); } else if (entity.isNeedMerge()) { table.setCellMargins(index, index + maxHeight - 1, cellNum, cellNum); cellNum++; } } return maxHeight; }
From source file:com.siemens.sw360.licenseinfo.outputGenerators.DocxUtils.java
License:Open Source License
private static void styleTable(XWPFTable table) { table.setRowBandSize(1);/*from w w w .j av a2 s. c om*/ table.setWidth(1); table.setColBandSize(1); table.setCellMargins(1, 1, 100, 30); }
From source file:MainPackage.Controllers.OrderController.java
public void Print(Frame frame, Orders order, Account _account) { try {//from w w w. java 2s .c o m XWPFDocument document = new XWPFDocument(); File file = new File("Ha n " + order.getIdCode() + ".doc"); if (file.exists()) { file.createNewFile(); } FileOutputStream out = new FileOutputStream(file); XWPFParagraph paragraph = document.createParagraph(); paragraph.setAlignment(ParagraphAlignment.CENTER); XWPFRun run; // BookViewModel bookView = new BookViewModel(book); ///////////////// run = createFieldRun(paragraph, "CHI TIT HA ?N"); run.setFontSize(24); paragraph = createPrintInformation(document, _account); paragraph = createBookProductInformation(document, order); paragraph = createBookInformation(document, order); //create table XWPFTable table = document.createTable(); setTableAlignment(table, STJc.CENTER); table.setCellMargins(50, 50, 50, 50); table.setInsideHBorder(XWPFTable.XWPFBorderType.SINGLE, 10, 10, ""); table.setInsideVBorder(XWPFTable.XWPFBorderType.NONE, 20, 20, ""); //create first row XWPFTableRow row = table.getRow(0); row.setHeight(40); row.getCell(0).setText("STT"); row.addNewTableCell().setText("M Sn phm"); row.addNewTableCell().setText("Tn Sn phm"); row.addNewTableCell().setText("?n v"); row.addNewTableCell().setText("S lng"); row.addNewTableCell().setText("Gi ti?n"); row.addNewTableCell().setText("Thnh ti?n"); List<OrderLine> list = (List<OrderLine>) order.getOrderLineCollection(); for (int i = 0; i < list.size(); i++) { OrderLine line = list.get(i); row = table.createRow(); row.getCell(0).setText((i + 1) + ""); row.getCell(1).setText(line.getProductId().getIdCode()); row.getCell(2).setText(line.getProductId().getName()); row.getCell(3).setText("Quyn "); row.getCell(4).setText(line.getQuantity() + " "); row.getCell(5).setText(IntToVND(line.getUnitPrice()) + " "); row.getCell(6).setText(IntToVND(line.getTotalPrice()) + " "); } document.write(out); out.close(); if (Desktop.isDesktopSupported()) { Desktop.getDesktop().open(file); } JOptionPane .showMessageDialog(frame, "Xut file " + file.getName() + " thnh cng" + '\n' + "Ti v tr: " + file.getAbsolutePath(), "In thng tin Ha n", JOptionPane.INFORMATION_MESSAGE); } catch (Exception e) { System.out.println(e); JOptionPane.showMessageDialog(frame, "Xut file tht bi." + '\n' + "Vui lng ng ca s ang s dng file", "In thng tin Ha n", JOptionPane.WARNING_MESSAGE); } }
From source file:service.GenerationLettres.CreerPiecesManquantes.java
/** * * @param filename - Nom du fichier modle de demande des pices manquantes. * @param idDossier - Identifiant du dossier pour lequel l est cr * @throws InvalidFormatException/*from ww w . j a v a2s .c om*/ * @throws IOException */ public void replacePiecesManquantes(String filename, Formation formation, String sexe, String nom, String prenom, String adresse, Adresse adresseEntite, List<Justificatif> justificatifsOk) throws InvalidFormatException, IOException { List<Justificatif> lesJustificatifs = formation.getLesJustificatifs(); Date dateActuelle = new Date(); DateFormat dateForm = new SimpleDateFormat("dd MMMM yyyy", Locale.FRANCE); String date = dateForm.format(dateActuelle); String codePostal = adresseEntite.getCodePostal(); String ville = adresseEntite.getVille(); String civilite = ""; if (sexe.equals("Masculin")) civilite = "Monsieur"; if (sexe.equals("Feminin")) civilite = "Madame"; String intitule = formation.getIntitule(); if (justificatifsOk != null) { for (Justificatif just : justificatifsOk) { lesJustificatifs.remove(just); } } String newFileName = nom + prenom + " Lettre piecesManquantes.docx"; File file = new File(PATH_MODELS + "/" + filename); FileInputStream fis = new FileInputStream(file.getAbsolutePath()); XWPFDocument doc = new XWPFDocument(fis); doc.write(new FileOutputStream(PATH_TARGET + "/" + newFileName)); doc.close(); doc = new XWPFDocument(OPCPackage.open(PATH_TARGET + "/" + newFileName)); for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$formation")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$formation", intitule); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement de la formation effectue"); } } for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$date")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$date", date); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement de la date effectue"); } } for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$civilite")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$civilite", civilite); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement de la civilite effectue"); } } for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$prenom")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$prenom", prenom); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement du prenom effectue"); } } for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$nom")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$nom", nom); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement du nom effectue"); } } for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$adresse")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$adresse", adresse); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement de l'adresse effectue"); } } for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$codePostal")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$codePostal", codePostal); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement du code postal effectue"); } } for (XWPFParagraph p : doc.getParagraphs()) { int numberOfRuns = p.getRuns().size(); StringBuilder sb = new StringBuilder(); for (XWPFRun r : p.getRuns()) { int pos = r.getTextPosition(); if (r.getText(pos) != null) { sb.append(r.getText(pos)); } } if (sb.length() > 0 && sb.toString().contains("$ville")) { for (int i = numberOfRuns - 1; i > 0; i--) { p.removeRun(i); } String text = sb.toString().replace("$ville", ville); XWPFRun run = p.getRuns().get(0); run.setText(text, 0); System.out.println("Changement de la ville effectue"); } } XWPFTable table = doc.createTable(lesJustificatifs.size(), 2); table.setCellMargins(200, 250, 0, 250); int i = 0; for (XWPFTableRow r : table.getRows()) { XWPFTableCell cell = r.getCell(0); cell.setText(lesJustificatifs.get(i).getTitre()); cell = r.getCell(1); cell.setText(lesJustificatifs.get(i).getDescription()); i++; } doc.write(new FileOutputStream(PATH_TARGET + "/temp.docx")); new File(PATH_TARGET + "/temp.docx").delete(); doc.close(); //copyTempToFile(filename); System.out.println("replaceLettrePiecesManquantes DONE"); }