My source data is an Excel File that contains multiple sheets. I have done the “Get Workbook Sheets” and got the sheetnames. But the problem here is I cannot specify the name of the Sheet because it will change with each Excel.
The Keyword that I need to match is “Machine”. But the sheet might be named as “Machine - 123” or “Machine 1130”.
I’ve tried “If” condition as below:
But it’s not working. Can anyone help me to point the mistake?
excel “Get workbook sheets” activity save the output to a list<string> variable ex: gwSheets. gwSheets.contains(“Machine”) will work without any issues.
please write gwSheets log in both if / else conditions and verify the sheet names.