Example #1
0
 private static void executeGridObjectListDemo(List<Employee> employees) throws IOException {
   try (InputStream is = GridCommandDemo.class.getResourceAsStream("grid_template.xls")) {
     try (OutputStream os = new FileOutputStream("target/grid_output2.xls")) {
       Context context = new Context();
       context.putVar("headers", Arrays.asList("Name", "Birthday", "Payment"));
       context.putVar("data", employees);
       JxlsHelper.getInstance()
           .processGridTemplateAtCell(is, os, context, "name,birthDate,payment", "Sheet2!A1");
     }
   }
 }
Example #2
0
 private static void executeGridMatrixDemo(List<Employee> employees) throws IOException {
   List<List<Object>> data = createGridData(employees);
   try (InputStream is = GridCommandDemo.class.getResourceAsStream("grid_template.xls")) {
     try (OutputStream os = new FileOutputStream("target/grid_output1.xls")) {
       Context context = new Context();
       context.putVar("headers", Arrays.asList("Name", "Birthday", "Payment"));
       context.putVar("data", data);
       JxlsHelper.getInstance().processTemplate(is, os, context);
     }
   }
 }