Read an Excel XLSX file in Java with Eclipse

It's always interesting to be able to read Microsoft Excel files in an application to read users' documents for example. In that tutorial, you are going to learn how to read an Excel XLSX file in a Java Application with Eclipse.

Note that the logic will be the same to read old Excel XLS format. For that tutorial, we are going to use the great Apache POI API added to the project as a Maven dependency.

Don't hesitate to give it a try and give us your feedback in comments.

[kumarishikha]

it reallt taught me how to read a file from excel and actually i go through many sites and i was stuck but ytvideo solved my issues .

[nandhininandhu]

Hi, when I'm trying to run this program, I got a error like "row and cell cannot be resolved". For this error what should I do to run this program successfully. Please respond

[marshalguo]

Hi! I'm a newbie! So how do you download the apache thing in order for me to use

[musicilya]

how did you import Excel File into Eclipse?

[betcraft]

Hi, how can i get the excel path if someone use my system and he drag his own excel sheet
i want take the path and do the calculation
please help ?

[yashrajsrivastav]

I wanted to read an excel file of 1500 records but it shows only from 792 till last. So i wanted to ask is it there any limit? or is it something else? please Help.

[yasminech]

hey, thank you for your video. do you know a way of reading more than just cells. meaning graphs, charts, pictures ... I used the Apache POI lib but it didn't provide me with what I'm looking for

[seeker]

Is it possible for with jade agents, in eclipse

[tomever]

Would you be able to recognise for example in your example "rob" in what column he belongs to? "First Name, Last name, Email, Date of Birth"

[ahmedabdulrazzaq]

what if i want to copy the first row without iterating cell by cell?

[pravallikachunduru]

Does this code retain excel formatting?

[harshith]

Whenever I compile this program it shows select Java application. I don't know what to select please help

[sarikagarg]

From where to download library to support excel

[saurabhmane]

bro i am getting error at
case Cell.CELL_TYPE_STRING:
it says CELL_TYPE_STRING cannot be resolved or is not a field what should i do? help me

[mr.RAND]

Pls make code font bigger. I have small screen android phone. I dont have android tv or computer or laptop.

[tejasvisabharwal]

I'm using mac os.
I get filenotfoundexception. Even if my .xlsx file is in the same directory. And i give path as:-


FileInputStream fis = new FileInputStream("abc.xlsx");


please respond!

[eng.mohammedmajid]

please share project code full
thank you

[manojgowda]

What are the dependencies you used for the above project?

[malfy]

XSSFWorkbook wb = new
errore fatale
Failed resolution of: Lorg/dom4j/Namespace;