Excel Tab Count
Options
Greg_703914
Posts: 42
In some cases a given excel workbook may have data that needs to be extracted off of an unspecified number of tabs. For example, in one instance there may be 3 tabs and in another instance there may be only 1 tab. There should be a way to detect the number of tabs so that the number of tabs variable can be used to determine what sheets in a given workbook need to be extracted into a data table
Tagged:
3
Comments
-
An Excel: Get workbook info action could be useful. I could see it returning (among other things) a data table with all of the sheets in the workbook, including the sheet number, name, and perhaps some info regarding the amount of data stored in the sheet.
0