Excel Tab Count

Options
Greg_703914
Greg_703914 Posts: 42
edited December 2019 in Ideas

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
3 votes

Swept · Last Updated

Comments

  • Jeff_146001
    Jeff_146001 Posts: 296 admin
    Options

    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.

Categories