Convert excel to json

Help Studio
, , , ,
1

Hi All,

I have output in excel format where I need to convert into JSON format.with the help of a data table to JSON activity I am able to convert into JSON . But I want JSON file in custom manner like page count should be in array format … if I try with activity it is not converting into array how to implement this.plz guide me

2

@vaishali Can you Provide us with the Json or the Excel file so that we can understand the Scenario in a better way, You can provide us with a Sample excel file, if the Data is confidential.

Also we need to know what did you mean by Page Count in Array Format.