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?
I have identified the data causing the problem.
attached file shows the data.
One column in the grid has a number of trailing null characters (\0).
Hello,
Does changing the data in the mentioned area resolved your issue ?
If you still have any conserns please feel free to contact us.
Modifying the data resolved the issue.