I want to retrieve specific values form excel and create a json of that like let say have some data in excel with some name and want to fetch that data into json with that name ? i want to create dynamic json based on excel data
You can try below component to convert DataTable into Json file and it was developed by @sandeep13
i think you attached wrong xmal
Sorry, I didn’t change the name of the xmal file.
no i had just opened it but it was related to compress folder only not to json
This is the right file, sorry for the wrong file,
DatatableToJson.xaml (5.5 KB)
im not able to see that activity can you just take a screenshot of that send it me with properties panel ?
If you want to convert one column of a datatable to json string then use below linq query before the “Datatable to Json” activity,
" dt = NewDT.Select().CopyToDataTable().DefaultView.ToTable(False,“ColumnName”)"
and assign it to a new datatable variable.
Then pass the dt to the “Datatable to Json” activity.
see what i want to do is that i have excel data like
so i want below week my data will be updated.
Whether “variable” column name is constant???..
@Manish540 hey any answer please help …