Excel to CSV Java library

Question

I am looking for a Java library (preferably in Maven Central) that can read XLS and XLSX and save the sheet to CSV.

I am looking for something higher level than poi and jxl as neither of these have direct export to CSV without writing lots of code.

I am also aware of the poi xls2csv sample but I am looking for a reusable library and not a class to paste in my project.

Answer 1

Spire.XLS for Java library is capable of reading XLS/XLSX files and saving them as CSV. You just need to write 4 lines of code.

Maven dependencies:

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>5.3.3</version>
    </dependency>
</dependencies>

Save a worksheet of an XLS/XLSX file as CSV:

import com.spire.xls.*;
import java.nio.charset.Charset;

public class ExcelToCSV {
    public static void main(String[] args) {
        //Create a workbook
        Workbook workbook = new Workbook();    
        //Load an xlsx or xls file
        workbook.loadFromFile("C:\\Users\\Test1\\Desktop\\sample.xlsx");    
        //Get the first sheet
        Worksheet sheet = workbook.getWorksheets().get(0);    
        //Save the sheet as CSV
        sheet.saveToFile("output/ToCSV_out.csv", ",", Charset.forName("UTF-8"));
    }
}

For more information, you can read the documentation here: Java: Convert Excel to CSV and Vice Versa

Answer 2

Searching GitHub I found Coreoz/Windmill:

Windmill is a library to parse or write Excel and CSV files through a fluent API that takes advantage of Java 8 Stream and Lambda features.

Windmill targets the writing/parsing of List/Collection data. It will especially stand out for use cases like exporting/importing a result set from/to a database.

It is based on the projects Apache POI and OpenCSV to manipulate Excel and CSV files.

Plus it's available in Maven Central:

<dependency>
  <groupId>com.coreoz</groupId>
  <artifactId>windmill</artifactId>
  <version>1.2.0</version>
</dependency>