Hi,
my company has buy the library version 18.2 but i have a problem when I select some excel file.
If I select the Excel file, whit dimension 17 K, i have an exception:
Index not in range. Request a value not negative and less than of dimension of the collection.\r\n Parameter name: index.
If I Open the Excel File and save it, the dimensione becomes 88 K and when i select the file, the code upload correctly all datas.
My code is:
String fileName = "Report_BilancioProvvisorio_20200612.xlsx";Byte[] messageContent;StreamReader readerStream = new StreamReader(fileName);String messageContentTxt = readerStream.ReadToEnd();readerStream.Close();messageContent = System.Text.Encoding.UTF8.GetBytes(messageContentTxt);
byte[] fileByteList = File.ReadAllBytes(fileName);MemoryStream mStream = new MemoryStream(fileByteList);
Workbook workbook;try{workbook = Workbook.Load(mStream);}catch(Exception ex){return;}
My StackTace is:in System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)in Infragistics.Documents.Excel.Serialization.Excel2007.FormatInfo.CreateWorksheetCellFormatData(WorkbookLoadManagerExcel2007 loadManager, Boolean isStyleFormat, Boolean forceApplyProperties)in Infragistics.Documents.Excel.Serialization.Excel2007.XLSX.PartManagers.ObjectModelStylesPartManager.ParseFormatInfos(WorkbookLoadManagerExcel2007 loadManager, List`1 formatInfos)in Infragistics.Documents.Excel.Serialization.Excel2007.XLSX.PartManagers.ObjectModelStylesPartManager.LoadStyleSheetEndElement(XmlPartManagerBase partManager)in Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.LoadChildElementsHelper(Int32 startStackDepth, Int32 currentChildIndex, AlternateContentStatus alternateContentStatus, Boolean isContinuation, Boolean justPopped)in Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.<>c__DisplayClass31_0.<LoadCore>b__1()in Infragistics.Documents.Core.Async.If(Boolean condition, Func`1 statement, Func`1 elseStatement)in Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.<LoadCore>b__31_0(XmlReader xmlReader)in Infragistics.Documents.Core.Async.UsingHelper`1.<Execute>b__3_0()in Infragistics.Documents.Core.Async.Try(Func`1 try, Action finally)in Infragistics.Documents.Core.Async.UsingHelper`1.Execute()in Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.LoadCore()in Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.<Load>b__11_0()in Infragistics.Documents.Core.Async.Try[TResult](Func`1 try, Action finally)in Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.Load()in Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass67_0.<LoadPart>b__3(Stream partStream)in Infragistics.Documents.Core.Async.UsingHelper`1.<Execute>b__3_0()in Infragistics.Documents.Core.Async.Try(Func`1 try, Action finally)in Infragistics.Documents.Core.Async.UsingHelper`1.Execute()in Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass67_0.<LoadPart>b__2()in Infragistics.Documents.Core.Async.Try(Func`1 try, Action finally)in Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass67_0.<LoadPart>b__1()in Infragistics.Documents.Core.Async.If(Boolean condition, Func`1 statement, Func`1 elseStatement)in Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass67_0.<LoadPart>b__0(WorkItem`1 t)in Infragistics.Documents.Core.WorkItemExtensions.<>c__DisplayClass8_0`1.<Then>b__0()in Infragistics.Documents.Core.WorkItem.WorkItemAsync.ExecuteCore(WorkItemScheduler scheduler)in Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)--- Fine traccia dello stack da posizione precedente dove è stata generata l'eccezione ---in TryThrowExceptionDispatchInfo(Object )in Infragistics.Documents.Core.WorkItem.ExceptionInfo.Rethrow()in Infragistics.Documents.Core.WorkItemExtensions.GetResult[TResult](WorkItem`1 this)in Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass67_0.<LoadPart>b__0(WorkItem`1 t)in Infragistics.Documents.Core.WorkItemExtensions.<>c__DisplayClass8_0`1.<Then>b__0()in Infragistics.Documents.Core.WorkItem.WorkItemAsync.ExecuteCore(WorkItemScheduler scheduler)in Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)--- Fine traccia dello stack da posizione precedente dove è stata generata l'eccezione ---in TryThrowExceptionDispatchInfo(Object )in Infragistics.Documents.Core.WorkItem.ExceptionInfo.Rethrow()in Infragistics.Documents.Core.WorkItemExtensions.GetResult[TResult](WorkItem`1 this)in Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<LoadCore>b__52_0(WorkItem`1 t)in Infragistics.Documents.Core.WorkItemExtensions.<>c__DisplayClass8_0`1.<Then>b__0()in Infragistics.Documents.Core.WorkItem.WorkItemAsync.ExecuteCore(WorkItemScheduler scheduler)in Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)--- Fine traccia dello stack da posizione precedente dove è stata generata l'eccezione ---in TryThrowExceptionDispatchInfo(Object )in Infragistics.Documents.Core.WorkItem.ExceptionInfo.Rethrow()in Infragistics.Documents.Core.WorkItem.RunNextWorkItem(WorkItemScheduler scheduler)in Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)in Infragistics.Documents.Core.WorkItemScheduler.SynchronousImpl.Execute(WorkItem workItem)in Infragistics.Documents.Core.WorkItemExtensions.GetResult[TResult](WorkItem`1 this)in Infragistics.Documents.Excel.Workbook.Load(Stream stream, WorkbookLoadOptions loadOptions)in ConsoleApp6.Program.Main(String[] args) in C:\Users\User\source\repos\ConsoleApp6\ConsoleApp6\Program.cs:riga 33
Thank you
good morning,i resolved this problem, my company has buy the new library.i have this problem with version library: InfragisticsWPF4.Documents.Core.v18.2.dllInfragisticsWPF4.Documents.Excel.v18.2.dll
and i resorved with this libaryInfragisticsWPF4.Documents.Core.v20.1.dllInfragisticsWPF4.Documents.Excel.v20.1.dll
thank you so much
best regads
Hello,
I am glad that you managed to resolve your issue.
Thank you for using Infragistics components!