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