dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Getting sheet names of given excel sheet

  1. #1
    Join Date
    May 2002
    Location
    Colombo,Sri Lanka
    Posts
    1,110

    Question Getting sheet names of given excel sheet

    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

  2. #2
    Join Date
    Nov 2004
    Location
    Poland
    Posts
    1,355

    Re: Getting sheet names of given excel 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)