Skip to main content
Question

convert Excel data to Json payload

  • Mar 15, 2023 4:56 AM UTC
  • 3 replies
  • 237 views

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

    Padmakumar
    Premier Pathfinder | Tier 7
    Forum|alt.badge.img+3
    • Padmakumar
    • Premier Pathfinder | Tier 7
    • Mar 15, 2023 6:02 AM UTC

    Hi @Anil 8113 ,

     

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

    Padmakumar
      • Anil 8113
      • Author
      • Cadet | Tier 2
      • Mar 17, 2023 2:11 AM UTC

      Hi @Padmakumar 

      thank you, it worked.

      • Anil 8113
      • Author
      • Cadet | Tier 2
      • Mar 20, 2023 12:03 AM UTC

      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 & ConditionsAccessibility statement