Encoding issue while reading excel/csv file

babar.raza · September 28, 2015, 3:10am

Hi Santhosh,

Thank you for sharing the sample CSV files.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for Java 8.6.0 and the following piece of code. Please note, we are not able to see any issue (as mentioned in this thread) while loading the CSV (test2.csv as it contains the problematic characters) or saving it back. Please check the attached snapshot of the Excel view where we saved the resultant file in XLSX file format. You may clearly see that all problematic characters are displayed fine.

That said, we have also tested the case by displaying the problematic values/charchters on the Eclipse output terminal, in that case we have observed that the said charchters are bieng displayed as question marks (?). Please note, this is due to the encoding standard set for the console terminal and can easily be override using the following steps.

Click on Run menu and select Run Configuration.
While selecting your project from the left hand pane, click on the Common tab.
Under the Encoding heading, default encoding should have been selected by default. Please change it to appropriate encoding standard (ISO-8859-1 in this case), and run the process again.

Java

TxtLoadOptions options = new TxtLoadOptions(LoadFormat.CSV);
options.setSeparator(’;’);
options.setEncoding(Encoding.getEncoding(“ISO-8859-1”));
options.setMemorySetting(MemorySetting.MEMORY_PREFERENCE);
Workbook workbook = new Workbook(“D:/test2.csv”, options);
Worksheet worksheet = workbook.getWorksheets().get(0);
for(int i=0; i<11; i++)
{
System.out.println(worksheet.getCells().get(i, CellsHelper.columnNameToIndex(“J”)).getDisplayStringValue());
System.out.println(worksheet.getCells().get(i, CellsHelper.columnNameToIndex(“W”)).getDisplayStringValue());
}
workbook.save(“D:/output.xlsx”, SaveFormat.XLSX);

Output after changing the Encoding for Console

indexé révisable