How can I read .xlsx and .xls files in Java?

java xls xlsx xssf
Srinivas picture Srinivas · Jan 17, 2011 · Viewed 14.7k times · Source

hi i want to read xlsx file or xls file what ever it is. can XSSF support xls file ? or do i need to write the separate code for both kind of files ?

Answer

Murukesh picture Murukesh · Jan 17, 2011

Yes, you can use Apache POI to read and write xlsx and xls files.

Related questions

Convert .csv to .xls in Java

Does anyone here know of any quick, clean way to convert csv files to xls or xlsx files in java? I have something to manage csv files already in place and I need the extra compatibility for other programs. Sample …

Read More
JasperReports export to xlsx, not xls

I can't find how to export a file in .xlsx in JasperReports 4.1.1. The class: JRXlsExporter has not a Xlsx equivalent. And i can't find a parameter to set the output format from xls to xlsx.

Read More
Converting JSON to XLS/CSV in Java

Does anyone have any sample Java code to convert a JSON document to XLS/CSV file? I have tried to search on Google but to no avail.

Read More