For basic information see: ["POIHomePage"]
- Development Topics:
POITwoDotOh - discussion on the current developement release of POI
["POIThreeDotOh"] - discussion on the next version of POI
- FAQ
- Q: Charts..... When? When? When?
- A: When you and enough dedicated people work to drive them forward. (hint hint)
- Q: Easy way to set a cell width. Does it exist?
A: Yes, you can easily set column widths, but I'm assuming this means to calculate the correct width and stuff: No. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=6842 is needed.
- Q: Can you use POI to build Word docs?
A: Not yet, we need help with HDF to make this happen! (http://jakarta.apache.org/poi/hdf)
- Q: My code that works on Windows isn't working on Solaris, etc. I'm using JSP...
- A: Your problems are one of two issues:
1. Outputting the binary file from the JSP page is getting crud in it (like spaces, linefeeds, etc).
- * Solution: servlet
- * Outputting binary files from JSPs is a BAD BAD BAD idea.
2. You're not using a recent nightly build and hence the encoding problem is here. Meaning you need
- * Solution: specify the file.encoding to be iso-8859-1 via java -Dfile.encoding=ISO-8859-1
- * Solution: use a recent nightly build
Q: What libaries does POI make use of and is its use of them in accordance with their Licensing?
A: Of course! ["JakartaPOIAudits"]
- Q: Can I stream an XLS file one line at a time?
- A: No, the file is structurally such that this wouldn't work.
A: The file has pointers to downstream objects in the header. This is true in several places, the encapsulating OL2CDF file has pointers to blocks in the header, and the encapsulated "Workbook stream" has pointers to various objects in the upstream records. Eventually we'd like to memory map and create the file on disk (optionally) then stream from the disk file, but this will tie us to 1.4.x.
- Q: What platforms has POI been tested on and how does it run?
- Other