I am currently working on a Java Project that automates Report Generation using POI. Given necessary parameters, it would extract data from database and construct an appropriate Excel table.
Sounds pretty straightforward, isn't it? Well, it certainly is not. A good table would require proper coloring of Cells, setting required Formulations, appropriate Merging of cells and even setting proper column width and many more.