Question

convert Excel data to Json payload

  • 15 March 2023
  • 3 replies
  • 41 views

Badge +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.


3 replies

Userlevel 7
Badge +13

Hi @Anil 8113 ,

 

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

Badge +2

Hi @Padmakumar 

thank you, it worked.

Badge +2

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?

 

Reply