Forums Ultimate UI for ASP.NET Web 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
David Vondersmith
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

Parents
No Data
Reply
  • 7535
    Offline posted

    Hello ,

    Thank you for contacting . The maximum number of characters in a excel cell is limited to 32,767. If this is exceeded, the renderer displays an error message . If that is not the case then please share your excel file i will try to test it at our end.

Children
  • 30
    Offline posted in reply to Divya Jain

    test8.xlsx

    OK, thanks for looking into this.  Here is the file that throws the error. 

    NOTE.   This error is only thrown if I edit the spreadsheet.   If I export and then import without editing it the error does not happen.  

    Create File

    If SaveFileDialogXlsx.ShowDialog() = Windows.Forms.DialogResult.OK Then
    Try
    Me.Cursor = Windows.Forms.Cursors.WaitCursor
    ugExcelExporter.Export(grdStockItems, SaveFileDialogXlsx.FileName)

    Me.Cursor = Windows.Forms.Cursors.Default
    If Windows.Forms.MessageBox.Show("Export Complete, Open File?", "Report Export", Windows.Forms.MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then
    Process.Start(SaveFileDialogXlsx.FileName)
    End If
    Catch ex As Exception
    Me.Cursor = Windows.Forms.Cursors.Default
    MessageBox.Show("Cannot Create Export File: " & ex.Message.ToString(), "Export", MessageBoxButtons.OK, MessageBoxIcon.Error)
    End Try
    End If


    Import File - Throws error
    Dim workbook As Infragistics.Documents.Excel.Workbook =
    Infragistics.Documents.Excel.Workbook.Load(filename)