//create a new workbook Workbook workbook = new Workbook(); //Load template file from resource InputStream templateFile = this.getResourceStream("xlsx/Template_PurchaseOrder.xlsx"); workbook.open(templateFile); /// #region Define custom classes //public class PurchaseOrderInfo { // public int s_no; // public String itemnumber; // public String itemdescription; // public int quantity; // public String um; // public int price; //} //public class PurchaseOrderBasicInfo { // public String iD; // public Date orderDate = new Date(0); // public String creditTerms; // public String pONumber; // public String ref; // public String deliverToCompany; // public String deliverToAddress; // public String postalCode; // public String country; // //} /// #endregion ///#region Init Data List purchaseOrderInfoList = new ArrayList(); PurchaseOrderInfo purchaseOrderInfo1 = new PurchaseOrderInfo(); purchaseOrderInfo1.s_no = 1; purchaseOrderInfo1.itemnumber = "P1001"; purchaseOrderInfo1.itemdescription = "Pencils HB"; purchaseOrderInfo1.quantity = 5; purchaseOrderInfo1.um = "dozen"; purchaseOrderInfo1.price = 10; purchaseOrderInfoList.add(purchaseOrderInfo1); PurchaseOrderInfo purchaseOrderInfo2 = new PurchaseOrderInfo(); purchaseOrderInfo2.s_no = 2; purchaseOrderInfo2.itemnumber = "P1003"; purchaseOrderInfo2.itemdescription = "Pencils 2B"; purchaseOrderInfo2.quantity = 4; purchaseOrderInfo2.um = "dozen"; purchaseOrderInfo2.price = 10; purchaseOrderInfoList.add(purchaseOrderInfo2); PurchaseOrderInfo purchaseOrderInfo3 = new PurchaseOrderInfo(); purchaseOrderInfo3.s_no = 3; purchaseOrderInfo3.itemnumber = "P1003"; purchaseOrderInfo3.itemdescription = "Paper A4 - Photo Copier"; purchaseOrderInfo3.quantity = 10; purchaseOrderInfo3.um = "ream"; purchaseOrderInfo3.price = 3; purchaseOrderInfoList.add(purchaseOrderInfo3); PurchaseOrderInfo purchaseOrderInfo4 = new PurchaseOrderInfo(); purchaseOrderInfo4.s_no = 4; purchaseOrderInfo4.itemnumber = "P1234"; purchaseOrderInfo4.itemdescription = "Pens - Ball point"; purchaseOrderInfo4.quantity = 15; purchaseOrderInfo4.um = "boxes"; purchaseOrderInfo4.price = 2; purchaseOrderInfoList.add(purchaseOrderInfo4); PurchaseOrderInfo purchaseOrderInfo5 = new PurchaseOrderInfo(); purchaseOrderInfo5.s_no = 5; purchaseOrderInfo5.itemnumber = "P3221"; purchaseOrderInfo5.itemdescription = "Highligter"; purchaseOrderInfo5.quantity = 8; purchaseOrderInfo5.um = "sets"; purchaseOrderInfo5.price = 10; purchaseOrderInfoList.add(purchaseOrderInfo5); PurchaseOrderBasicInfo orderbasicInfo = new PurchaseOrderBasicInfo(); orderbasicInfo.iD = "US120499"; orderbasicInfo.orderDate = new GregorianCalendar(2019, 7, 7).getTime(); orderbasicInfo.creditTerms = "30"; orderbasicInfo.pONumber = "PO1011"; orderbasicInfo.ref = "QT1231"; orderbasicInfo.deliverToCompany = "Sanfort Pvt. Ltd."; orderbasicInfo.deliverToAddress = "1322, High Street, Geln Waverlay"; orderbasicInfo.postalCode = "Victoria 3456"; orderbasicInfo.country = "Australia"; ///#endregion //Add data source workbook.addDataSource("po", purchaseOrderInfoList); workbook.addDataSource("tax", 5); workbook.addDataSource("ds", orderbasicInfo); //Invoke to process the template workbook.processTemplate(); //save to an excel file workbook.save("PurchaseOrder.xlsx");
//create a new workbook var workbook = Workbook() //Load template file Template_Score.xlsx from resource val templateFile = this.getResourceStream("xlsx/Template_PurchaseOrder.xlsx") workbook.open(templateFile) /// #region Define custom classes //class PurchaseOrderInfo { // var s_no: Int = 0 // var itemnumber: String? = null // var itemdescription: String? = null // var quantity: Int = 0 // var um: String? = null // var price: Int = 0 //} //class PurchaseOrderBasicInfo { // var iD: String? = null // var orderDate: Date? = Date(0) // var creditTerms: String? = null // var pONumber: String? = null // var ref: String? = null // var deliverToCompany: String? = null // var deliverToAddress: String? = null // var postalCode: String? = null // var country: String? = null //} /// #endregion ///#region Init Data val purchaseOrderInfoList = ArrayList() val purchaseOrderInfo1 = PurchaseOrderInfo() purchaseOrderInfo1.s_no = 1 purchaseOrderInfo1.itemnumber = "P1001" purchaseOrderInfo1.itemdescription = "Pencils HB" purchaseOrderInfo1.quantity = 5 purchaseOrderInfo1.um = "dozen" purchaseOrderInfo1.price = 10 purchaseOrderInfoList.add(purchaseOrderInfo1) val purchaseOrderInfo2 = PurchaseOrderInfo() purchaseOrderInfo2.s_no = 2 purchaseOrderInfo2.itemnumber = "P1003" purchaseOrderInfo2.itemdescription = "Pencils 2B" purchaseOrderInfo2.quantity = 4 purchaseOrderInfo2.um = "dozen" purchaseOrderInfo2.price = 10 purchaseOrderInfoList.add(purchaseOrderInfo2) val purchaseOrderInfo3 = PurchaseOrderInfo() purchaseOrderInfo3.s_no = 3 purchaseOrderInfo3.itemnumber = "P1003" purchaseOrderInfo3.itemdescription = "Paper A4 - Photo Copier" purchaseOrderInfo3.quantity = 10 purchaseOrderInfo3.um = "ream" purchaseOrderInfo3.price = 3 purchaseOrderInfoList.add(purchaseOrderInfo3) val purchaseOrderInfo4 = PurchaseOrderInfo() purchaseOrderInfo4.s_no = 4 purchaseOrderInfo4.itemnumber = "P1234" purchaseOrderInfo4.itemdescription = "Pens - Ball point" purchaseOrderInfo4.quantity = 15 purchaseOrderInfo4.um = "boxes" purchaseOrderInfo4.price = 2 purchaseOrderInfoList.add(purchaseOrderInfo4) val purchaseOrderInfo5 = PurchaseOrderInfo() purchaseOrderInfo5.s_no = 5 purchaseOrderInfo5.itemnumber = "P3221" purchaseOrderInfo5.itemdescription = "Highligter" purchaseOrderInfo5.quantity = 8 purchaseOrderInfo5.um = "sets" purchaseOrderInfo5.price = 10 purchaseOrderInfoList.add(purchaseOrderInfo5) val orderbasicInfo = PurchaseOrderBasicInfo() orderbasicInfo.iD = "US120499" orderbasicInfo.orderDate = GregorianCalendar(2019, 7, 7).getTime() orderbasicInfo.creditTerms = "30" orderbasicInfo.pONumber = "PO1011" orderbasicInfo.ref = "QT1231" orderbasicInfo.deliverToCompany = "Sanfort Pvt. Ltd." orderbasicInfo.deliverToAddress = "1322, High Street, Geln Waverlay" orderbasicInfo.postalCode = "Victoria 3456" orderbasicInfo.country = "Australia" ///#endregion //Add data source workbook.addDataSource("po", purchaseOrderInfoList) workbook.addDataSource("tax", 5) workbook.addDataSource("ds", orderbasicInfo) //Invoke to process the template workbook.processTemplate() //save to an excel file workbook.save("PurchaseOrder.xlsx")