Excel to JSON Conversion

Help
, , ,
1

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
2

@Mayur_Pawar

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

https://go.uipath.com/component/datatable-to-json-string

5 Likes
4

i think you attached wrong xmal
@Manish540

5

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

1 Like
6

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

7

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

5 Likes
8

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

9

Check the screenshot download this package

DtToJsonPackage
DtToJsonPackage1363Ă—725 58.5 KB

Property panel,
PropertiesPanel
PropertiesPanel335Ă—571 6.03 KB

1 Like
10

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
11

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

Screenshot (67)
Screenshot (67)650Ă—1075 31.4 KB
and from that data i want numeric data to be fetch and dynamically update into my defined json like
Screenshot (69)
Screenshot (69)1012Ă—1075 13 KB

so i want below week my data will be updated.

@Manish540

12

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

1 Like
13

yes
@Manish540

14

@Manish540 hey any answer please help …

thanks
cheers :smile:

15

Hello,
In this video I do a lot of stuff with JSON (Chapter included)
15:55 Datatable to JSON
17:50 JSON to Datatable

Thanks,
Cristian Negulescu

2 Likes