Hi - One of the requirement in our automation is to read values from excel but we have hardcoded the excel range which doesn't serve well when there is a need to add additional rows. Can you please help in providing an alternative solution on how to read the row count from an excel sheet before loading it to a lookup table? We are trying to avoid the harcoded cell range in the automation procedure. We also want to avoid the option of developing a C# script to achieve this. Any options available in Studio to achieve this?
I don't see any methods available in the Studio to get the range. However, if you want to achieve this without using C#, you can iterate through each row using GetCellValue until you get to the end of your range.