Question

Dictionary Variable?

  • 2 January 2023
  • 6 replies
  • 216 views
M
Badge +2

How to read an excel file using dictionary variable in automation anywhere?

 

6 replies

C
Userlevel 5
Badge +11

Hi @mohank06 

Can you share bot more context on the issue you are facing?

Padmakumar
Userlevel 7
Badge +13

Hi @mohank06 ,

I am not sure about your actual requirement. 

However, please refer the below documentation on steps for Dictionary Variable for CSV-excel.

https://docs.automationanywhere.com/bundle/enterprise-v11.3/page/enterprise/topics/aae-client/bot-creator/using-variables/dictionary-type-variables.html

 

I hope this will help.

Padmakumar
C
Userlevel 5
Badge +11

Hi @mohank06 

Can you share bot more context on the issue you are facing?

Checkout below recourses,

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-dictionary-command.html

 

R
Userlevel 5
Badge +10

@mohank06  https://www.youtube.com/watch?v=2BbDqk8uUxU&ab_channel=sumihiteprogramming

Ramesh B Kadiyam
Raul Jaimes
Userlevel 5
Badge +9

@mohank06 

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. 

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-loop-command.html

Also, you can use an action Get Name/Get Path from the File package  but they will return a string variable.

HTH

 

Regards

K
Badge +2

@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.

 

  1. Open excel using Excel open Command 
  2. Use Get Multiple Cells Command.
  3. Loop Through Data Table.
  4. Use Dictionary Put Command to Add Current Excel Data into Dictionary Variable.

Reply


Terms & ConditionsCookie settings