nsp — 2012-07-19T05:26:24-04:00 — #1
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.
wwb_99 — 2012-07-20T07:38:16-04:00 — #2
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.