Potential API for Microsoft Excel Export in java web application.
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.
1. Export the data content from JSP to Excel.
2. The API should support Excel 2003,Excel 2007 and future versions.
3. Able to format excel cell content (Font,Right Align,Left Align,Cell color)
4. Able to draw borders.
5. Freezing the header row.
6. 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.