Excelsheet name changed every week

V

Vimal25

Member
Hi All,
Suppose We have 3 excel sheet and we developed a process to get read data from excel sheet but Everyweek these excelsheet name changed or Excsheel put location folder changed .Because We know 3 excel name chaged but how robot will know and process only these 3 excel files.
What is possible way to do this .

Option1- Can we create Enviourment variable and every week we can reconfigure robot
Option 2- Can we read *.xlsx files from folder/location and then process them.

Please suggest your valuable options.

Vimal
 
V

VJR

Well-Known Member
Hi Vimal25,

Both of your options are valid.

Option1- Can we create Enviourment variable and every week we can reconfigure robot
You can create 3 env variables in the process and use that to work with each of the files.
Then if you know that the file names have changed modify them in the Environment variable from the System tab.

Option 2- Can we read *.xlsx files from folder/location and then process them.
For searching Excel files in a folder you can use the 'Get files' action 'Utility - File Management'

It has 2 inputs:

  • Folder - specify folder name
  • Pattern - use Pattern as "*.xlsx"
 
V

Vimal25

Member
Hi VJR ,

Actually , I want to know other options may be any coding is required or other .

Regards
Vimal
 
V

VJR

Well-Known Member
Hi Vimal,

These two options look to be the good ones because there is no coding involved as it is a best practice to use code stage only when it's not possible otherwise.

You can wait to hear back from other members for any other options that you're looking for.

Thanks.
 
You must log in or register to reply here.
Top