Hi, currently I am using Excel application scope to loop through Excel sheets. I use a For Each loop to do this using Workbook.GetSheets. Normally this would work fine but due to issues with 2017 version I would like to use the System activities or an alternative approach that accesses the file directly instead of using the Excel application. How do I do this?
For a dynamic solution, I’m afraid you will need to reach out to some Macros to be able to extract the names of your sheets.
For a less dynamic solution, you can always set the loop based on a fixed array of items, but I’m afraid it is not what you are after.
Lastly, you could try to surface automate the Excel file to extract those sheet names (while opening it with a simple Open Application).