Attempting to export grid data on Win7 64-Bit with Office 2010 64-bit generates the following error:
Index was out of range. It must be non-negative and less than the size of the collection.Parameter name: indexActual value was 0., Exporting to file = 'C:\Users\Administrator\AppData\Local\Temp\Customers_5AB5.tmp'; Using template = 'C:\Program Files (x86)\Sage Software\Sage MAS 500 Client\GridTemplates\empty.xlsx'; Excel file format = 'Unknown'. at Infragistics.Excel.WorksheetCollection.get_Item(Int32 index) at Infragistics.Excel.Workbook.OnAfterLoadGlobalSettings(WorkbookSerializationManager manager) at Infragistics.Excel.Serialization.Excel2007.XLSX.Elements.WorkbookElement.OnAfterLoadChildElements(Excel2007WorkbookSerializationManager manager, ElementDataCache elementCache) at Infragistics.Excel.Serialization.Excel2007.XmlElementBase.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, ExcelXmlDocument document, XmlReader reader, ElementDataCache elementCache, List`1 elementCacheCollection, BeforeLoadElementCallback beforeLoadElementHandler, AfterLoadElementCallback afterLoadElementHandler, Boolean& isReaderOnNextNode) at Infragistics.Excel.Serialization.Excel2007.XmlElementBase.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, BeforeLoadElementCallback beforeLoadElementHandler, AfterLoadElementCallback afterLoadElementHandler, Boolean& isReaderOnNextNode) at Infragistics.Excel.Serialization.Excel2007.XmlContentTypeBase.Load(Excel2007WorkbookSerializationManager manager, Stream contentTypeStream) at Infragistics.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPart(IPackagePart part) at Infragistics.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPartRelationships(IEnumerable`1 relationships, ContentTypeBase contentType) at Infragistics.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadWorkbookContents() at Infragistics.Excel.Serialization.WorkbookSerializationManager.Load() at Infragistics.Excel.Workbook.LoadXLSXFile(Workbook workbook, Stream stream, IPackageFactory packageFactory, Boolean verifyExcel2007Xml) at Infragistics.Excel.Workbook.LoadHelper(Stream stream, WorkbookFormat format, String parameterName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml) at Infragistics.Excel.Workbook.Load(String fileName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml)
The excel file is 2010 file format, a workbook with three blank sheets.
Hi , I have test your file with the latest internal build of 10.3 - Infragistics3.Excel.v10.3 and gladly can confirm that the issue is fixed. So this fix will be included in the next service release that is planned for the middle of this month. More details about the planed date you can find here:http://es.infragistics.com/support/default.aspx#ServiceReleasesI will also update your case to get notified when the service release is ready.Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.
We are LOADing a standard Excel 2010 file. Hence the quotes around template. I described how I created the "template" above. Start Excel 2010 and click Save, hence a workbook with empty sheet and no data or formatting.
Hi, Yes this is the same error massage , but this doesn’t necessary mean that was caused by the same format of the excel, since this issue is related to standard excel format and not template file. If you give me the file you try to load (you can upload it in the case I have created for you) I will try to verify for you if is the same issue or is new one. Thank youSincerely,DimiDeveloper Support EngineerInfragistics, Inc.
The error occurs in the Load method, as you can see from the stack frame dump above. As I indicated I got the solution from another message thread on this forum so this should be a known issue to Infragistics. No need for me to send Excel file and create project to show Infragistics something someone there already knows about.
See thread
http://community.infragistics.com/forums/p/42367/234125.aspx#234125
Hello,
So you are loading the template successfully and then trying to export the grid data to it? When you save the data you got the error? So I assume that you are loading Excel template file format and as far I can see you are saving your data to XLSX file format.I have created a case for you - , so I will appreciate if you send me a small code snipped, and also the excel file you are trying to load to investigate it further. And we will communicate thought the case.
Thank you.
Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.