//create a new workbook Workbook workbook = new Workbook(); //Load template file from resource InputStream templateFile = this.getResourceStream("xlsx/Template_DepartmentBudget.xlsx"); workbook.open(templateFile); //#region Define custom classes //class Departments //{ // public List dpt; //} //class Department //{ // public string name; // public string mgr; // public double bud; // public List emp; //} //class Employee //{ // public string name; // public double salary; //} //#endregion //#region Init Data Departments departments = new Departments(); departments.dpt = new ArrayList(); //Department 1 Department department1 = new Department(); department1.name = "Marketing"; department1.mgr = "Carl Sommerset"; department1.bud = 354586; department1.emp = new ArrayList(); Employee d1_e1 = new Employee(); d1_e1.name = "JoeKline"; d1_e1.salary = 49402; department1.emp.add(d1_e1); Employee d1_e2 = new Employee(); d1_e2.name = "Lisa Crane"; d1_e2.salary = 81337; department1.emp.add(d1_e2); Employee d1_e3 = new Employee(); d1_e3.name = "John Ryes"; d1_e3.salary = 43503; department1.emp.add(d1_e3); Employee d1_e4 = new Employee(); d1_e4.name = "Elli Davidson"; d1_e4.salary = 67334; department1.emp.add(d1_e4); Employee d1_e5 = new Employee(); d1_e5.name = "Jack Reaze"; d1_e5.salary = 68314; department1.emp.add(d1_e5); Employee d1_e6 = new Employee(); d1_e6.name = "Ben Lam"; d1_e6.salary = 44696; department1.emp.add(d1_e6); departments.dpt.add(department1); //Department 2 Department department2 = new Department(); department2.name = "Sales"; department2.mgr = "Kelly Johnson"; department2.bud = 237721; department2.emp = new ArrayList(); Employee d2_e1 = new Employee(); d2_e1.name = "Liam Elmerson"; d2_e1.salary = 61892; department2.emp.add(d2_e1); Employee d2_e2 = new Employee(); d2_e2.name = "Angela Sanderson"; d2_e2.salary = 38020; department2.emp.add(d2_e2); Employee d2_e3 = new Employee(); d2_e3.name = "Blake Schwarz"; d2_e3.salary = 55701; department2.emp.add(d2_e3); Employee d2_e4 = new Employee(); d2_e4.name = "Linda Barataz"; d2_e4.salary = 82108; department2.emp.add(d2_e4); departments.dpt.add(department2); //Department 3 Department department3 = new Department(); department3.name = "Engineering"; department3.mgr = "Gina Davis"; department3.bud = 624789; department3.emp = new ArrayList(); Employee d3_e1 = new Employee(); d3_e1.name = "Christopher Dean"; d3_e1.salary = 58329; department3.emp.add(d3_e1); Employee d3_e2 = new Employee(); d3_e2.name = "Jack Linner"; d3_e2.salary = 63684; department3.emp.add(d3_e2); Employee d3_e3 = new Employee(); d3_e3.name = "Cathy Raines"; d3_e3.salary = 73147; department3.emp.add(d3_e3); Employee d3_e4 = new Employee(); d3_e4.name = "Scott Ashton"; d3_e4.salary = 77213; department3.emp.add(d3_e4); Employee d3_e5 = new Employee(); d3_e5.name = "Larry Wisell"; d3_e5.salary = 72796; department3.emp.add(d3_e5); Employee d3_e6 = new Employee(); d3_e6.name = "Bart Ingram"; d3_e6.salary = 50009; department3.emp.add(d3_e6); Employee d3_e7 = new Employee(); d3_e7.name = "Wesley Page"; d3_e7.salary = 82378; department3.emp.add(d3_e7); Employee d3_e8 = new Employee(); d3_e8.name = "Alan Keyes"; d3_e8.salary = 67105; department3.emp.add(d3_e8); Employee d3_e9 = new Employee(); d3_e9.name = "Wilson Musk"; d3_e9.salary = 80128; department3.emp.add(d3_e9); departments.dpt.add(department3); //Department 4 Department department4 = new Department(); department4.name = "Customer Service"; department4.mgr = "Kenneth Smith"; department4.bud = 127596; department4.emp = new ArrayList(); Employee d4_e1 = new Employee(); d4_e1.name = "Sherry Meeks"; d4_e1.salary = 38919; department4.emp.add(d4_e1); Employee d4_e2 = new Employee(); d4_e2.name = "Sharon Reeves"; d4_e2.salary = 40963; department4.emp.add(d4_e2); Employee d4_e3 = new Employee(); d4_e3.name = "Max Devillo"; d4_e3.salary = 47714; department4.emp.add(d4_e3); departments.dpt.add(department4); // #endregion //Add data source workbook.addDataSource("ds", departments); //Invoke to process the template workbook.processTemplate(); //save to an excel file workbook.save("DepartmentBudget.xlsx");
//create a new workbook var workbook = Workbook() //Load template file Template_Score.xlsx from resource val templateFile = this.getResourceStream("xlsx/Template_DepartmentBudget.xlsx") workbook.open(templateFile) //#region Define custom classes //class Departments { // var dpt: List? = null //} //class Department { // var name: String? = null // var mgr: String? = null // var bud: Double = 0.toDouble() // var emp: List? = null //} //class Employee { // var name: String? = null // var salary: Double = 0.toDouble() //} //#endregion //#region Init Data val departments = Departments() val dpts = ArrayList() departments.dpt = dpts //Department 1 val department1 = Department() department1.name = "Marketing" department1.mgr = "Carl Sommerset" department1.bud = 354586.0 val d1_emp = ArrayList() department1.emp = d1_emp val d1_e1 = Employee() d1_e1.name = "JoeKline" d1_e1.salary = 49402.0 d1_emp.add(d1_e1) val d1_e2 = Employee() d1_e2.name = "Lisa Crane" d1_e2.salary = 81337.0 d1_emp.add(d1_e2) val d1_e3 = Employee() d1_e3.name = "John Ryes" d1_e3.salary = 43503.0 d1_emp.add(d1_e3) val d1_e4 = Employee() d1_e4.name = "Elli Davidson" d1_e4.salary = 67334.0 d1_emp.add(d1_e4) val d1_e5 = Employee() d1_e5.name = "Jack Reaze" d1_e5.salary = 68314.0 d1_emp.add(d1_e5) val d1_e6 = Employee() d1_e6.name = "Ben Lam" d1_e6.salary = 44696.0 d1_emp.add(d1_e6) dpts.add(department1) //Department 2 val department2 = Department() department2.name = "Sales" department2.mgr = "Kelly Johnson" department2.bud = 237721.0 val d2_emp = ArrayList() department2.emp = d2_emp val d2_e1 = Employee() d2_e1.name = "Liam Elmerson" d2_e1.salary = 61892.0 d2_emp.add(d2_e1) val d2_e2 = Employee() d2_e2.name = "Angela Sanderson" d2_e2.salary = 38020.0 d2_emp.add(d2_e2) val d2_e3 = Employee() d2_e3.name = "Blake Schwarz" d2_e3.salary = 55701.0 d2_emp.add(d2_e3) val d2_e4 = Employee() d2_e4.name = "Linda Barataz" d2_e4.salary = 82108.0 d2_emp.add(d2_e4) dpts.add(department2) //Department 3 val department3 = Department() department3.name = "Engineering" department3.mgr = "Gina Davis" department3.bud = 624789.0 val d3_emp = ArrayList() department3.emp = d3_emp val d3_e1 = Employee() d3_e1.name = "Christopher Dean" d3_e1.salary = 58329.0 d3_emp.add(d3_e1) val d3_e2 = Employee() d3_e2.name = "Jack Linner" d3_e2.salary = 63684.0 d3_emp.add(d3_e2) val d3_e3 = Employee() d3_e3.name = "Cathy Raines" d3_e3.salary = 73147.0 d3_emp.add(d3_e3) val d3_e4 = Employee() d3_e4.name = "Scott Ashton" d3_e4.salary = 77213.0 d3_emp.add(d3_e4) val d3_e5 = Employee() d3_e5.name = "Larry Wisell" d3_e5.salary = 72796.0 d3_emp.add(d3_e5) val d3_e6 = Employee() d3_e6.name = "Bart Ingram" d3_e6.salary = 50009.0 d3_emp.add(d3_e6) val d3_e7 = Employee() d3_e7.name = "Wesley Page" d3_e7.salary = 82378.0 d3_emp.add(d3_e7) val d3_e8 = Employee() d3_e8.name = "Alan Keyes" d3_e8.salary = 67105.0 d3_emp.add(d3_e8) val d3_e9 = Employee() d3_e9.name = "Wilson Musk" d3_e9.salary = 80128.0 d3_emp.add(d3_e9) dpts.add(department3) //Department 4 val department4 = Department() department4.name = "Customer Service" department4.mgr = "Kenneth Smith" department4.bud = 127596.0 val d4_emp = ArrayList() department4.emp = d4_emp val d4_e1 = Employee() d4_e1.name = "Sherry Meeks" d4_e1.salary = 38919.0 d4_emp.add(d4_e1) val d4_e2 = Employee() d4_e2.name = "Sharon Reeves" d4_e2.salary = 40963.0 d4_emp.add(d4_e2) val d4_e3 = Employee() d4_e3.name = "Max Devillo" d4_e3.salary = 47714.0 d4_emp.add(d4_e3) dpts.add(department4) // #endregion //Add data source workbook.addDataSource("ds", departments) //Invoke to process the template workbook.processTemplate() //save to an excel file workbook.save("DepartmentBudget.xlsx")