This is a migrated thread and some comments may be shown as answers.

ExportToXlsx sometimes gives Excel error when opening document (seems to be with columns with null values)

9 Answers 623 Views

GridView

This is a migrated thread and some comments may be shown as answers.

Peter asked on 11 May 2015, 11:20 AM

I use ExportToXlsx to export gridview data to an excel file using the following code snippet

gridView.ExportToXlsx(fs, new GridViewDocumentExportOptions()

{

ShowColumnHeaders = true,

AutoFitColumnsWidth = true

});

Sometimes when opening the file in Excel I get the error message:

Excel found unreadable content in ... Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

I can open the file after clicking yes, but the content is not in sync with the information as shown in the GridView.

It seems that this happens when the grid has empty cells e.g. we have a date field which can be omitted (null).

If I use the exportToPdf method al goes well using the same date in the gridview. So it seems it's an issue related to Excel export.

Is this a bug or otherwise how can I fix this issue?

I use version 2015.1.401.45

Regards,
Peter

9 Answers, 1 is accepted

Accepted

answered on 26 Aug 2015, 02:22 PM

I experienced similar problem:

var exportOptions = new GridViewDocumentExportOptions()

{

ExportDefaultStyles =true,

ShowColumnFooters = true,

ShowColumnHeaders = true,

ShowGroupFooters = true };

var tempFilename = @"c:\temp\telegridexport.xlsx";

using (FileStream steam = new FileStream(tempFilename, FileMode.CreateNew))

this.Quotes.ExportToXlsx(steam, exportOptions);

ExcelInstance.OpenExcelFile(tempFilename);

}

the grid have Column group in the grid. dll version: 2015.2.728.45

I get error like:

Excel found unreadable content in "telegridexport.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes

from excel log:

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error189520_04.xml</logFileName><summary>Errors were detected in file 'C:\temp\telegridexport.xlsx'</summary><repairedRecords summary="Following is a list of repairs:"><repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord></repairedRecords></recoveryLog>