Wiki

Clone wiki

Aspose for Apache POI / Read-CSV-File-With-Multiple-Encodings

Aspose.Cells

//Set Multi Encoded Property to True
TxtLoadOptions options = new TxtLoadOptions();
options.setMultiEncoded(true);

//Load the CSV file into Workbook
Workbook workbook = new Workbook(dataPath + "MultiEncoded.csv", options);

//Save it in XLSX format
workbook.save(dataPath + "EncodedNewFile_Out.xlsx", SaveFormat.XLSX);

Download Source Code

Updated