Excel to JSON Conversion

hello
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

@EdGibbs @Palaniyappan @HareeshMR

1 Like

@Mayur_Pawar

You can try below component to convert DataTable into Json file and it was developed by @sandeep13

5 Likes

i think you attached wrong xmal
@Manish540

Sorry, I didn’t change the name of the xmal file.

1 Like

no i had just opened it but it was related to compress folder only not to json
@Manish540

This is the right file, sorry for the wrong file,
DatatableToJson.xaml (5.5 KB)

4 Likes

im not able to see that activity can you just take a screenshot of that send it me with properties panel ?
@Manish540

Check the screenshot download this package


Property panel,

1 Like

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.

1 Like

see what i want to do is that i have excel data like

and from that data i want numeric data to be fetch and dynamically update into my defined json like
so i want below week my data will be updated.

@Manish540

Whether “variable” column name is constant???..

1 Like

yes
@Manish540

@Manish540 hey any answer please help …

thanks
cheers :smile: