Skip to main content
Question

convert Excel data to Json payload

  • March 15, 2023
  • 3 replies
  • 121 views
A
Forum|alt.badge.img+2

Hi,

i would like to convert excel data into json payload? Is this possible? 
if yes, could someone please help me?

i have three columns with multiple rows.

A

3 replies

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • March 15, 2023

Hi @Anil 8113 ,

 

Have you tried the Excel to JSON Package - Bot Store (automationanywhere.com) from Bot store?

Padmakumar
Raul Jaimes
A
Forum|alt.badge.img+2
  • Anil 8113
  • Author
  • Cadet | Tier 2
  • March 17, 2023

Hi @Padmakumar 

thank you, it worked.

A
Forum|alt.badge.img+2
  • Anil 8113
  • Author
  • Cadet | Tier 2
  • March 20, 2023

Hi @Padmakumar 

Output I saved in a text file and I see “Row 1”:, “Row 2”:, “Row 3”:, so on… how do I ignore/remove them from output?

 

Terms & ConditionsCookie settingsAccessibility statement