getting the sheet names present in a work book????
 

Hi,
I want to dump some date from a excel file to a database.So i am using
VB.NET , Excel 2003 to do so.I want to know how do i get the names of the
sheets present in a workbook and would like to know is there is any way to
identify the column names in a worksheet??????

Regards

Reny


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/04

getting the sheet names present in a work book????
 

This is VBA, so you will need to translate to .NET

Sheet names

For Each sh In Activeworkbook
Debug,.Print sh.Name
Next sh

Column names. You mean thge value in Row 1?

Cells(1,"A").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Reny J Joseph Thuthikattu" <renyatbxtechdotcom wrote in message
.. .
Hi,
I want to dump some date from a excel file to a database.So i am using
VB.NET , Excel 2003 to do so.I want to know how do i get the names of the
sheets present in a workbook and would like to know is there is any way to
identify the column names in a worksheet??????

Regards

Reny


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/04

getting the sheet names present in a work book????
 

Thanx .I am able to figure it out

Dim xlApp As Excel.Application

Dim xlWB1 As Excel.Workbook

Dim x1WS1 As Excel.Worksheet

xlApp = New Excel.Application()

xlApp.Visible = True

xlWB1 = xlApp.Workbooks.Open("C:\2004.xls")

For Each x1WS1 In xlWB1.Worksheets

MsgBox(x1WS1.Name())

Next

xlWB1.Close()

xlApp = Nothing



Reagdrs



Reny
"Reny J Joseph Thuthikattu" <renyatbxtechdotcom wrote in message
.. .
Hi,
I want to dump some date from a excel file to a database.So i am using
VB.NET , Excel 2003 to do so.I want to know how do i get the names of the
sheets present in a workbook and would like to know is there is any way to
identify the column names in a worksheet??????

Regards

Reny


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/04




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/04