Unable to open spreadsheet dynamically using recorder variables

rpa
rpaexpress

#1

Hi Team

Need to open spreadsheet dynamically using recorder variables, there is required according to bot.

Also, required for multiple sheets.

Thanks
Ajay


#2

@Ajay_Singh_Rawat6

Hi Ajay, please send your zipped recording or a more detailed description of what you need to do.

Thank you,
Alesia


#3

Hi Alesia, thanks for your response. Will send you soon.

Thanks,
Ajay


#4

Hi Alesia

dynamic_folders.zip (1.6 KB)
folder_structure.zip (54.3 KB)

Folder Structure

• Demo
o trans_list.xlsx – data related to trans list and each trans have folder with required excel files, which is shown in below points.
o trans_1 – this is refer from trans_list.xlsx file
 registration.xlsx
 form1.xlsx
 form2.xlsx
o trans_2 – this is refer from trans_list.xlsx file
 registration.xlsx
 form1.xlsx
 form2.xlsx
o trans_3 – this is refer from trans_list.xlsx file
 registration.xlsx
 form1.xlsx
 form2.xlsx

First of all, I created a variable “trans_list” and get the data from trans_list.xlsx file.

Now I get each trans from “trans_list” variable and try to open excel file dynamically using “Open Spreadsheet” option.

Here I got stuck, how can I do this?

I attached recording zip and some screenshots for your help to understand better.

Attached files :
• folder_structure.zip
• dynamic_folders.zip
• demo.PNG

If there is any query, please let me know.

Thanks
Ajay


#5

I think you can use variables and then use it as ${variable_name} where you want. Eg. C:\xyz\abc\filename-${variable_name}.xlsx.

Pls try this


#6

Thanks JThangaswamy

It works.

Here is the screenshot.