Can we Assign the same name var

Help Studio
, ,
1

Because I want to make a UiProcess that duplicates Excel, but only the file name and sheet name are different. The file name and sheet name are the same. Can we remember to use the Assign command to set the same Var but different values ​​because we want to copy and paste the Workflow by changing only the Assign?

2

Hi @Sarttra ,

Thanks for reaching out.

As per my understanding, do you want to use the same workflow for processing different File Files?
In that scenario, you can create In_Argument For File Name, and Sheet Name so you can resue this component wherever you want in the project.

Hope this helps you.

Happy Automation,
@Vinit_Kawle

3

Hi @Sarttra

Since you are telling the file name and sheet name are same. You could create two variables filename and sheetname and pass the file name and sheet name. After that you can use the same variables for changing sheet names and file names inside the process.

Hope you understand!!
Regards

4

Hi @Sarttra

Could you be more elaborate your query with a simple scenario, then it will be better for our understanding.

5
  1. read Cell in ExcelA and Write to Excel 2 (SheetA)
    2.read Cell in ExcelB and Write to Excel 2 (SheetB)
    3.read Cell in ExcelC and Write to Excel 2 (SheetC)
    But More than 1 Cell Difference Column So I need to use Assign or Other to Reduce the time for create Workflow For Example Assign Sheet A to “Bo” so if I assign B I just change A to B but same Var is “Bo”
6

Hi @Sarttra
I think you can
But be careful to avoid confusion when using it
Regards,

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.