Sign up   Login   Forum  
    
Freeware | Shareware | Most Popular | New releases | Top Rated




You can be a top contributor too! Just rate and review the stuff you download. Not a CodedWorld.com member? Sign up here!

> Scripts > ASP.NET > ASP.NET Articles > Howto


Download C# - Retrieve Excel Workbook Sheet Names.    AddThis Social Bookmark Button


Admin Rating: Not Rated Average User Rating: Not Rated Rate it
VISIT NOW add to Watchlist To download from torrent links, you must use a bittorrent client.

License Free Downloads 275
Limitation No Limitations Publisher kenny-young
Requirements C#, ASP.NET; Windows, .NET; Win32, VS; Dev Date Added Monday, September 10, 2007
File Size




Publisher:

Kenny Young


Publisher Information:
kenny-young

Product Description:
There are many examples using ADO.NET to query an Excel Workbook but they all have a limitation, you must know the worksheet name. This might work if you know the name of the worksheet, but what if you don't? If your program is dynamic and your sheet names differ for each Excel workbook, you need a way to extract the names of the sheets. The code example provides you with a way to retrieve the work sheet names.

The following method returns a string array containing the names of the sheets. The method also shows how to loop through the array. The method has one input parameter excelFile which is the location of the Excel file.





Admin Rating: Average User Rating:
Not Rated Not Rated
Help Center | Submit Product | All Products | All RSS feeds | Contact us | Feedback | Forum
Copyright © 2008 Codedworld.com source for windows drivers | windows softwares | scripts download | download games | FameBits | Ratetutorials Designed by Flashedcoder.com