VB.net: How to get data from Excel worksheet to string object?

Question

I've tried this:

    'start Excel app
    Dim exApp As Microsoft.Office.Interop.Excel.Application
    exApp = CreateObject("Excel.Application")

    ' load excel document
    exApp.Workbooks.Open(fname)
    Dim exSheet As Microsoft.Office.Interop.Excel.Worksheet
    exSheet = exApp.Workbooks(1).Worksheets(1)

and than, for example accessing "C3" cell:

 Dim b As String
 b = exSheet.Cells("A3")

or:

b = exSheet.Cells(3,3)

and it throws me an exception. I'm feeling that I'm doing something wrong with the object access, but this method worked in embedded VB, and do not works in .net. Also, tried to google the exception code, with no relevant result.

Mark · Accepted Answer · 2009-08-03 17:36:14Z

2

Try:

b = exSheet.Range("A3").Value.ToString

answered Aug 3, 2009 at 17:36

Mark

109k20 gold badges180 silver badges238 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anton Over a year ago

Thanks, this works fine. Do Range method get another parameters, like (x,y) position to iterate through spreadsheet?

Mark Over a year ago

Hmm, you can use .Cells, but you would need exSheet.Cells()(3,3).Value2

shahkalpesh · Accepted Answer · 2009-08-03 17:41:18Z

1

I don't think you should write code in VB6 style for vb.net.

Looking at the code example, I think what you need is

b = exSheet.Cells(3,3).Text

or

b = exSheet.Cells(3,3).Value

EDIT: I guess it the reference should be assigned to an instance of range.
So, the code might look like

Range exampleRange = exSheet.Cells(3,3)
b = exampleRange.Text 'OR it can be b = exampleRange.Value

edited Aug 3, 2009 at 17:41

answered Aug 3, 2009 at 17:28

shahkalpesh

33.6k4 gold badges66 silver badges89 bronze badges

1 Comment

Anton Over a year ago

Intellisense shows me only ToString, Equals, GetHashCode, GetType and ReferenceEquals. Should I use one of them?

Collectives™ on Stack Overflow

VB.net: How to get data from Excel worksheet to string object?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related