Forums Ultimate UI for Windows Forms
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
Close
Dana Comolli
870
How to open a workbook saved in StrictOpenXml format
posted

Our application has the need to open workbooks that have been saved in the StrictOpenXml format.  Calling the workbook's load method generates "Input string was not in a correct format." with the following stack dump.  Any help would be appreciated.

   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseUInt32(String value, NumberStyles options, NumberFormatInfo numfmt)
   at Infragistics.Documents.OfficeOpenXml.Excel.NamespaceDefinitions.SpreadsheetMLMain.ReadCT_ColorElement(XmlPartManagerBase partManager, String elementName, Nullable`1& autoValue, Nullable`1& indexedValue, Nullable`1& rgbValue, Nullable`1& themeValue, Double& tintValue)
   at Infragistics.Documents.OfficeOpenXml.Excel.NamespaceDefinitions.SpreadsheetMLMain.ReadColorElement(XmlPartManagerBase partManager, Nullable`1& autoValue, Nullable`1& indexedValue, Nullable`1& rgbValue, Nullable`1& themeValue, Double& tintValue)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XLSX.PartManagers.ObjectModelCommonPartHelpers.LoadColorElement(XmlPartManagerBase partManager)
   at Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.LoadChildElementsHelper(Int32 startStackDepth, Int32 currentChildIndex, AlternateContentStatus alternateContentStatus, Boolean isContinuation, Boolean justPopped)
   at Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.<>c__DisplayClass8.<LoadCore>b__6()
   at Infragistics.Documents.Core.Async.If(Boolean condition, Func`1 statement, Func`1 elseStatement)
   at Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.<LoadCore>b__5(XmlReader xmlReader)
   at Infragistics.Documents.Core.Async.UsingHelper`1.<Execute>b__a()
   at Infragistics.Documents.Core.Async.Try(Func`1 try, Action finally)
   at Infragistics.Documents.Core.Async.UsingHelper`1.Execute()
   at Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.LoadCore()
   at Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.<Load>b__0()
   at Infragistics.Documents.Core.Async.Try[TResult](Func`1 try, Action finally)
   at Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.Load()
   at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass1a.<>c__DisplayClass1c.<>c__DisplayClass1e.<LoadPart>b__13(Stream partStream)
   at Infragistics.Documents.Core.Async.UsingHelper`1.<Execute>b__a()
   at Infragistics.Documents.Core.Async.Try(Func`1 try, Action finally)
   at Infragistics.Documents.Core.Async.UsingHelper`1.Execute()
   at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass1a.<>c__DisplayClass1c.<>c__DisplayClass1e.<LoadPart>b__12()
   at Infragistics.Documents.Core.Async.Try(Func`1 try, Action finally)
   at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass1a.<>c__DisplayClass1c.<LoadPart>b__11()
   at Infragistics.Documents.Core.Async.If(Boolean condition, Func`1 statement, Func`1 elseStatement)
   at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass1a.<LoadPart>b__10(WorkItem`1 t)
   at Infragistics.Documents.Core.WorkItemExtensions.<>c__DisplayClassc`1.<Then>b__b()
   at Infragistics.Documents.Core.WorkItem.WorkItemAsync.ExecuteCore(WorkItemScheduler scheduler)
   at Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)
--- End of stack trace from previous location where exception was thrown ---
   at TryThrowExceptionDispatchInfo(Object )
   at Infragistics.Documents.Core.WorkItem.ExceptionInfo.Rethrow()
   at Infragistics.Documents.Core.WorkItemExtensions.GetResult[TResult](WorkItem`1 this)
   at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<>c__DisplayClass1a.<LoadPart>b__10(WorkItem`1 t)
   at Infragistics.Documents.Core.WorkItemExtensions.<>c__DisplayClassc`1.<Then>b__b()
   at Infragistics.Documents.Core.WorkItem.WorkItemAsync.ExecuteCore(WorkItemScheduler scheduler)
   at Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)
--- End of stack trace from previous location where exception was thrown ---
   at TryThrowExceptionDispatchInfo(Object )
   at Infragistics.Documents.Core.WorkItem.ExceptionInfo.Rethrow()
   at Infragistics.Documents.Core.WorkItemExtensions.GetResult[TResult](WorkItem`1 this)
   at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.<LoadCore>b__b(WorkItem`1 t)
   at Infragistics.Documents.Core.WorkItemExtensions.<>c__DisplayClassc`1.<Then>b__b()
   at Infragistics.Documents.Core.WorkItem.WorkItemAsync.ExecuteCore(WorkItemScheduler scheduler)
   at Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)
--- End of stack trace from previous location where exception was thrown ---
   at TryThrowExceptionDispatchInfo(Object )
   at Infragistics.Documents.Core.WorkItem.ExceptionInfo.Rethrow()
   at Infragistics.Documents.Core.WorkItemExtensions.GetResult[TResult](WorkItem`1 this)
   at Infragistics.Documents.Core.Async.<>c__DisplayClass2`1.<Try>b__0(WorkItem`1 t)
   at Infragistics.Documents.Core.WorkItemExtensions.<>c__DisplayClass6`1.<Then>b__5()
   at Infragistics.Documents.Core.WorkItem.WorkItemSync.ExecuteCore(WorkItemScheduler scheduler)
   at Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)
--- End of stack trace from previous location where exception was thrown ---
   at TryThrowExceptionDispatchInfo(Object )
   at Infragistics.Documents.Core.WorkItem.ExceptionInfo.Rethrow()
   at Infragistics.Documents.Core.WorkItem.RunNextWorkItem(WorkItemScheduler scheduler)
   at Infragistics.Documents.Core.WorkItem.Execute(WorkItemScheduler scheduler)
   at Infragistics.Documents.Core.WorkItemScheduler.SynchronousImpl.Execute(WorkItem workItem)
   at Infragistics.Documents.Core.WorkItemExtensions.GetResult[TResult](WorkItem`1 this)
   at Infragistics.Documents.Excel.Workbook.Load(String fileName, WorkbookLoadOptions loadOptions)
   at DMAXX.TheBooks.Controls.ReceiveLogItemViewer.DisplayReceiveLogItem(ReceiveLog pReceiveLog) in F:\TheBooks\TBClient\Controls\ReceiveLogItemViewer.vb:line 57
Parents
No Data
Reply
  • 469350
    Offline posted

    Hi,

    I assume the same files opens correctly in MS Excel?

    If so, then can you provide me with a sample Excel document file I can use to test this and see the exception?

Children