Encoding problem when converting xls to csv

Aspose.Cells Product Family
1

Hi,

I’ve attached example.zip file containing XLS file and converted CSV document.
The problem is that some characters are displayed incorrectly after converting to CSV (the last character in provided example). I guess this is encoding problem.
Is there any way to specify encoding for CSV file? In this case it should be ISO 8859-13 (Latin-7).

I’m using latest version of Aspose.Cells component.
Conversion is done like this:
MemoryStream stream = new MemoryStream();
switch (TypeOfDocument)
{
case DocumentType.Excel:
this.mWorkingDocument.Save(stream, FileFormatType.Excel2003);
this.mWorkingDocument.Open(stream, FileFormatType.Excel2003);
break;
case DocumentType.CSV_1:
this.mWorkingDocument.Save(stream, ‘|’);
this.mWorkingDocument.Open(stream, ‘|’);
break;
case DocumentType.CSV_2:
this.mWorkingDocument.Save(stream, ‘,’);
this.mWorkingDocument.Open(stream, ‘,’);
break;
default:
this.mWorkingDocument.Save(stream, FileFormatType.Excel2003);
this.mWorkingDocument.Open(stream, FileFormatType.Excel2003);
break;
}
byte[] array = stream.ToArray();

Thanks

2

Hi,

Thanks for the file.

We will figure it out soon.

Thank you.

3

Please try this attached fix.