Skip to main content
Question

Dictionary Variable?


Forum|alt.badge.img+2

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

 

7 replies

Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • 2690 replies
  • January 2, 2023

Hi @mohank06 

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


Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • January 2, 2023

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.


Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • 2690 replies
  • January 2, 2023
ChanduMohammad wrote:

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

 


rbkadiyam
Forum|alt.badge.img+16
  • Navigator | Tier 3
  • 578 replies
  • January 2, 2023

Raul Jaimes
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • 494 replies
  • January 2, 2023

@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


Forum|alt.badge.img+2
  • Navigator | Tier 3
  • 10 replies
  • January 3, 2023

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

Forum|alt.badge.img+1
  • Cadet | Tier 2
  • 6 replies
  • June 21, 2024

Hello @mohank06 

 

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings