Read from Excel

[Tommy Malone]

Would someone mind please posting sample code for reading data from a column
in Excel? And/or providing any recommended reading on the subject?

Thanks!

[Herfried K. Wagner [MVP]]

* "Tommy Malone" <to***@angula.n et> scripsit:

Would someone mind please posting sample code for reading data from a column
in Excel? And/or providing any recommended reading on the subject?

<URL:http://www.connections trings.com/>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Cor Ligthert]

Hi Tommy,

I hope these helps?

Cor

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel dataset fill and update
http://support.microsoft.com/default...b;EN-US;316934

Would someone mind please posting sample code for reading data from a column in Excel? And/or providing any recommended reading on the subject?

Thanks!

[Lenn]

If you want something simple you can also use OledDBConnectio n of ADO.NET to connect to excel workbook as datasource. Use DataReader or DataSet to iterate through rows. You will need a valid connection string:

"provider=Micro soft.Jet.OLEDB. 4.0;data source=c:\FileN am.xls;Extended Properties=Exce l 5.0;"

Then just open connection and you can pretty much treat excel as any other datasource for simple queries of course.

Also use this SQL to select your column from Sheet1:
select ColumnName from [Sheet1$]

"Tommy Malone" wrote:

Would someone mind please posting sample code for reading data from a column
in Excel? And/or providing any recommended reading on the subject?

Thanks!

[Tommy Malone]

Thank you all. Great articles and examples. I feel stupid for asking after
seeing how easy it is.

Thanks again.

"Lenn" <Le**@discussio ns.microsoft.co m> wrote in message
news:B8******** *************** ***********@mic rosoft.com...

If you want something simple you can also use OledDBConnectio n of ADO.NET to connect to excel workbook as datasource. Use DataReader or DataSet to
iterate through rows. You will need a valid connection string:
"provider=Micro soft.Jet.OLEDB. 4.0;data source=c:\FileN am.xls;Extended Properties=Exce l 5.0;"
Then just open connection and you can pretty much treat excel as any other datasource for simple queries of course.
Also use this SQL to select your column from Sheet1:
select ColumnName from [Sheet1$]

"Tommy Malone" wrote:

Would someone mind please posting sample code for reading data from a column in Excel? And/or providing any recommended reading on the subject?

Thanks!

[Cor Ligthert]

Hi Tommy,

Not asking is stupid.

Thank you all. Great articles and examples. I feel stupid for asking after
seeing how easy it is.

Next time you can give these answers.

:-)

Cor

[Lenn]

>> The only problem that I found and haven't figured out yet is that you need to know the name of the sheet.

Well ... Same arguement can be made about a databse table. You have to know its name to begin with. Yes, you can look it up in system tables, but you have to know what you're looking for.

Do you have to use the Excel.Applicati on object model to get it and then use it with ADO?

Are building some kind of Excel data explorer application? Yes, you can use Excel.Applicati on to get the names of all sheets in a workbook.
Also Sheet1 is a default name.