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

[Guiseppe]

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.

[RobDog888]

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

[Guiseppe]

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.

[RobDog888]

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

[Guiseppe]

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'."

[RobDog888]

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

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

[Guiseppe]

Same result.

[Guiseppe]

Are you sure it should work like that?

[RobDog888]

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

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