SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2008
    0 Post(s)
    0 Thread(s)

    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 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.


  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Washington, DC
    4 Post(s)
    0 Thread(s)
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts