How to read an excel file using dictionary variable in automation anywhere?
How to read an excel file using dictionary variable in automation anywhere?
Hi
Can you share bot more context on the issue you are facing?
Hi
I am not sure about your actual requirement.
However, please refer the below documentation on steps for Dictionary Variable for CSV-excel.
I hope this will help.
Hi
Can you share bot more context on the issue you are facing?
Checkout below recourses,
Wolud you like open a excel file using a dictionary?
Use a Dictionary variable in a Loop action. It can return a pair of keys: name and action.
Also, you can use an action Get Name/Get Path from the File package but they will return a string variable.
HTH
Regards
Because when you talk about Dictionary and Excel Combination then excel Should be of 2 columns because Dictionary will work on Key And value Pairs.
So Yo can do this to read Excel file Values to Dictionary.
Hello
If your Excel has data in a key-value pair, you can read the entire tabular data using a Get multiple cell command or using an excel read from command and store it in a excel dataset or SQL dataset respectively, then use the loop action to traverse through the same as below:
In this loop you can add a Dictionary put command and assign the values providing the dynamic key and value as below:
Hope it helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.