Using POI for excel works in Java

Question

I want to read/write excel files in Java (netbeans). There are a lot of information on how to do that with APACHE POI and I know that. My question is that, where should I put poi jar files? should I extract it in my local project?

Additionally, should I download the binary or src of the poi?

Possible duplicate of [How do you use a Java Library?](http://stackoverflow.com/questions/825521/how-do-you-use-a-java-library) — khelwood, Apr 20 '17 at 10:49

Tuan Hoang · Accepted Answer · 2022-03-25T02:33:51.057

2

I agree that Maven is the perfect choice, but if you don't have time to study about it, just try to add the jar file to your project

edited Mar 25 '22 at 02:33

answered Apr 20 '17 at 10:52

Tuan Hoang

406
1
8
11

OK. I downloaded poi binary package. It contains poi-3.16.jar (~2MB) and many other jar files. Is that enough to add that or I have to add all library files? – mahmood Apr 20 '17 at 10:56
I believe that you just need one. – Tuan Hoang Apr 20 '17 at 11:00
Although I added the jar file, but it doesn't work. I will ask in another post – mahmood Apr 20 '17 at 11:19
I guess because the reference between the project and the library has not been made. – Tuan Hoang Apr 21 '17 at 02:13

Gyunesh Shefkedov · Answer 2 · 2017-04-20T10:52:56.730

0

If you are using maven you only have to add this dependency to your pom.xml file

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.15</version>
</dependency>

With this library you can process .xls and .xlsx files. If you are not using maven you should download the jar file and add it to your classpath

edited Apr 20 '17 at 10:52

answered Apr 20 '17 at 10:46

Gyunesh Shefkedov

161
4
18

No I don't use Maven. I am developing just regular java applications. Don't know what is Maven! Please explain that – mahmood Apr 20 '17 at 10:47
1

This can be usefull to understand maven http://stackoverflow.com/a/13335439/4620483 – Gyunesh Shefkedov Apr 20 '17 at 10:51
no, it is not, but it is a good practice to use such tool and it will make your life much easier – Gyunesh Shefkedov Apr 20 '17 at 10:53

Using POI for excel works in Java

2 Answers2