Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
65
Excel 2007 Export Error: unreadable content
posted

have installed NetAdvantageUltimate_20112, WinForms specifically.  Setup File version 11.2.20112.1000.

Exporting grid content to to Excel in 2007 format produces error about unreadable content when opening the file:

excelExporter.Export(exportGrid, exportFile.FileName, Infragistics.Documents.Excel.

 

WorkbookFormat.Excel2007);

The same export in 1997-2003 Excel format exports and open OK:

excelExporter.Export(exportGrid, exportFile.FileName, Infragistics.Documents.Excel.WorkbookFormat.Excel97To2003);

Excel 2010 is used to read both files.

# Rows: 768  #Columns: 19

Represents 1 month's data for a customer.  Other month's export just fine.

Need to find out out what in the data is causing the export to fail to produce a correctly formatted file.

is there any way to identify an error in the export process (exception) rather than opening a damaged file to discover the export was faulty?