Find First Unhidden Sheet Name Of An Excel Using Workbook Activity

[Yoichi]

Hi,

Unfortunately, there is no activity to find hidden/visible sheet in Workbook activity. However, we can achieve it using ClosedXML as the following. Can you try this?

workbook.Worksheets.Where(Function(s) s.Visibility=ClosedXML.Excel.XLWorksheetVisibility.Visible).OrderBy(function(s) s.Position).First().Name

Sample20220523-5.zip (11.3 KB)

Regards,