This article focuses on how to convert Excel to CSV in Java and covers basic document transformation. We will also provide a step-by-step guide for converting documents and provide sample Java code to convert Excel to CSV. Furthermore, the example code can be improved by using the SpreadsheetConvertOptions class to set a variety of properties for the resulting CSV file.
Steps to Convert Excel to CSV in Java
- Install GroupDocs.Conversion for Java from the Maven repository into Java application
- Create an object of the Converter class and load the input Excel file for conversion
- Initialize SpreadsheetConvertOptions class for setting parameters for the converted document
- Specify the file name of the output CSV file along with the instance of the SpreadsheetConvertOptions class and pass these parameters to the Convert method
By following the points above in order, you can simply construct the capability to convert Excel to CSV using Java. Further, these steps are used to do basic document transformation. You’ll need to utilize the SpreadsheetConvertOptions class to provide various properties for the converted file if you want the produced Excel file to be presented according to your standards.
Code to Convert Excel to CSV in Java
| import com.groupdocs.conversion.Converter; | |
| import com.groupdocs.conversion.licensing.License; | |
| import com.groupdocs.conversion.options.convert.SpreadsheetConvertOptions; | |
| import com.groupdocs.conversion.filetypes.SpreadsheetFileType; | |
| public class ConvertExcelToCsvInJava { | |
| public static void main(String[] args) { // Main function to convert Excel to CSV in Java | |
| // Remove the watermark in output Text document by adding license | |
| License lic = new License(); | |
| lic.setLicense("GroupDocs.Conversion.lic"); | |
| // Load the source Excel file for conversion to CSV | |
| Converter converter = new Converter("sample.xlsx"); | |
| // Set the convert options for CSV file | |
| SpreadsheetConvertOptions options = new SpreadsheetConvertOptions(); | |
| options.setFormat(SpreadsheetFileType.Csv); // Specify the conversion format | |
| // Convert and save the Excel in CSV format | |
| converter.convert("converted.csv", options); | |
| System.out.println("Done"); | |
| } | |
| } |
For this post, we have created a Java program to convert Excel to CSV. We have transformed documents from one Spreadsheet format to another in this guide. Furthermore, any source document can be converted to the following Spreadsheet formats: XLS, XLSX, XLSM, XLSB, ODS, OTS, XLTX, XLT, XLTM, TSC, XLAM, and CSV.
We have learned basic document conversion in this tutorial for XLSX to CSV format. If you want to understand more about document conversion of different document types, you can look out how to convert HTML to PDF in Java.
