vb.net ::How to get Excel sheet names

Here is a little piece of code to get your way around with Excel in VB .Net using VS 2005.

Dim objExcel As Excel.Application
Dim objWorkBook As Excel.Workbook
Dim totalWorkSheets As Excel.Worksheet
Dim objWorkSheets As Excel.Worksheet
Dim ExcelSheetName As String = “”

objExcel = CreateObject(”Excel.Application”)
objWorkBook = objExcel.Workbooks.Open(”C:\myExcel.xls”)

‘ this code gets the names off all the worksheets
For Each totalWorkSheets In myWorkBook.Worksheets
ExcelSheetName += totalWorkSheets.Name
Next totalWorkSheets


http://dotnetolympians.wordpress.com/2007/09/28/how-to-get-excel-sheet-names/

http://www.codeproject.com/KB/aspnet/getsheetnames.aspx
:: Momiji lo

me ::

love can drive the sanest of men crazy


:: Momiji lo

updates :: primary Mooncake fest

Date ::13th Sept 2008
Time :: 6/7 to 12AM ?
Place :: market, blk 10 playground
PPL :: Ang, Milk , Rui , Mich , L0r , Efre , Ver , Me.
camera :: Me , Rui , Mich

:: Momiji lo

food :: the only taco

THERE IS NO MORE TACO BELL AT FUNAN !!!

the pizza also no more la ..


:: Momiji lo

updates :: maple

06 Sept 2008.. 7PM

per0 n Kuro quited bEliEvEr ..

mmm .. hao sad ..

:: Momiji lo


edited 08/09/2008

per0's life hao complecated ar .. or isit per0 also tink too much .. haixx..

per0's back in believer ..
kazen n his gf in believer ..

kuro in Asgard .. :x

edited 15/09/2008

per0 quited believer
per0 in Asgard now too :x