I have tried, " & SheetName & "$ or Table_Name TableName is not valid Any idea(s) on the VBNet Codes (Framework 4) will be very much appreciatedThanx guys Posted 5Jul11 2338pmWhen we deal with a workbook with a large number of worksheets, we may need to get the names of those worksheets and then it is easy for us to find the information we want This article will demonstrate how to use SpireXLS to get a list of the worksheets in the workbook in two parts Get a list of all the worksheet names in a workbook Refer to Sheets by Name You can identify sheets by name using the Worksheets and Charts properties The following statements activate various sheets in the active workbook You can use the Sheets property to return a worksheet, chart, module, or dialog sheet The Sheets collection contains all of these kinds of sheets
Binding To Excel Data Sources Winforms Controls Devexpress Documentation
