Json array to excel

Help Studio
, ,
1

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.

2

@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

3

@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…

4

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

5

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