How to change JSON file to excel file

Help Activities
, , ,
1

Hi Everyone,

I have a JSON file. How to convert the JSON file to Excel.

Please guide me.

Regards,
Sandhya.

2

Hi @sandhya.govindharam

Check on this thread

I hope it helps!!

1 Like
3

Hi @sandhya.govindharam

“Read Text File” activity
“Deserialize JSON” activity
“Write Range” activity

1.Use the “Read Text File” activity to read the JSON file and store the content in a string variable (let’s call it jsonContent).
2.Use the “Deserialize JSON” activity and provide jsonContent as input. Set the output variable to store the deserialized JSON object or array (let’s call it jsonObject).
3.Use the “Write Range” activity to write the extracted data to a specific worksheet in the workbook. Specify the range and the data to be written.

Hope it helps!!

1 Like
4

@sandhya.govindharam

If you got the solution for your issue. Please mark it as solution to close the thread.

Regards,

5

@sandhya.govindharam

To convert a JSON file to Excel in UiPath, you can follow these steps:

  1. Use the “Read Text File” activity to read the contents of the JSON file. Provide the path of the JSON file as the input.
  2. Use the “Deserialize JSON” activity to deserialize the JSON string into a JObject or JArray variable. Connect the output of the “Read Text File” activity to the input of the “Deserialize JSON” activity.
  3. Use the “Excel Application Scope” activity to open an Excel application.
  4. Inside the Excel Application Scope, use the “Write Range” activity to write the JSON data to an Excel worksheet. Provide the deserialized JSON variable as the input and specify the range where you want to write the data (e.g., “A1”).
  5. Save and close the Excel application using the “Close Workbook” activity and “Excel Application Scope” activity, respectively.
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.