This tutorial explains how to convert Excel to CSV in Java. There are many applications that require data in CSV format whereas the source data is available in an Excel file. In this case, using Java convert Excel to CSV and then use it wherever required. There may be cases where specific separators are required to be saved in the CSV file to differentiate values retrieved from different columns. This can also be achieved by using TxtSaveOptions class object.
Steps to Convert Excel to CSV in Java
- Add Aspose.Cells to the project using Maven
- Add a reference to TxtSaveOptions and Workbook using Import in the program
- Load the source Excel file into the Workbook object
- Instantiate the TxtSaveOptions to set parameters of the output CSV file
- Set the separator to be used in the output CSV file
- Save the Excel file as CSV
In the above steps, we load an Excel file and then save it as CSV. We set CSV file characteristics by using TxtSaveOptions class object. This class provides a variety of options like you can put quotes around all the values, clear the source workbook after conversion, indicate whether all the sheets or only the active sheet is to be converted, the entire sheet is to be converted or only a particular range is required to be transformed and many more. You can save the output CSV file to a physical file on disk or save it to a memory stream as per requirement.
Code for Conversion of Excel to CSV in Java
| import com.aspose.cells.License; | |
| import com.aspose.cells.TxtSaveOptions; | |
| import com.aspose.cells.Workbook; | |
| public class ConvertExcelToCSVInJava { | |
| public static void main(String[] args) throws Exception { | |
| // Initialize Aspose.Cells license to remove trial version watermark | |
| License license = new License(); | |
| license.setLicense("Aspose.Cells.lic"); | |
| // Load the Excel file into Workbook that is to be converted to CSV | |
| Workbook ExcelWorkbook = new Workbook("SampleExcel.xlsx"); | |
| // Instantiate the TxtSaveOption object to set parameters for output CSV | |
| TxtSaveOptions txtSaveOptions = new TxtSaveOptions(); | |
| // Set the separator that is to be used in the output CSV | |
| txtSaveOptions.setSeparator(';'); | |
| // Save the Excel workbook as CSV file | |
| ExcelWorkbook.save("Output.csv", txtSaveOptions); | |
| } | |
| } |
This code initializes a Workbook class object and then instantiates a TxtSaveOptions class object for setting parameters of the resultant CSV file. Finally Workbook.save() is used to generate CSV file. If you want to convert an Excel file to CSV format using a language other than Java say C#, you may refer to the article export large Excel file to CSV in C#.
Neither interop is used nor MS Excel is required for this conversion.
