I would like to know the potential API for the following requirement.
Basically i’m a java guy.so it would be great if you suggest any java based API.
- Export the data content from JSP to Excel.
- The API should support Excel 2003,Excel 2007 and future versions.
- Able to format excel cell content (Font,Right Align,Left Align,Cell color)
- Able to draw borders.
- Freezing the header row.
- Formatting the data in currency format/date format.
Is there any thing handy API much more sophisticated than poi.
I’m looking forward for your valuable inputs to serve my requirement effectively.