Learning Apache POI for Java

Question

I'm trying to learn Apache POI for Java quickly (for manipulating Excel). I've been googling for tutorials, but so far all I've found is short, 2-paragraph explanations followed by a code sample. I wanted to find something a bit more comprehensive, that is concise but walks through it in a structured, complete, and understandable way. Anyone know of any good tutorials? Does Apache POI have any decent documentation...? I couldn't seem to find any on their site.

score 14 · Accepted Answer · edited Dec 05 '12 at 22:53

14

I found the documentation to be mostly lacking myself. I found the mailing group was my best resource for getting answers to my hard questions: http://mail-archives.apache.org/mod_mbox/poi-user/. For learning the basics I just followed the examples on the online documentation and used the trial and error approach with a simple console app.

Online documentation links:

http://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFSheet.html

http://poi.apache.org/spreadsheet/quick-guide.html

edited Dec 05 '12 at 22:53

RustyTheBoyRobot

5,891
4
36
55

answered Feb 12 '10 at 17:43

James

12,636
12
67
104

Where is the online documentation? Can you provide a link? – froadie Feb 12 '10 at 17:43
The quick guide looks perfect... Thanks! – froadie Feb 12 '10 at 17:57
Nice quick guide! Thanks! – Ramiro Arizpe Giacomelli Jan 30 '16 at 18:03

score 2 · Answer 2 · answered Dec 17 '12 at 03:01

2

There is EXCELENT tutorial on YouTube. Consists of 10 videos, I think. Just type in "Java programming tutorial - excel documents"

answered Dec 17 '12 at 03:01

score 2 · Answer 3 · answered Dec 13 '11 at 09:35

I'm a bit late to this party but another resource that hasn't been mentioned so far is the example code within POI's own source tree. I'm working with the Word functionality (HWPF) and found some nicely functioning code for using POI to do conversions to text, FO, and HTML. Following the source (which is unfortunately also not very commented) gave me a lot of useful hints.

score 0 · Answer 4 · edited Feb 12 '10 at 18:24

0

I prefer Andy Khan's JExcel to POI. It's a better API, and the docs are very good.

edited Feb 12 '10 at 18:24

tangens

39,095
19
120
139

answered Feb 12 '10 at 17:37

duffymo

305,152
44
369
561

I don't have a choice though - the place I work uses POI and I'll probably be looking through some of their code soon. They suggested I research it, and I'd like to go through a basic tutorial before getting started. – froadie Feb 12 '10 at 17:39
1

I gotta agree with tangens comment. Its too bad JExcel can't do XSLX, which is what's got me going to POI. – Bob Kuhar Oct 19 '11 at 21:56

Learning Apache POI for Java

4 Answers4

Linked