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
30
Error importing excel into Workbook
posted

I'm trying to load an excel sheet into a workbook.   It works fine until I edit the sheet, but after I do edit it and try to import it I get
"'The left and top of the window bounds must be between -32768 and 32767.  Parameter name: value'"

Using version 14.1

System.ArgumentException
HResult=0x80070057
Message=The left and top of the window bounds must be between -32768 and 32767.
Parameter name: value
Source=Infragistics4.Documents.Excel.v14.1
StackTrace:
at Infragistics.Documents.Excel.WorkbookWindowOptions.set_BoundsInTwips(Rectangle value)
at Infragistics.Documents.Excel.Serialization.Excel2007.XLSX.PartManagers.ObjectModelWorkbookPartManagerBase.LoadWorkbookViewElement(XmlPartManagerBase partManager)
at Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.TryLoadNormalElement(QualifiedNameInfo elementName, String strictQualifiedName, Int32 currentChildIndex)
at Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.LoadChildElementsHelper(Int32 currentChildIndex, AlternateContentStatus alternateContentStatus)
at Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.TryLoadNormalElement(QualifiedNameInfo elementName, String strictQualifiedName, Int32 currentChildIndex)
at Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.LoadChildElementsHelper(Int32 currentChildIndex, AlternateContentStatus alternateContentStatus)
at Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.TryLoadNormalElement(QualifiedNameInfo elementName, String strictQualifiedName, Int32 currentChildIndex)
at Infragistics.Documents.OfficeOpenXml.Core.XmlReadManager.LoadChildElementsHelper(Int32 currentChildIndex, AlternateContentStatus alternateContentStatus)
at Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.LoadCore()
at Infragistics.Documents.Excel.Serialization.Excel2007.XLSX.PartManagers.ObjectModelWorkbookPartManagerBase.LoadCore()
at Infragistics.Documents.OfficeOpenXml.Core.PartManagers.XmlPartManagerBase.Load()
at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.LoadPart(IPackagePart part)
at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.LoadPartRelationships(IPackagePart sourcePart, PartManagerBase sourcePartManagerPrototype, IEnumerable`1 relationships, Boolean hasSourcePartBeenLoaded, Boolean& wereRelationshipsSkipped)
at Infragistics.Documents.OfficeOpenXml.Core.OfficeDocumentManager.LoadCore()
at Infragistics.Documents.Excel.Serialization.Excel2007.XLSX.ObjectModelExcelDocumentManager.LoadCore()
at Infragistics.Documents.Excel.Serialization.WorkbookLoadManagerExcel2007.LoadCore()
at Infragistics.Documents.Excel.Serialization.WorkbookLoadManager.Load()
at Infragistics.Documents.Excel.Workbook.LoadXLSXFile(Workbook workbook, Stream stream, WorkbookLoadOptions loadOptions)
at Infragistics.Documents.Excel.Workbook.LoadHelper(Stream stream, String parameterName, WorkbookLoadOptions loadOptions, Boolean isStreamDecrypted, Nullable`1 format)
at Infragistics.Documents.Excel.Workbook.LoadHelper(String fileName, WorkbookLoadOptions loadOptions)
at Infragistics.Documents.Excel.Workbook.Load(String fileName, WorkbookLoadOptions loadOptions)
at Trident.Objects.Business.Stores.StockItemPricingBatch.ImportFromExcel(String filename, ICacheable pricingType) in D:\Code\Trident\Trident.Objects\Trident.Objects\Business\Stores\StockitemPricingBatch.vb:line 699
at Trident.UI.Business.Stores.frmStockItemPricingModule.ImportCommoditiesFromExcel() in D:\Code\Trident\Trident.UI\Trident.UI\Business\Stores\frmStockItemPricingModule.vb:line 191
at Trident.UI.Business.Stores.frmStockItemPricingModule.ImportCommoditiesToolStripMenuItem_Click(Object sender, EventArgs e) in D:\Code\Trident\Trident.UI\Trident.UI\Business\Stores\frmStockItemPricingModule.vb:line 181
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.RunDialog(Form form)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at Trident.Startup.Main() in D:\Code\Trident\Trident\Startup.vb:line 179