JSON to XLSX Conversion Automation using UI Path

excel
activities
studio

#1

Hi RPA Devs,

Good day.

I`ll just ask if this is doable, I was planning to have an automation which read an JSON file and convert it to XLSX file, hoping for any suggestion. :slight_smile:

Thank you guys, very much appreciated.

Regards,
Ced


#2

Search for Json to Datatable in the forum.

It will be
Json --> Datatable --> Xlsx (Write Range)


#3

@Cedrick_Julian
There are two activities available to Deserialize Json. If your Json is already in array structure, you can use deserializeJsonArray activity. Else you have to use DeserializeJson activity. The result of these activities will be JsonArray and Jsonobject respectively.
You have to convert this resultant value to datatable.
Use write range activity to write the datatable in the excel

Please refer-




#4

Hi Sir Madhavi & vvaidya

Thank you for all of your suggestion, we`ll try this.

Thanks a lot sirs.

Regards,
Ced