The POI Team is proud to announce the immediate availability of the Jakarta POI 2.0-FINAL release.
The POI project consists of APIs for manipulating various file formats based upon Microsoft's OLE 2 Compound Document format using pure Java.
Support for reading and writing Microsoft Excel files and property information is mature and work continues on reading and writing the MS Word format.
Read the POI 2.0 Final Announcement
Visit the POI website
-
Jakarta Releases POI 2.0 Final (29 messages)
- Posted by: Dion Almaer
- Posted on: January 28 2004 10:07 EST
Threaded Messages (29)
- Thanks a lot! by david smith on January 28 2004 10:12 EST
- Lucene and POI? by Paul Danckaert on January 29 2004 14:56 EST
-
Lucene and POI? by mirco tamburini on January 30 2004 03:56 EST
- Lucene and POI? by Paul Danckaert on January 30 2004 01:49 EST
-
Lucene and POI? by mirco tamburini on January 30 2004 03:56 EST
- placing graphics in cells by Michael Billesbach on January 29 2004 17:34 EST
- Yes by Andrew Oliver on January 30 2004 08:55 EST
- what's the meaning of rc in the sentence "Version 2.0-RC2 " by ss wen on January 30 2004 04:15 EST
- That was the release candidate by Andrew Oliver on January 30 2004 08:56 EST
- release candidate by brtan dfsafad on January 30 2004 10:05 EST
- How to parse the complex Word Documents to text by Sudhakar Koundinya on May 10 2004 03:01 EDT
- Process thousands records using JExcel/POI API "Out of Memory" by Ejaz Butt on May 05 2008 08:13 EDT
-
Process thousands records using JExcel/POI API "Out of Memory by narayana chandrapati on June 11 2008 11:59 EDT
- OutOfMemory by Srinivas Murthy on October 06 2008 04:35 EDT
-
Process thousands records using JExcel/POI API "Out of Memory by narayana chandrapati on June 11 2008 11:59 EDT
- To Extract data from a chart in excel by Anitha Prabhu on November 11 2009 05:24 EST
- Lucene and POI? by Paul Danckaert on January 29 2004 14:56 EST
- Excellent Job by Godfrey Nang'oma on January 28 2004 11:23 EST
- Jakarta Releases POI 2.0 Final by John Davies on January 28 2004 11:57 EST
- Any documentation/tutorial by shawn spencer on January 28 2004 14:44 EST
- Any documentation/tutorial by Godfrey Nang'oma on January 28 2004 14:57 EST
- Jakarta Releases POI 2.0 Final by Dmitry Namiot on January 28 2004 15:28 EST
- Jakarta Releases POI 2.0 Final by Glen Stampoultzis on January 28 2004 20:03 EST
- Great Tool by Ra Sen on January 29 2004 03:51 EST
- Great Tool by raghu tss rao on January 29 2004 09:46 EST
- Wow by Andrew Oliver on January 30 2004 08:58 EST
- Great Tool by raghu tss rao on January 29 2004 09:46 EST
- jExcelAPI vs HSSF by Nimbus Chen on January 30 2004 09:56 EST
- jExcelAPI vs HSSF Charts and Macros by Michael Zalewski on January 30 2004 17:07 EST
-
Charts with HSSF by r r on May 12 2004 04:50 EDT
-
Superscripts with HSSF by Samuel Maina on January 08 2006 08:16 EST
- Superscripts with HSSF by Marko Francekovic on April 15 2010 04:18 EDT
-
Superscripts with HSSF by Samuel Maina on January 08 2006 08:16 EST
-
Charts with HSSF by r r on May 12 2004 04:50 EDT
- jExcelAPI vs HSSF Charts and Macros by Michael Zalewski on January 30 2004 17:07 EST
- HSSF chart example by prinsinn prins on March 29 2004 10:26 EST
-
Thanks a lot![ Go to top ]
- Posted by: david smith
- Posted on: January 28 2004 10:12 EST
- in response to Dion Almaer
Our project uses POI APIs for Excel Spreadsheets manipulation and it works greas in production.
Thank you, POI Team!!! -
Lucene and POI?[ Go to top ]
- Posted by: Paul Danckaert
- Posted on: January 29 2004 14:56 EST
- in response to david smith
Out of curiosity and on a related note, is there any integration between Lucene and POI to allow for better indexing and searching of MS documents? Does anybody know of work in this area?
thanks! -
Lucene and POI?[ Go to top ]
- Posted by: mirco tamburini
- Posted on: January 30 2004 03:56 EST
- in response to Paul Danckaert
I developed a little plug-in for Liferay Enterprise Portal (open-source) that integrate Lucene and POI for Excel and Word Document. -
Lucene and POI?[ Go to top ]
- Posted by: Paul Danckaert
- Posted on: January 30 2004 13:49 EST
- in response to mirco tamburini
Is that bundled with Liferay, or maintained on some other location? -
placing graphics in cells[ Go to top ]
- Posted by: Michael Billesbach
- Posted on: January 29 2004 17:34 EST
- in response to david smith
Thanks for POI. We use HSSF in one of apps. I'm hoping that 2.0 solves some memory problems that we've experienced in 1.5.
Is there any plan to provide a way to place graphics (jpeg, bitmap or ??) in a cell? -
Yes[ Go to top ]
- Posted by: Andrew Oliver
- Posted on: January 30 2004 08:55 EST
- in response to Michael Billesbach
Very shortly, any day now it will be committed. -
what's the meaning of rc in the sentence "Version 2.0-RC2 "[ Go to top ]
- Posted by: ss wen
- Posted on: January 30 2004 04:15 EST
- in response to david smith
thank you -
That was the release candidate[ Go to top ]
- Posted by: Andrew Oliver
- Posted on: January 30 2004 08:56 EST
- in response to ss wen
That was the release candidate however the final has already been released -
release candidate[ Go to top ]
- Posted by: brtan dfsafad
- Posted on: January 30 2004 10:05 EST
- in response to ss wen
It means it is the second version that they have been ready to say
can be used by the public with a very very low likelyhood of show
stopper bugs or security problems. -
How to parse the complex Word Documents to text[ Go to top ]
- Posted by: Sudhakar Koundinya
- Posted on: May 10 2004 03:01 EDT
- in response to david smith
Hi All,
I Just wanted to know what are the problems the team is facing for parsing the Fast-Saved WordDocuments to Text
Thanks,
Sudhakar -
Process thousands records using JExcel/POI API "Out of Memory"[ Go to top ]
- Posted by: Ejaz Butt
- Posted on: May 05 2008 08:13 EDT
- in response to david smith
Hello, I am currently using POI and JExcel API for processing excel files with almost than 2K records with 100 columns each. One process is using POI and another is using JExcel API. With 2K records every thing were fine and things were running smooth. But now the requirement has changed and we require an enhancement in our processes to work with almost 50K records. What i have found, both APIs (POI & JExcel) get failed to process even 10K records and give "out of memory error". I have checked it using JProfiler, when we load file of 8K using POI or JExcel, heap size jumped up to 70 MB and ultimately give Out of Memory Error and process terminate. I think, both POI and JExcel load complete file in memory which causes Out of memory error. Can any body give me suggestions how to over come this issue??? Is there any option in JExcel or POI to load file in chunks in memory?? How can i process 50K records file using any of the API??? Waiting for your valuable suggestions "Ejaz" -
Process thousands records using JExcel/POI API "Out of Memory[ Go to top ]
- Posted by: narayana chandrapati
- Posted on: June 11 2008 11:59 EDT
- in response to Ejaz Butt
you can increase the Java memory Options java -server -Xmn100M -Xms500M -Xmx500M ~NC -
OutOfMemory[ Go to top ]
- Posted by: Srinivas Murthy
- Posted on: October 06 2008 16:35 EDT
- in response to narayana chandrapati
You cannot possibly indefinitely increase memory size with JVM options?! Answer is in being able to update individual worksheets, without having to create them and append every possible row you have in your dataset. We currently are faced with having to export millions of rows, and there is no way it can be done, with current jExcel/POI architecture, hence we resort to CSV. -
To Extract data from a chart in excel[ Go to top ]
- Posted by: Anitha Prabhu
- Posted on: November 11 2009 05:24 EST
- in response to david smith
Hi, I need to extract the data from multiple chart in excel. Please provide some sample code for the same -
Excellent Job[ Go to top ]
- Posted by: Godfrey Nang'oma
- Posted on: January 28 2004 11:23 EST
- in response to Dion Almaer
I have been using POI 1.5 for sometime. It is a great API for creating/reading MS Excel documents. It adds a lot of values especially when you have appliaction running on Unix box. No more limitations, with POI API, you can create or read Excel docs on UNIX environment; :-)
There used to be some limitations on the size of Excel document that POI can read. I hope this is not an issue with version 2.0. I will definitely try out.
Thanks -
Jakarta Releases POI 2.0 Final[ Go to top ]
- Posted by: John Davies
- Posted on: January 28 2004 11:57 EST
- in response to Dion Almaer
I just want to add my support for POI, I used it recently in a bank for stripping text out of a Word document for matching and reconcilition. This is definately going to be one of the most usefull Apache packages for those of us forced to use propriatory document formats from Microsoft.
-John- -
Any documentation/tutorial[ Go to top ]
- Posted by: shawn spencer
- Posted on: January 28 2004 14:44 EST
- in response to Dion Almaer
Apache groups is awesome and thanks for giving the best products all the time.
I was wondering if anyone knows the documentation and a small tutorial for me to start using it, Going thru the java docs will be a hell of a task i guess. -
Any documentation/tutorial[ Go to top ]
- Posted by: Godfrey Nang'oma
- Posted on: January 28 2004 14:57 EST
- in response to shawn spencer
There is a user guide that will help you to start. Below is the URL:
http://jakarta.apache.org/poi/hssf/quick-guide.html
> Apache groups is awesome and thanks for giving the best products all the time.
> I was wondering if anyone knows the documentation and a small tutorial for me to start using it, Going thru the java docs will be a hell of a task i guess. -
Jakarta Releases POI 2.0 Final[ Go to top ]
- Posted by: Dmitry Namiot
- Posted on: January 28 2004 15:28 EST
- in response to Dion Almaer
Excel related part of POI works fine. And what is a current
status for MS Word? What can we do right now with MS Word
and what are the nearest plans?
Dmitry Namiot
http://www.servletsuite.com -
Jakarta Releases POI 2.0 Final[ Go to top ]
- Posted by: Glen Stampoultzis
- Posted on: January 28 2004 20:03 EST
- in response to Dmitry Namiot
Ryan's still busy working on it. It's a big job and I'm sure he could use some help or if someone want's to sponser the work it could get done a lot faster.
Regards,
Glen Stampoultzis -
Great Tool[ Go to top ]
- Posted by: Ra Sen
- Posted on: January 29 2004 03:51 EST
- in response to Dion Almaer
I have been using POI for around 1.5 years for inserting values from excel to
oracle db and my Client is greatly impressed with the output.
Great work POI team,You guys are really rocking... -
Great Tool[ Go to top ]
- Posted by: raghu tss rao
- Posted on: January 29 2004 09:46 EST
- in response to Ra Sen
We use POI in our project at the census
http://factfinder.census.gov/home/saff/main.html?_lang=en to enable the public to download census data. We have millions of download for excel data and POI has worked great. Thanks POI team for a great product. -
Wow[ Go to top ]
- Posted by: Andrew Oliver
- Posted on: January 30 2004 08:58 EST
- in response to raghu tss rao
The census! I'd really love if you wrote a case study for our website! (http://jakarta.apache.org/poi/casestudies.html)
Aside from the census, I know POI is used in some of the worlds largest (and smallest) banks, investment firms, etc. -
jExcelAPI vs HSSF[ Go to top ]
- Posted by: Nimbus Chen
- Posted on: January 30 2004 09:56 EST
- in response to Dion Almaer
In my project, HSSF has his Macros limition while jExcelAPI solves it.And also it has some advantage in Excel chart. So what's the plan about POI's HSSF?
BTW:
you can access jExcelAPI via: http://www.andykhan.com/jexcelapi/index.html -
jExcelAPI vs HSSF Charts and Macros[ Go to top ]
- Posted by: Michael Zalewski
- Posted on: January 30 2004 17:07 EST
- in response to Nimbus Chen
Both jExcelAPI and HSSF handle macros and charts the same way.
If you have an original with charts or macros, the charts and macros get copied without any modification. You have to create the macro or chart with an actual copy of Excel, but then you can use either jExcel or HSSF to populate the data.
I wonder what 'his Macros limitation' is? and how is jExcelAPI support for charts any better than HSSF? -
Charts with HSSF[ Go to top ]
- Posted by: r r
- Posted on: May 12 2004 16:50 EDT
- in response to Michael Zalewski
Michael,
I was wondering if you have worked with spreadsheets which have charts in them?
I am simply trying to read a spreadsheet with chart and write to another file. The new file ends up being in invalid format (Excel cannot read it). The copy routine works fine if the spreadsheet does not contain charts.
Any info will be helpful
Thanks
raghu
rramakri at db dot com -
Superscripts with HSSF[ Go to top ]
- Posted by: Samuel Maina
- Posted on: January 08 2006 20:16 EST
- in response to r r
Does anyone know if its possible to superscript/subscript a part of the cell with HSSF?
Input will be highly appreciated -
Superscripts with HSSF[ Go to top ]
- Posted by: Marko Francekovic
- Posted on: April 15 2010 04:18 EDT
- in response to Samuel Maina
Please I am also in big need of using subscript / superscript in CellValue.
I am building report export with hssf and there are lots of subscripts but i just can't figure it out how to write them in setCellValue();
Please assist me.
Thanks in advance -
HSSF chart example[ Go to top ]
- Posted by: prinsinn prins
- Posted on: March 29 2004 10:26 EST
- in response to Dion Almaer
Hi
I am trying to change the data for a chart that i have created
in excel and then change the source data using the HSSF in POI, does anybody have an example to do this?
kind regards
Prinsinn