Question
Cognizant Technology solutions
US
Last activity: 6 Nov 2018 20:02 EST
How to Read Excel Range in Automation
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?