Free Support Forum - aspose.com

Handle double-quote character

Hi,

We are using Aspose.Cells v8.8.2.3

When exporting context from gridview to excel via Aspose.Cells.Workbook, any cell consisted of double-quote char is messing up in the resultant excel. And several cells may shift to left unexpectedly.

Is there configuration I am missing to escape the special characters?


I have attached 2 screenshots for your reference:
- gridview.jpg - content to be exported to excel
- excel.jpg - the result

And this is how my workbook was created:
Aspose.Cells.LoadOptions loadOptions = new Aspose.Cells.LoadOptions(Aspose.Cells.LoadFormat.TabDelimited);
Aspose.Cells.Workbook wb = new Workbook(outputStream, loadOptions);

Thanks,
Gil


Hi,


Thanks for providing us some details and screenshots.

Please try our latest version/fix: Aspose.Cells for .NET v17.1.10 if it makes any difference:

Aspose.Cells for .NET v17.1.10 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.1.10 (.NET 4.0) compiled in .NET Framework 4.0.

If you still find the issue with v17.1.x, kindly do create a simple sample project (runnable), zip it and provide us here to reproduce the issue with all the files (input, output, etc.), we will check it soon.

Thank you.