Json array to excel

[saravanan.c]

Hi all,
i need to write the json array values in the excel. while writing in excel it is throwing duplicate column name exist because am converting by key as column name and value as row for every iteration it is considering as “column name already exist”. how to resolve it or if you having alternate approach kindly share it.

Thanks in advance.

[Srini84 (Srinivas)]

@saravanan.c

You can build a datatable and fix the column name, once you added the data, use write range activity to write to excel

Hope this may helps you

Thanks

[saravanan.c]

@Srini84 thanks for the reply actually the solution you have given has already done and am getting the answer for it too. but for dynamic response means this method won’t work right…

[saravanan.c]

Hi all,
@Srini84
please find the below link for my solution this solution is satisfying my question

Add Data Column: Object reference not set to an instance of an object

@abdouaziz Find an updated version now handling multiple within an JArray abdouaziz_V2.xaml (11.9 KB) Your JSON sample was not valid and required the surrounding to be a JArray. This updated file is sent to you by message.