Solved

Index was outside of bounds of array when reading in excel range to VB.NET array

Posted on 2011-03-08
2
787 Views
Last Modified: 2012-05-11
For some reason I am getting an index out of range exception and I am not sure why.  I am reading in an excel worksheet that has 5 rows and 4 columns.  The value in the first cell (A1) is 1.

When I am debugging I can see the value in my array but when I try to display the value in the message box I get the 'Index was outside the bounds of the array.' exception.

Any ideas?

 
Dim objApp As New Excel.Application
        Dim objBook As Excel.Workbook
        Dim objSheet As Excel.Worksheet
        Try
            objBook = objApp.Workbooks.Open(Application.StartupPath & "\Book1.xlsx")
            objSheet = objBook.Worksheets(1)

            Dim range As Excel.Range
            Dim usedRows As Integer = objSheet.UsedRange.Rows.Count
            Dim usedColumns As Integer = objSheet.UsedRange.Columns.Count
            range = objSheet.Range("A1").Resize(usedRows, usedColumns)

            Dim Day1Info(,) As Object
            Day1Info = range.Value
            MsgBox(Day1Info(0, 0).ToString)

        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            objApp.Quit()
        End Try

Open in new window

Book1.xlsx
0
Comment
Question by:MeritorWabco
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 125 total points
ID: 35070852
Should that not be:
MsgBox(Day1Info(1, 1).ToString)

Open in new window

0
 

Author Closing Comment

by:MeritorWabco
ID: 35070896
Yeah :) duh (bonking self in head)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now