//create a new workbook Workbook workbook = new Workbook(); //Load template file Template_Score.xlsx from resource InputStream templateFile = this.getResourceStream("xlsx/Template_SetRange.xlsx"); workbook.open(templateFile); /// #region Define custom classes // public class DataInfo { // public int id; // public String name; // public int score; // public String team; // } /// #endregion ///#region Init Data List datasource = new ArrayList(); DataInfo r1 = new DataInfo(); r1.id = 10; r1.name = "Bob"; r1.score = 12; r1.team = "Xi'An"; datasource.add(r1); DataInfo r2 = new DataInfo(); r2.id = 11; r2.name = "Tommy"; r2.score = 6; r2.team = "Xi'An"; datasource.add(r2); DataInfo r3 = new DataInfo(); r3.id = 12; r3.name = "Jaguar"; r3.score = 15; r3.team = "Xi'An"; datasource.add(r3); DataInfo r4 = new DataInfo(); r4.id = 2; r4.name = "Phillip"; r4.score = 9; r4.team = "BeiJing"; datasource.add(r4); DataInfo r5 = new DataInfo(); r5.id = 3; r5.name = "Hunter"; r5.score = 10; r5.team = "BeiJing"; datasource.add(r5); DataInfo r6 = new DataInfo(); r6.id = 4; r6.name = "Hellen"; r6.score = 8; r6.team = "BeiJing"; datasource.add(r6); DataInfo r7 = new DataInfo(); r7.id = 5; r7.name = "Jim"; r7.score = 9; r7.team = "BeiJing"; datasource.add(r7); ///#endregion //Add data source workbook.addDataSource("ds", datasource); //Invoke to process the template workbook.processTemplate(); //save to an excel file workbook.save("SetRange.xlsx");
//create a new workbook var workbook = Workbook() //save to an excel file workbook.save("SetRange.xlsx")