Rain

Object to excel spreed sheet

Object to Excel Java library. Based on apache POI library and the power of java reflexion.

JAVA version

mvn repo

<dependency>
  <groupId>net.xbaker</groupId>
  <artifactId>rain</artifactId>
  <version>2.0.0</version>
</dependency>

Create spreadsheet

let's give the User.java class

 public class User {
 
     @RainRow
     private String firstName;
     @RainRow(include = false)
     private String secondName;
     @RainRow
     private String address;
     @RainRow
     private String email;
     @RainRow(name = "PHONE")
     private String phone;
     @RainRow(child = {"label"})
     private City city;
     
     // getters and setters
 
 }

City.java class

 public class City {
     private String label;
     private String description;
     // getters && setters
 }

Test example

 public class MySpreadSheetRender {
     public MySpreadSheetRender() throws IOException {
          List<User> data = this.data();
           RainSheet<User> rainSheet = new RainSheetBuilder<User>()
                         .target(User.class)
                                         .multipleRowSeparator(MultipleRowSeparator.SPACE)
                                         .name("test")
                                         .insertChildRowName(true)
                                         .insertDateInName(false)
                                         .rowContent(data)
                                         .build();
         
           WorkBookGenerator<User> workBookGenerator = new WorkBookGenerator<>(rainSheet);
           Workbook workbook = workBookGenerator.render();
           FileOutputStream out = new FileOutputStream("example.xls");
                   workbook.write(out);
                   out.close();
     }
 }

My test result