Hi ,
I need to get the sheet names of the given excel file.
User has to select excel file and from the prg. it should display the list of the sheet.
I DON'T WANT TOHE CONTENT JUST THE NAME OF THE SHEET
Printable View
Hi ,
I need to get the sheet names of the given excel file.
User has to select excel file and from the prg. it should display the list of the sheet.
I DON'T WANT TOHE CONTENT JUST THE NAME OF THE SHEET
There are (at least) 2 way to do it..
1) Traversing Excel objeck model. It requires COM Interops of Excel.
2) Using OleDB:
http://www.codeproject.com/aspnet/getsheetnames.asp
Hope it helps.