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.

► To learn to generate Excel XLSX Files in Java with Eclipse, you can watch this video :

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


Xem thêm bài viết:

15 thoughts on “Read an Excel XLSX file in Java with Eclipse

  1. XSSFWorkbook wb = new XSSFWorkbook(excelFileToRead);
    errore fatale
    java.lang.NoClassDefFoundError: Failed resolution of: Lorg/dom4j/Namespace;

  2. 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

  3. 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

  4. 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.

  5. 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 bruh……

Leave a Reply

Your email address will not be published. Required fields are marked *