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.
Excel 2003 and Excel 2007 and newer files are different formats -- how badly do you need to serve 2003 files? The newer stuff (.xlsx) is actually a zip of XML files so there are pretty decent open source options for writing them. The old stuff is a custom binary format that wasn't easily supportable so you are typically looking at paid components.
I don't do java so I don't have a specific API to recommend though.