Add to favorites
Advanced Java Tutorial #7 – Working with Excel and Apache POI
In this tutorial I show you how easy it is to write in and read of excel files with the apache poi library.
You can find the source code on github:
If you have any questions, feel free to write a comment 😉
Subscribe now!
Follow on Twitter:
Like on Facebook:
Visit my Website:
source
Thank you for this tutorial. It's a very good introduction to this whole thing. Much appreciated
Thanks a lot
Hi Dennis. Will this library read Excel files with Macros (xlsm format)? Cheers!
Excel is all about shit
hey i woukd like know if you could to show how read one excel file and after this write another excel file usind library poi?
The actual Apache-POI has changed a little bit (Yes, I know that this video is a bit old). getCellType is being replaced by getCellTypeEnum, and Cell Types are included in the CellType class and you can compare it by using the equals method.
This is great thank for this good effort
how to read large excel file
thanks dude! you saved my life
Hi
Is it possible to store the entire row as an array or an object?
hey there, thanks for the video =)
i have a question, do you know how to read superscriptfrom an Excel using Apache PIO?
The excel source have some text cells with superscript and when i read it… the program understand it like plain text, showing a "8^2" like an "82" :/
Tnx for this great tutorials.. Pls how can i get values from one excel file and append it to another existing excel filebased on some primary key Values. Thank you Once again
Good and clear tutorial Dennis.
Thanks for in the Reading from Excel part that you stated that POI distinguishes between String and Numeric format. I would have incorrectly assumed it would have been String by default, so thanks for pointing it out.
+Rocelle Vie Labutap
Hey Rovie,
what kind of file are you trying to open? I've never encountered a problem when opening a java file. Make sure your file has the correct extension (maybe there's a typo).
If this is not the case, try rightclick the file in eclipse->open with->java editor (I was able to reproduce your error when clicken on in place editor here). If the option Java Editor is missing, you have installed the wrong version of eclipse. Make sure to install the Java or Java EE version.
If you try to open an excel file, or some other special file type, open it via the system not within eclipse, because ecilpse is not able to show the content of all kind of files.
If everything fails you could also try to redownload eclipse and create a new workspace as well.
I hope this will help you.
Regards,
Dennis
Hi Mr. Kriechel,
Thank you for this advanced tutorial. So far, the most easy to understand tutorial I can find on Youtube. I can see that you didn't cover the basics, and that's what I'm missing. I'm new in Java, and I can't relate to the problems I encounter. Unfortunately, I can't find a straightforward answer on Google. I encountered problems with regards to OLE Exception. It says,
"cannot create the in-place editor.
Reason:
This is probably because there is no OLE editor registered against the type of file you were trying to open.
Details:
Failed to create Ole Client. result = -2147221164."
I tried this solution:
1. Open Window -> Preferences -> General -> Editors -> File Associations.
2. Check if the file type (*.java) is in the list.
a. If it's in the list, make sure the correct editor is selected as default.
b. If it's not in the list, add it and associate it with the correct editor.
— But it didn't work.
Hope to see your solution regarding this matter as soon as possible. Thank you!
Regards,
Rovie
sir i have repeated the same steps that u hd guided in the videos and my codes are running successfully but my excel file is not created can u plz help me in solving it out plzz