How to read an excel file using dictionary variable in automation anywhere?
Can you share bot more context on the issue you are facing?
Hi @mohank06 ,
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.
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.
@mohank06 I believe that your requirement is to read the Excel file with 2 Columns.
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.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.