Hello Everyone, So we have multiple Sheets which are in this Format “AN” “-” + Org Code Example 1)AN-WE08 2)AN-YE88 So over here if we concatenate AN and the Org Code have had one issue At times there could be a possibility that by mistake space was added in sheet name and its in below format …

Hi, Hope the following helps you. [image] sheetname = sheets.Where(Function(s) s.Replace(" ","")=target).FirstOrDefault Please note that it might be necessary to check ShowClassic at Filter in Activities panel to use GetWorkbookSheets activity. [image] Regards,

Check Sheet Name in Read Range

Help Studio

system (system) Closed January 11, 2023, 5:28pm 5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
To get Excel Sheet Name Activities excel , activities , question	3	112	December 9, 2024
Read range - identifier expected Studio uiautomation	4	1510	November 10, 2022
Question on Read range activity Studio uiautomation	12	63	December 1, 2024
How to read an excel sheet name as variable Help orchestrator	3	2862	January 31, 2020
How to move between hundreds of worksheets, one by one? Help excel , activities , question	3	851	December 10, 2019

Check Sheet Name in Read Range

Related topics