NagasubramaniamB Member since 2018 5 posts
Cognizant Technology solutions
Posted: 2 years ago
Last activity: 2 years 3 months ago

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?

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn