[RESOLVED] reading data from an excel file (in vb.net)

Hi,

I'm trying to read data from a close excel file in vb.net 2003.
I can't find any specific functions to read the number of colums and rows there are, loop them, and read the values.

I tried looking in the object browser and on msdn, but I can't find anything useful.

Can this be done using Automation or do I have to use a select statement using databases?

Any help is appreciated.

Here is one of my c0d examples - http://www.vbforums.com/showpost.php...07&postcount=5

Writing data in a file works, but I don't see any methods to read data.

The cells property returns a comObject instead of a string, is it any useful?
I can't view the contents of it.

VB Code:

Messagebox.Show(oSht.Cells(1, 1))

:)

Quote:

---

Originally Posted by RobDog888

VB Code:

Messagebox.Show(oSht.Cells(1, 1))

:)

---

I tried that, of course, didn't work. :)

"Cast from type 'Range' to type 'String' is not valid."

Weird thing, when I use msgbox instead of messagebox.show, I get:

"Additional information: Argument 'Prompt' cannot be converted to type 'String'."

That because your using Option Strict On, which is a good thing.

VB Code:

'Try...
Messagebox.Show(CType(oSht.Cells(1, 1), String))

Same result. :)

Are you sure it should work like that?

Should be as Range as I was free typing in the Reply box.

VB Code:

Dim oRange As Excel.Range = CType(oSht.Cells(1, 1), Excel.Range)
MessageBox.Show(oRange.Value2.ToString)