I need to read an Excel 2007 XLSX file in a Java application. Does anyone know of a good API to accomplish this task?
How to read Excel (XLS) file in Java. Reading XLS file is no different than reading an XLSX format file, all you need to do is to use correct workbook implementation for XLS format e.g. instead of using XSSFWorkbook and XSSFSheet , you need to use HSSFWorkbook and HSSFSheet classes from Apache POI library.
Apache POI 3.5 have added support to all the OOXML (docx, xlsx, etc.)
See the XSSF sub project
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With