Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Learning Apache POI for Java

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.

like image 862
froadie Avatar asked Feb 12 '10 17:02

froadie


People also ask

What is the use of Apache POI in Java?

Apache POI is a popular API that allows programmers to create, modify, and display MS Office files using Java programs. It is an open source library developed and distributed by Apache Software Foundation to design or modify Microsoft Office files using Java program.

Can Apache POI be compiled used with Java 11?

23. Can Apache POI be compiled/used with Java 11? Including the existing binaries on Java 11 as normal jar-files should work when using recent versions of Apache POI.


1 Answers

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

like image 66
James Avatar answered Sep 22 '22 17:09

James