We are using Aspose.Cells v126.96.36.199
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);