OSM is a project aimed to export and import data from object to sheet and vice-versa in a standardized format. It is currently under development.
To play with OSM, clone the repository and build with
mvn clean install
Now from test packages, find our SheetManagerFactoryTest
and run the test to understanding what is happening.
Scan SheetEntity classes
SheetManagerFactory sheetManagerFactory = new SheetManagerFactory("org.dataexchanger.osm.example");
Create Employee and Address objects. Different employees can have same address.
Address address1 = new Address();
address1.setId(3);
address1.setHouse("Forest Lodge");
address1.setStreet("S.S. Academy Road");
Address address2 = new Address();
address2.setId(4);
address2.setHouse("Avijan 9/2");
address2.setStreet("S.S. Academy Road");
List<Employee> employees = new ArrayList<>();
Employee e1 = new Employee();
e1.setId(1L);
e1.setName("Mainul");
e1.setAge(25);
e1.setAddress(address1);
employees.add(e1);
Employee e2 = new Employee();
e2.setId(2L);
e2.setName("Hasan");
e2.setAge(26);
e2.setAddress(address2);
employees.add(e2);
Employee e3 = new Employee();
e3.setId(3L);
e3.setName("Siam");
e3.setAge(16);
e3.setAddress(address1);
employees.add(e3);
for (Employee e : employees) {
sheetManagerFactory.prepareWorkbook(e);
}
sheetManagerFactory.writeWorkbookAsFile();
byte[] bytes = sheetManagerFactory.getByteContent();