List of usage examples for org.apache.poi.xwpf.usermodel XWPFDocument createTable
public XWPFTable createTable()
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();// ww w . jav a2 s .c o m 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 w ww . j av a 2 s .c om*/ // 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.wantedonline.porobot.DataBaseEntity.java
License:Apache License
private static void genDBDictionary(List<DBTableBean> tableBeans) throws IOException { XWPFDocument doc = new XWPFDocument(); String databaseName = "default_database"; for (DBTableBean bean : tableBeans) { databaseName = bean.getDatabaseName(); XWPFParagraph p0 = doc.createParagraph(); p0.setAlignment(ParagraphAlignment.CENTER); XWPFRun r0 = p0.createRun();// w ww .j a v a2s . c om r0.setBold(true); r0.setText(databaseName); r0.setFontSize(16); XWPFParagraph p1 = doc.createParagraph(); p1.setAlignment(ParagraphAlignment.LEFT); XWPFRun r1 = p1.createRun(); r1.setBold(true); r1.setText("Table:" + bean.getTableName()); XWPFTable table = doc.createTable(); int pos = 0; XWPFTableRow row1 = table.insertNewTableRow(pos++); XWPFTableCell cell1 = row1.createCell(); cell1.setText("Field"); cell1.setColor("FFE4C4"); XWPFTableCell cell2 = row1.createCell(); cell2.setText("Type"); cell2.setColor("FFE4C4"); XWPFTableCell cell3 = row1.createCell(); cell3.setText("Comment"); cell3.setColor("FFE4C4"); for (int i = 0; i < bean.getColumnSize(); i++) { XWPFTableRow row = table.insertNewTableRow(pos++); XWPFTableCell cell11 = row.createCell(); cell11.setText(bean.getColumnName(i)); XWPFTableCell cell22 = row.createCell(); cell22.setText(bean.getColumnType(i)); XWPFTableCell cell33 = row.createCell(); cell33.setText(bean.getColumnComment(i)); } table.removeRow(pos); XWPFParagraph p2 = doc.createParagraph(); XWPFRun r2 = p2.createRun(); r2.addBreak(); } FileOutputStream out = new FileOutputStream(databaseName + ".docx"); doc.write(out); out.close(); doc.close(); }
From source file:com.crimelab.service.PolygraphServiceImpl.java
@Override public XWPFDocument create(Polygraph polygraph, HttpSession session) { XWPFDocument document = null; //Insert into dbase // polygraphDAO.polygraphInfo(polygraph); try {//from ww w . ja v a2s .c o m //Blank Document InputStream inpDocx = session.getServletContext() .getResourceAsStream("/WEB-INF/templates/Polygraph.docx"); document = new XWPFDocument(inpDocx); //create Paragraph XWPFParagraph subjectNo = document.createParagraph(); XWPFRun r1 = subjectNo.createRun(); r1.setText("POLYGRAPH SUBJECT NO: " + polygraph.getSubjectNo()); subjectNo.setAlignment(ParagraphAlignment.CENTER); r1.setBold(true); ; //create table XWPFTable table = document.createTable(); //width CTTbl tableFix = table.getCTTbl(); CTTblPr pr = tableFix.getTblPr(); CTTblWidth tblW = pr.getTblW(); tblW.setW(BigInteger.valueOf(4800)); tblW.setType(STTblWidth.PCT); pr.setTblW(tblW); tableFix.setTblPr(pr); //create first row XWPFTableRow tableRowOne = table.getRow(0); XWPFTableCell headerCell = tableRowOne.getCell(0); XWPFParagraph headerParagraph = headerCell.getParagraphs().get(0); XWPFRun hRun = headerParagraph.createRun(); headerCell.setColor("CDCDB4"); hRun.setText("PERSONAL INFORMATION"); tableRowOne.addNewTableCell().setText(null); headerParagraph.setAlignment(ParagraphAlignment.CENTER); XWPFTableCell photoHeaderCell = tableRowOne.getCell(1); XWPFParagraph photoHeaderParagraph = photoHeaderCell.getParagraphs().get(0); XWPFRun pRun = photoHeaderParagraph.createRun(); photoHeaderCell.setColor("CDCDB4"); pRun.setText("PHOTO"); photoHeaderParagraph.setAlignment(ParagraphAlignment.CENTER); XWPFTableRow tableRowTwo = table.createRow(); XWPFTableCell cell = tableRowTwo.getCell(0); XWPFParagraph personalInfo = cell.getParagraphs().get(0); XWPFRun r2 = personalInfo.createRun(); r2.setText("Name"); r2.addTab(); r2.addTab(); r2.setText(": " + polygraph.getName()); r2.addBreak(); r2.setText("Gender"); r2.addTab(); r2.addTab(); r2.setText(": " + polygraph.getGender()); r2.addBreak(); r2.setText("Age"); r2.addTab(); r2.addTab(); r2.setText(": " + polygraph.getAge()); r2.addBreak(); r2.setText("Date of Birth"); r2.addTab(); r2.setText(": " + polygraph.getBirthdate()); r2.addBreak(); r2.setText("Civil Status"); r2.addTab(); r2.setText(": " + polygraph.getCivilStatus()); r2.addBreak(); r2.setText("ID Presented"); r2.addTab(); r2.setText(": " + polygraph.getIdPresented()); r2.addBreak(); r2.setText("Address"); r2.addTab(); r2.setText(": " + polygraph.getAddress()); //Adding the picture XWPFTableCell pictureCell = tableRowTwo.getCell(1); XWPFParagraph pictureHolder = pictureCell.getParagraphs().get(0); XWPFRun pictureRun = pictureHolder.createRun(); FileInputStream getPhoto = new FileInputStream(polygraph.getPhotoLocation()); FileInputStream getImage = new FileInputStream(polygraph.getPhotoLocation()); ImageInputStream imageInput = ImageIO.createImageInputStream(getPhoto); BufferedImage bi = ImageIO.read(imageInput); pictureHolder.setAlignment(ParagraphAlignment.RIGHT); pictureRun.addPicture(getImage, XWPFDocument.PICTURE_TYPE_JPEG, null, Units.toEMU(120), Units.toEMU(120)); XWPFParagraph spacing = document.createParagraph(); XWPFRun spacingRun = spacing.createRun(); //create table XWPFTable otherTable = document.createTable(); //width CTTbl tableFixTwo = otherTable.getCTTbl(); CTTblPr prTwo = tableFixTwo.getTblPr(); CTTblWidth tblWTwo = prTwo.getTblW(); tblWTwo.setW(BigInteger.valueOf(4800)); tblWTwo.setType(STTblWidth.PCT); prTwo.setTblW(tblWTwo); tableFixTwo.setTblPr(prTwo); XWPFTableRow examInfoHeader = otherTable.createRow(); XWPFTableCell cellInfo = examInfoHeader.getCell(0); XWPFParagraph examInfo = cellInfo.getParagraphs().get(0); XWPFRun r3 = examInfo.createRun(); cellInfo.setColor("CDCDB4"); r3.setText("EXAM INFORMATION"); examInfo.setAlignment(ParagraphAlignment.CENTER); XWPFTableRow examInfoRow = otherTable.createRow(); XWPFTableCell cellRowInfo = examInfoRow.getCell(0); XWPFParagraph examInfoRowP = cellRowInfo.getParagraphs().get(0); XWPFRun examRun = examInfoRowP.createRun(); examRun.setText("Case Number"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getCaseNo()); examRun.addBreak(); examRun.setText("Requesting Party"); examRun.addTab(); examRun.setText(": " + polygraph.getRequestingParty()); examRun.addBreak(); examRun.setText("Time/Date Received"); examRun.addTab(); examRun.setText(": " + polygraph.getTimeDateReceived()); examRun.addBreak(); examRun.setText("Nature of Case"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getNatureOfCase()); examRun.addBreak(); examRun.setText("Exam Location"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getExamLocation()); examRun.addBreak(); examRun.setText("Exam Date"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getExamDate()); otherTable.removeRow(0); XWPFParagraph purposeOfExamination = document.createParagraph(); XWPFRun r4 = purposeOfExamination.createRun(); r4.setUnderline(UnderlinePatterns.SINGLE); r4.addBreak(); r4.setText("SECTION 1: PURPOSE OF EXAMINATION"); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); XWPFParagraph purposeOfExaminationContents = document.createParagraph(); XWPFRun r4Contents = purposeOfExaminationContents.createRun(); r4Contents.setText(polygraph.getPurpose()); XWPFParagraph preTestInterview = document.createParagraph(); XWPFRun r5 = preTestInterview.createRun(); r5.setUnderline(UnderlinePatterns.SINGLE); r5.setText("SECTION 2: PRE-TEST INTERVIEW"); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); XWPFParagraph preTestInterviewContents = document.createParagraph(); XWPFRun r5Contents = preTestInterviewContents.createRun(); r5Contents.setText(polygraph.getPreTest()); XWPFParagraph inTestPhase = document.createParagraph(); XWPFRun r6 = inTestPhase.createRun(); r6.setUnderline(UnderlinePatterns.SINGLE); r6.setText("SECTION 3: IN-TEST PHASE"); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); XWPFParagraph inTestPhaseContents = document.createParagraph(); XWPFRun r6Contents = inTestPhaseContents.createRun(); r6Contents.setText(polygraph.getInTest()); XWPFParagraph result = document.createParagraph(); XWPFRun r7 = result.createRun(); r7.setUnderline(UnderlinePatterns.SINGLE); r7.setText("SECTION 4: RESULT"); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); XWPFParagraph resultContents = document.createParagraph(); XWPFRun r7Contents = resultContents.createRun(); r7Contents.setText(polygraph.getResult()); XWPFParagraph postTestInterview = document.createParagraph(); XWPFRun r8 = postTestInterview.createRun(); r8.setUnderline(UnderlinePatterns.SINGLE); r8.setText("SECTION 5: POST-TEST INTERVIEW"); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); XWPFParagraph postTestInterviewContents = document.createParagraph(); XWPFRun r8Contents = postTestInterviewContents.createRun(); r8Contents.setText(polygraph.getPostTest()); XWPFParagraph remarks = document.createParagraph(); XWPFRun r9 = remarks.createRun(); r9.setUnderline(UnderlinePatterns.SINGLE); r9.setText("REMARKS:"); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); XWPFParagraph remarksContents = document.createParagraph(); XWPFRun r9Contents = remarksContents.createRun(); r9Contents.setText(polygraph.getRemarks()); XWPFParagraph timeDateCompleted = document.createParagraph(); XWPFRun r10 = timeDateCompleted.createRun(); r10.setUnderline(UnderlinePatterns.SINGLE); r10.setText("TIME AND DATE COMPLETED:"); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); XWPFParagraph timeDateCompletedContents = document.createParagraph(); XWPFRun r10Contents = timeDateCompletedContents.createRun(); r10Contents.setText(polygraph.getTimeDateCompleted()); XWPFParagraph examinedBy = document.createParagraph(); XWPFRun r11 = examinedBy.createRun(); r11.setUnderline(UnderlinePatterns.SINGLE); r11.setText("EXAMINED BY:"); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); XWPFParagraph examinedByContents = document.createParagraph(); XWPFRun r11Contents = examinedByContents.createRun(); r11Contents.setText(polygraph.getExaminerName()); r11Contents.addBreak(); r11Contents.setText(polygraph.getExaminerRank()); r11Contents.addBreak(); r11Contents.setText(polygraph.getExaminerPosition()); XWPFParagraph approvedBy = document.createParagraph(); XWPFRun r12 = approvedBy.createRun(); r12.setUnderline(UnderlinePatterns.SINGLE); r12.setText("APPROVED BY:"); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); XWPFParagraph approvedByContents = document.createParagraph(); XWPFRun r12Contents = approvedByContents.createRun(); // r12Contents.setText(polygraph.getApprovedName()); // r12Contents.addBreak(); // r12Contents.setText(polygraph.getApprovedRank()); // r12Contents.addBreak(); // r12Contents.setText(polygraph.getApprovedPosition()); // r12Contents.addBreak(); XWPFParagraph notedBy = document.createParagraph(); XWPFRun r13 = notedBy.createRun(); r13.setUnderline(UnderlinePatterns.SINGLE); r13.setText("NOTED BY:"); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); XWPFParagraph notedByContents = document.createParagraph(); XWPFRun r13Contents = notedByContents.createRun(); r13Contents.setText(polygraph.getNotedName()); r13Contents.addBreak(); r13Contents.setText(polygraph.getNotedRank()); r13Contents.addBreak(); r13Contents.setText(polygraph.getNotedPosition()); r13Contents.addBreak(); table.setInsideVBorder(XWPFTable.XWPFBorderType.NIL, 0, 0, "white"); document.getXWPFDocument(); } catch (Exception e) { e.printStackTrace(); } return document; }
From source file:com.dexter.fms.mbean.ReportsMBean.java
private void exportWordTable(int type, XWPFDocument document) { XWPFTable table = document.createTable(); switch (type) { case 1: // all users report {/*from w w w . j a va 2s .com*/ XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "User name", true); addHeaderCell(tableRowOne, "Full name", false); addHeaderCell(tableRowOne, "Email", false); addHeaderCell(tableRowOne, "Department", false); addHeaderCell(tableRowOne, "Region", false); addHeaderCell(tableRowOne, "Phone", false); addHeaderCell(tableRowOne, "Position", false); if (getAllUsers() != null) { for (PartnerUser e : getAllUsers()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getUsername()); tableRow.getCell(1) .setText(e.getPersonel().getFirstname() + " " + e.getPersonel().getLastname()); tableRow.getCell(2).setText(e.getPersonel().getEmail()); tableRow.getCell(3) .setText((e.getPersonel().getDepartment() != null) ? e.getPersonel().getDepartment().getName() : "N/A"); tableRow.getCell(4).setText( (e.getPersonel().getRegion() != null) ? e.getPersonel().getRegion().getName() : "N/A"); tableRow.getCell(5).setText(e.getPersonel().getPhone()); tableRow.getCell(6).setText(e.getPersonel().getPosition()); } } break; } case 2: // due driver's license { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Full Name", true); addHeaderCell(tableRowOne, "Dept", false); addHeaderCell(tableRowOne, "Region", false); addHeaderCell(tableRowOne, "Phone", false); addHeaderCell(tableRowOne, "Position", false); addHeaderCell(tableRowOne, "License Due Date", false); if (getDueDriversLic() != null) { for (DriverLicense e : getDueDriversLic()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getDriver().getPersonel().getFirstname() + " " + e.getDriver().getPersonel().getLastname()); tableRow.getCell(1) .setText(e.getDriver().getPersonel().getDepartment() != null ? e.getDriver().getPersonel().getDepartment().getName() : "N/A"); tableRow.getCell(2) .setText(e.getDriver().getPersonel().getRegion() != null ? e.getDriver().getPersonel().getRegion().getName() : "N/A"); tableRow.getCell(3).setText(e.getDriver().getPersonel().getPhone()); tableRow.getCell(4).setText(e.getDriver().getPersonel().getPosition()); tableRow.getCell(5).setText(e.getLic_end_dt().toLocaleString()); } } break; } case 3: // accidents { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Accident Date", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Driver", false); addHeaderCell(tableRowOne, "Driver Comment", false); addHeaderCell(tableRowOne, "Police Officer", false); addHeaderCell(tableRowOne, "Police Station", false); addHeaderCell(tableRowOne, "Police Comment", false); if (getVehicleAccidents() != null) { for (VehicleAccident e : getVehicleAccidents()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getAccident_dt().toLocaleString()); tableRow.getCell(2).setText(e.getAccidentDescription()); tableRow.getCell(3).setText(e.getDriver_name()); tableRow.getCell(4).setText(e.getDriverComment()); tableRow.getCell(5).setText(e.getPoliceOfficer()); tableRow.getCell(6).setText(e.getPoliceStation()); tableRow.getCell(7).setText(e.getPoliceComment()); } } break; } case 4: // vehicles by brand { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Make", true); addHeaderCell(tableRowOne, "Model", false); addHeaderCell(tableRowOne, "Year", false); addHeaderCell(tableRowOne, "Reg No.", false); if (getVehiclesByBrand() != null) { for (Vehicle e : getVehiclesByBrand()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getModel().getMaker().getName()); tableRow.getCell(1).setText(e.getModel().getName()); tableRow.getCell(2).setText(e.getModel().getYear()); tableRow.getCell(3).setText(e.getRegistrationNo()); } } break; } case 5: // routine maintenance { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Requester", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Start Date", false); addHeaderCell(tableRowOne, "Initial Cost", false); addHeaderCell(tableRowOne, "Status", false); addHeaderCell(tableRowOne, "Close Date", false); addHeaderCell(tableRowOne, "Final Cost", false); if (getRmaints() != null) { for (VehicleRoutineMaintenance e : getRmaints()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getCreatedBy().getPersonel().getFirstname() + " " + e.getCreatedBy().getPersonel().getLastname()); tableRow.getCell(2).setText(e.getDescription()); tableRow.getCell(3).setText(e.getStart_dt().toLocaleString()); tableRow.getCell(4).setText(e.getInitial_amount().toPlainString()); tableRow.getCell(5).setText(e.getStatus()); tableRow.getCell(6).setText(e.getClose_dt().toLocaleString()); tableRow.getCell(7).setText(e.getClosed_amount().toPlainString()); } } break; } case 6: // ad hoc maintenance { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Requester", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Start Date", false); addHeaderCell(tableRowOne, "Initial Cost", false); addHeaderCell(tableRowOne, "Status", false); addHeaderCell(tableRowOne, "Close Date", false); addHeaderCell(tableRowOne, "Final Cost", false); if (getAdhocmaints() != null) { for (VehicleAdHocMaintenance e : getAdhocmaints()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getCreatedBy().getPersonel().getFirstname() + " " + e.getCreatedBy().getPersonel().getLastname()); tableRow.getCell(2).setText(e.getDescription()); tableRow.getCell(3).setText(e.getStart_dt().toLocaleString()); tableRow.getCell(4).setText(e.getInitial_cost().toPlainString()); tableRow.getCell(5).setText(e.getStatus()); tableRow.getCell(6).setText(e.getClose_dt().toLocaleString()); tableRow.getCell(7).setText(e.getClosed_cost().toPlainString()); } } break; } case 7: // active accidents { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Accident Date", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Driver Name", false); addHeaderCell(tableRowOne, "Driver Comment", false); addHeaderCell(tableRowOne, "Police Name", false); addHeaderCell(tableRowOne, "Station Name", false); addHeaderCell(tableRowOne, "Police Comment", false); if (getActiveAccidents() != null) { for (VehicleAccident e : getActiveAccidents()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getAccident_dt().toLocaleString()); tableRow.getCell(2).setText(e.getAccidentDescription()); tableRow.getCell(3).setText(e.getDriver_name()); tableRow.getCell(4).setText(e.getDriverComment()); tableRow.getCell(5).setText(e.getPoliceOfficer()); tableRow.getCell(6).setText(e.getPoliceStation()); tableRow.getCell(7).setText(e.getPoliceComment()); } } break; } case 8: // coporate trips { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Requester", true); addHeaderCell(tableRowOne, "Department", false); addHeaderCell(tableRowOne, "Reg No.", false); addHeaderCell(tableRowOne, "Departure Location", false); addHeaderCell(tableRowOne, "Arrival Location", false); addHeaderCell(tableRowOne, "Departure Date and Time", false); addHeaderCell(tableRowOne, "Est. Arrival Date and Time", false); addHeaderCell(tableRowOne, "Act. Arrival Date and Time", false); addHeaderCell(tableRowOne, "Status", false); if (getCorTrips() != null) { for (CorporateTrip e : getCorTrips()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getStaff().getFirstname() + " " + e.getStaff().getLastname()); tableRow.getCell(1) .setText((e.getStaff().getDepartment() != null) ? e.getStaff().getDepartment().getName() : "N/A"); tableRow.getCell(2) .setText(e.getVehicle() != null ? e.getVehicle().getRegistrationNo() : "N/A"); tableRow.getCell(3).setText(e.getDepartureLocation()); tableRow.getCell(4).setText(e.getArrivalLocation()); tableRow.getCell(5).setText(e.getDepartureDateTime().toLocaleString()); tableRow.getCell(6).setText(e.getEstimatedArrivalDateTime().toLocaleString()); tableRow.getCell(7) .setText(e.getCompleteRequestDateTime() != null ? e.getCompleteRequestDateTime().toLocaleString() : "N/A"); tableRow.getCell(8).setText(e.getTripStatus()); } } break; } case 9: // expense report { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Type", true); addHeaderCell(tableRowOne, "Date", false); addHeaderCell(tableRowOne, "Amount", false); addHeaderCell(tableRowOne, "Detail", false); if (getExpenses() != null) { for (Expense e : getExpenses()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getType().getName()); tableRow.getCell(0).setText(e.getExpense_dt().toLocaleString()); tableRow.getCell(0).setText("" + e.getAmount()); tableRow.getCell(0).setText(e.getRemarks()); } } break; } case 10: // vehicle ages { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Make", true); addHeaderCell(tableRowOne, "Model", false); addHeaderCell(tableRowOne, "Year", false); addHeaderCell(tableRowOne, "Reg No.", false); addHeaderCell(tableRowOne, "Date of Purchase", false); addHeaderCell(tableRowOne, "Age (in years)", false); if (getVehiclesAges() != null) { for (Vehicle e : getVehiclesAges()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0) .setText(e.getModel().getMaker() != null ? e.getModel().getMaker().getName() : "N/A"); tableRow.getCell(1).setText(e.getModel() != null ? e.getModel().getName() : "N/A"); tableRow.getCell(2).setText(e.getModel() != null ? e.getModel().getYear() : "N/A"); tableRow.getCell(3).setText(e.getRegistrationNo()); tableRow.getCell(4) .setText(e.getPurchaseDate() != null ? e.getPurchaseDate().toLocaleString() : "N/A"); tableRow.getCell(5).setText("" + e.getAge()); } } break; } case 11: // vehicle fuelings { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Date", true); addHeaderCell(tableRowOne, "Reg No.", false); addHeaderCell(tableRowOne, "Litres", false); addHeaderCell(tableRowOne, "Amount", false); addHeaderCell(tableRowOne, "Source", false); if (getFuelings() != null) { for (VehicleFueling e : getFuelings()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getCaptured_dt().toLocaleString()); tableRow.getCell(1).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(2).setText("" + e.getLitres()); tableRow.getCell(3).setText("" + e.getAmt()); tableRow.getCell(4).setText(e.getSource()); } } break; } case 12: // due vehicle licenses { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Fleet", false); addHeaderCell(tableRowOne, "Make", false); addHeaderCell(tableRowOne, "Model", false); addHeaderCell(tableRowOne, "License Due Date", false); if (getDueVehicleLicenses() != null) { for (VehicleLicense e : getDueVehicleLicenses()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getVehicle().getFleet().getName()); tableRow.getCell(2) .setText(e.getVehicle().getModel() != null ? e.getVehicle().getModel().getMaker().getName() : "N/A"); tableRow.getCell(3).setText( e.getVehicle().getModel() != null ? e.getVehicle().getModel().getName() : "N/A"); tableRow.getCell(4).setText(e.getLic_end_dt().toLocaleString()); } } break; } } }
From source file:com.foc.vaadin.gui.layouts.validationLayout.FVValidationLayout.java
License:Apache License
private void createWordTableRows() { try {/* w ww.ja v a2s. c o m*/ XWPFDocument document = new XWPFDocument(); XWPFTable tableOne = document.createTable(); XWPFTableRow row = null; for (int i = 0; i < 10; i++) { row = tableOne.createRow(); row.getCell(0).setText("Row Number: " + i); } FileOutputStream outStream = new FileOutputStream( "C://Users//user//Desktop//POI Word Doc Sample Table 1.docx"); document.write(outStream); outStream.close(); } catch (Exception ex) { Globals.logException(ex); } }
From source file:com.foc.vaadin.gui.layouts.validationLayout.FVValidationLayout.java
License:Apache License
private void createWordTable() { try {/*from w w w. jav a 2 s . c om*/ XWPFDocument document = new XWPFDocument(); // New 2x2 table XWPFTable tableOne = document.createTable(); XWPFTableRow tableOneRowOne = tableOne.getRow(0); tableOneRowOne.setRepeatHeader(true); tableOneRowOne.getCell(0).setText("Hello"); tableOneRowOne.addNewTableCell().setText("World"); XWPFTableRow tableOneRowTwo = tableOne.createRow(); tableOneRowTwo.getCell(0).setText("This is"); tableOneRowTwo.getCell(1).setText("a table"); for (int i = 1; i < 50; i++) { tableOneRowTwo = tableOne.createRow(); tableOneRowTwo.getCell(0).setText("row " + i + " tol 0 bla bla very long string"); tableOneRowTwo.getCell(1).setText("row " + i + " col 1"); } //Add a break between the tables document.createParagraph().createRun().addBreak(); // New 3x3 table XWPFTable tableTwo = document.createTable(); XWPFTableRow tableTwoRowOne = tableTwo.getRow(0); tableTwoRowOne.getCell(0).setText("col one, row one"); tableTwoRowOne.addNewTableCell().setText("col two, row one"); tableTwoRowOne.addNewTableCell().setText("col three, row one"); XWPFTableRow tableTwoRowTwo = tableTwo.createRow(); tableTwoRowTwo.getCell(0).setText("col one, row two"); tableTwoRowTwo.getCell(1).setText("col two, row two"); tableTwoRowTwo.getCell(2).setText("col three, row two"); XWPFTableRow tableTwoRowThree = tableTwo.createRow(); tableTwoRowThree.getCell(0).setText("col one, row three"); tableTwoRowThree.getCell(1).setText("col two, row three"); tableTwoRowThree.getCell(2).setText("col three, row three"); FileOutputStream outStream = new FileOutputStream( "C://Users//user//Desktop//POI Word Doc Sample Table 1.docx"); document.write(outStream); outStream.close(); } catch (Exception e) { e.printStackTrace(); } }
From source file:com.min.word.core.MakeWordFileTest.java
License:Apache License
public static void main(String[] args) throws Exception { String fileName = "test.docx"; System.out.println("---------- Word Create Start ------------"); // word ? ?// w ww . ja va 2 s. com XWPFDocument document = new XWPFDocument(); FileOutputStream out = new FileOutputStream(new File(fileName)); System.out.println("---------- Create Blank Success ------------"); //Paragraph ? XWPFParagraph paragraph = document.createParagraph(); System.out.println("---------- Create Paragraph Success ------------"); //border ? paragraph.setBorderBottom(Borders.BASIC_BLACK_DASHES); paragraph.setBorderLeft(Borders.BASIC_BLACK_DASHES); paragraph.setBorderRight(Borders.BASIC_BLACK_DASHES); paragraph.setBorderTop(Borders.BASIC_BLACK_DASHES); System.out.println("---------- Create Border Success ------------"); XWPFRun run = paragraph.createRun(); run.setText("At tutorialspoint.com, we strive hard to " + "provide quality tutorials for self-learning " + "purpose in the domains of Academics, Information " + "Technology, Management and Computer Programming Languages."); System.out.println("---------- Text Write to File ------------"); //Table ? XWPFTable table = document.createTable(); //row XWPFTableRow rowOne = table.getRow(0); rowOne.getCell(0).setText("Col One, Row One"); rowOne.addNewTableCell().setText("Col Tow, Row One"); rowOne.addNewTableCell().setText("Col Three, Row One"); //row XWPFTableRow rowTow = table.createRow(); rowTow.getCell(0).setText("Col One, Row Tow"); rowTow.getCell(1).setText("Col Tow, Row Tow"); rowTow.getCell(2).setText("Col Three, Row Tow"); //row XWPFTableRow rowThree = table.createRow(); rowThree.getCell(0).setText("Col One, Row Three"); rowThree.getCell(1).setText("Col Tow, Row Three"); rowThree.getCell(2).setText("Col Three, Row Three"); System.out.println("---------- Create Table Success ------------"); //Add Image XWPFParagraph imageParagraph = document.createParagraph(); XWPFRun imageRun = imageParagraph.createRun(); imageRun.addPicture(new FileInputStream("test.png"), XWPFDocument.PICTURE_TYPE_PNG, "test.png", Units.toEMU(300), Units.toEMU(300)); System.out.println("---------- Create Image Success ------------"); //Hyperlink XWPFParagraph hyperlink = document.createParagraph(); String id = hyperlink.getDocument().getPackagePart() .addExternalRelationship("http://niee.kr", XWPFRelation.HYPERLINK.getRelation()).getId(); CTR ctr = CTR.Factory.newInstance(); CTHyperlink ctHyperlink = hyperlink.getCTP().addNewHyperlink(); ctHyperlink.setId(id); CTText ctText = CTText.Factory.newInstance(); ctText.setStringValue("Hyper-Link TEST"); ctr.setTArray(new CTText[] { ctText }); // ???? ? CTColor color = CTColor.Factory.newInstance(); color.setVal("0000FF"); CTRPr ctrPr = ctr.addNewRPr(); ctrPr.setColor(color); ctrPr.addNewU().setVal(STUnderline.SINGLE); // CTFonts fonts = ctrPr.isSetRFonts() ? ctrPr.getRFonts() : ctrPr.addNewRFonts(); fonts.setAscii("?? "); fonts.setEastAsia("?? "); fonts.setHAnsi("?? "); // ? CTHpsMeasure sz = ctrPr.isSetSz() ? ctrPr.getSz() : ctrPr.addNewSz(); sz.setVal(new BigInteger("24")); ctHyperlink.setRArray(new CTR[] { ctr }); hyperlink.setAlignment(ParagraphAlignment.LEFT); hyperlink.setVerticalAlignment(TextAlignment.CENTER); System.out.println("---------- Create Hyperlink Success ------------"); //Font style XWPFParagraph fontStyle = document.createParagraph(); //set Bold an Italic XWPFRun boldAnItalic = fontStyle.createRun(); boldAnItalic.setBold(true); boldAnItalic.setItalic(true); boldAnItalic.setText("Bold an Italic"); boldAnItalic.addBreak(); //set Text Position XWPFRun textPosition = fontStyle.createRun(); textPosition.setText("Set Text Position"); textPosition.setTextPosition(100); //Set Strike through and font Size and Subscript XWPFRun otherStyle = fontStyle.createRun(); otherStyle.setStrike(true); otherStyle.setFontSize(20); otherStyle.setSubscript(VerticalAlign.SUBSCRIPT); otherStyle.setText(" Set Strike through and font Size and Subscript"); System.out.println("---------- Set Font Style ------------"); //Set Alignment Paragraph XWPFParagraph alignment = document.createParagraph(); //Alignment to Right alignment.setAlignment(ParagraphAlignment.RIGHT); XWPFRun alignRight = alignment.createRun(); alignRight.setText( "At tutorialspoint.com, we strive hard to " + "provide quality tutorials for self-learning " + "purpose in the domains of Academics, Information " + "Technology, Management and Computer Programming " + "Languages."); //Alignment to Center alignment = document.createParagraph(); //Alignment to Right alignment.setAlignment(ParagraphAlignment.CENTER); XWPFRun alignCenter = alignment.createRun(); alignCenter.setText("The endeavour started by Mohtashim, an AMU " + "alumni, who is the founder and the managing director " + "of Tutorials Point (I) Pvt. Ltd. He came up with the " + "website tutorialspoint.com in year 2006 with the help" + "of handpicked freelancers, with an array of tutorials" + " for computer programming languages. "); System.out.println("---------- Set Alignment ------------"); //word ? document.write(out); out.close(); System.out.println("---------- Save File Name : " + fileName + " ------------"); System.out.println("---------- Word Create End ------------"); }
From source file:csv2docxconverter.DocumentGenerator.java
/** * Generate DocX element from list of the rows containing account information * @param columnNames a list of columns for data parsing * @param contents list of data rows for parsing * @return an XWPFDocument representing a DocX file *//*from w w w .j a va 2s . c o m*/ public XWPFDocument generateDocx(String[] columnNames, List contents) { XWPFDocument document = new XWPFDocument(); // create title XWPFParagraph title = document.createParagraph(); title.setAlignment(ParagraphAlignment.CENTER); XWPFRun titleRun = title.createRun(); titleRun.setText("G SUITE created accounts"); titleRun.setFontSize(18); for (int k = 0; k < contents.size(); k++) { List tableContent = (List) contents.get(k); // create title title = document.createParagraph(); title.setAlignment(ParagraphAlignment.CENTER); titleRun = title.createRun(); titleRun.setText("Table " + (k + 1)); titleRun.setFontSize(18); // create account table XWPFTable table = document.createTable(); // set "justified" alignment table.getCTTbl().addNewTblPr().addNewTblW().setW(BigInteger.valueOf(10000)); //create header for table setHeader(table, columnNames); // if account list is empty if (tableContent == null || tableContent.size() == 0) { // add empty row to the table XWPFTableRow emptyRow = table.createRow(); } else { String[] headerRow = null; // create rows in table for (int i = 0; i < tableContent.size(); i++) { if (i == 0) { headerRow = (String[]) tableContent.get(i); continue; } String[] csvRow = (String[]) tableContent.get(i); XWPFTableRow row = table.createRow(); //create cells in a row for (int j = 0; j < columnNames.length; j++) { int number = getColumnNumber(columnNames[j], headerRow); XWPFTableCell cell = row.getCell(j); if (cell != null) { XWPFRun run = setBodyCell(cell); if (number >= 0 && number < csvRow.length) { run.setText(csvRow[number]); } } } } } } return document; }
From source file:MainPackage.Controllers.OrderController.java
public void Print(Frame frame, Orders order, Account _account) { try {//from w w w. j a v a 2s . co 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); } }