Creating Json from the Excel (Module- List Worksheet Rows)

I have Module- Microsoft Excel- List Worksheet Rows. I have create a data structure that helps with conversion of Excel data into JSON. But for that i had to create a Data structure and columns in the Excel sheet must align precisely with the order of properties in the JSON data structure. but I can not use the defined structure, is there any other alternative to it?

I tried to creating a variable but not able to get the name of the Header as it shows column header as A collection, and while i am setting a variable of column name it shows that the collection can not be converted into the text.(I have tried text aggregation and set variable. )

image

1 Like