in

C1 Community

ComponentOne Community is a free source for developers and help authors to collaborate and communicate.

System.IndexOutOfRangeException error on Load of xls file

Last post 04-24-2008 5:07 PM by brent.podruzny. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-19-2008 7:09 PM

    System.IndexOutOfRangeException error on Load of xls file

    I get the following error when trying top load the attached file  (OK, how do I upload the xls file???)

     

    System.IndexOutOfRangeException was unhandled by user code
      Message="Index was outside the bounds of the array."
      Source="C1.C1Excel.2"
      StackTrace:
           at C1.C1Excel.ah.e()
           at C1.C1Excel.XLSheet.e()
           at C1.C1Excel.XLSheet.j(Stream A_0)
           at C1.C1Excel.C1XLBook.t(Stream A_0, Boolean A_1)
           at C1.C1Excel.C1XLBook.z(at A_0, Boolean A_1)
           at C1.C1Excel.C1XLBook.r(String A_0, Boolean A_1)
           at C1.C1Excel.C1XLBook.Load(String fileName, FileFormat format, Boolean fillSheets)
           at C1.C1Excel.C1XLBook.Load(String fileName)
           at TTC.Alpha.Util.ExcelProvider.GetBook()
           at TTC.Alpha.Util.ExcelProvider.get_WorksheetNames()
           at TTC.Alpha.UI.LineListImportPresenter.SetExcelFilename(String selectedFilename) in C:...nter.cs:line 236
           at TTC.Alpha.UI.LineListImportPresenter.SelectFile() in C:...er.cs:line 225
           at TTC.Alpha.UI.LineListImportForm.openFileButton_Click(Object sender, EventArgs e) in C:...rm.cs:line 287
           at System.Windows.Forms.Control.OnClick(EventArgs e)
           at System.Windows.Forms.Button.OnClick(EventArgs e)
           at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
           at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
           at System.Windows.Forms.Control.WndProc(Message& m)
           at System.Windows.Forms.ButtonBase.WndProc(Message& m)
           at System.Windows.Forms.Button.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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

     

  • 04-03-2008 6:23 AM In reply to

    Re: System.IndexOutOfRangeException error on Load of xls file

    Hi

     

    Dim wb As New C1.C1Excel.C1XLBook

    wb.Load("C:\ABC.xls")

     

    Reagrds

    Dave

    <brent.podruzny> wrote in message news:203050@10.0.1.98...

    I get the following error when trying top load the attached file  (OK, how do I upload the xls file???)

     

    System.IndexOutOfRangeException was unhandled by user code
      Message="Index was outside the bounds of the array."
      Source="C1.C1Excel.2"
      StackTrace:
           at C1.C1Excel.ah.e()
           at C1.C1Excel.XLSheet.e()
           at C1.C1Excel.XLSheet.j(Stream A_0)
           at C1.C1Excel.C1XLBook.t(Stream A_0, Boolean A_1)
           at C1.C1Excel.C1XLBook.z(at A_0, Boolean A_1)
           at C1.C1Excel.C1XLBook.r(String A_0, Boolean A_1)
           at C1.C1Excel.C1XLBook.Load(String fileName, FileFormat format, Boolean fillSheets)
           at C1.C1Excel.C1XLBook.Load(String fileName)
           at TTC.Alpha.Util.ExcelProvider.GetBook()
           at TTC.Alpha.Util.ExcelProvider.get_WorksheetNames()
           at TTC.Alpha.UI.LineListImportPresenter.SetExcelFilename(String selectedFilename) in C:...nter.cs:line 236
           at TTC.Alpha.UI.LineListImportPresenter.SelectFile() in C:...er.cs:line 225
           at TTC.Alpha.UI.LineListImportForm.openFileButton_Click(Object sender, EventArgs e) in C:...rm.cs:line 287
           at System.Windows.Forms.Control.OnClick(EventArgs e)
           at System.Windows.Forms.Button.OnClick(EventArgs e)
           at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
           at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
           at System.Windows.Forms.Control.WndProc(Message& m)
           at System.Windows.Forms.ButtonBase.WndProc(Message& m)
           at System.Windows.Forms.Button.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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

     



    http://helpcentral.componentone.com/cs/forums/p/74692/203050.aspx#203050

  • 04-24-2008 5:07 PM In reply to

    Re: System.IndexOutOfRangeException error on Load of xls file

    Ummmm, I know how to load in the xls file...my question was how do I upload the file for you to try to load. 

Page 1 of 1 (3 items)
Contact ComponentOne: 1.800.858.2739 ©1987-2008 ComponentOne LLC All Rights Reserved.