Is there a way to get “For Each Excel Sheet” (Modern Integrations) to completely ignore hidden sheets? At least with v2.11.4, it iterates through the loop for the total number of times for all sheets (hidden and not hidden); however, CurrentSheet.Name only populates with names of non-hidden sheets.…

For Each Excel Sheet w/Hidden Sheets

Yoichi (Yoichi) April 26, 2022, 12:43am 2

Hi,

It seems a bug of ForEachExcelSheet.

In Excel.Activities package 2.12.3 bundled in 22.4.0CE, it works well.(Hidden sheets are skipped)
So can you try to update to the latest version (2.12.3 or 2.12.2-preview)?

Regards,

Topic		Replies	Views
How to skip the hidden sheet in excel Activities excel , activities , question	5	1753	March 20, 2023
Hidden sheets in Excel Studio studio , question , activities_panel	3	318	August 24, 2023
For each excel sheet (except hide sheet , specific file)? Activities excel , activities , question	2	1347	January 9, 2022
How can I loop sheets in Excel？ Activities excel , activities , question	5	808	June 19, 2023
In Excel, Iterate Through Each Sheet, Then Through Each Row Studio studio , question , activities_panel	6	2207	October 22, 2021

For Each Excel Sheet w/Hidden Sheets

Related topics