Free Support Forum - aspose.com

Encoding problem when converting xls to csv

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

Hi,

Thanks for the file.

We will figure it out soon.

Thank you.

Please try this attached fix.