Convert Excel Spreadsheets to CSV and CSV to XLS/XLSX in Java

readme.md

For details, you can visit the full article that explains Conversion of CSV and XLS, XLSX formats in Java.

ConvertCsvToExcel.java

// Convert CSV files to XLS/XLSX format in Java
CsvLoadOptions loadOptions = new CsvLoadOptions();
loadOptions.setSeparator(',');
Converter converter = new Converter("path/comma-sparated-values.csv", loadOptions);

SpreadsheetConvertOptions options = new SpreadsheetConvertOptions();
options.setFormat(SpreadsheetFileType.Xlsx);

converter.convert("path/spreadsheet.xlsx", options);

ConvertExcelToCSV.java

// Convert Excel Spreadsheets to Comma Separated Values CSV format in Java
Converter converter = new Converter("path/spreadsheet.xlsx");

SpreadsheetConvertOptions options = new SpreadsheetConvertOptions();
options.setFormat(SpreadsheetFileType.Csv); // Specify the conversion format

converter.convert("path/convertedfile.csv", options);