Convert Excel to Multilevel Json file or string

Help
1

Hi All,

I just need the possible logic and way to convert an Excel file into a multiple level json Array or string.
The excel will have carrier and Searchvalue in 2 columns and other values in the json are static(Fixed can be hardcoded)

Excel file
Carrier Searchvalue
XXXXXX XXXXXXXXXXXX
YYYYYY YYYYYYYYYYYY

Output required or expected:
{
“Queries”: [
{
“Query”: {
“SearchClass”: “Sea”,
“Carrier”: “XXXXXX”,
“SearchKey”: “c_id”,
“SearchValue”: “XXXXXXXXXXXX”,
“UpdateUntil”: “2019-05-10T00:00:00.000Z”
}
},
{
“Query”: {
“SearchClass”: “Sea”,
“Carrier”: “YYYYYY”,
“SearchKey”: “c_id”,
“SearchValue”: “YYYYYYYYYYYY”,
“UpdateUntil”: “2019-05-10T00:00:00.000Z”
}
}
]
}

Thanks a lot.

Thanks
Anil Kumar

2

have you solve this problem ?
@Anil_choudhary