Can i create a table using json or xml

i want to create a table where the input will different for each time running the bot …without using Excel i want to create the table without using excel …
Is there is any possibility we can create the table using JSON or XML

1 Like

yah thats possible by converting the JSON file to csv and converting the CSV file to excel using Read csv file whose output is a datatable which can be written to a excel with write range activity

but may i know the reason why we need to do so like we are avoiding excel way of creation which is a very easy and feasible one
Cheers @Karthikeyan34

Hello,
In this video I do a lot of stuff with JSON (Chapter included) :

0:45 Install Deserialize JSON
1:10 Present all types of JSON that will use
1:35 Deserialize simple JSON
2:50 Deserialize a JSON with an Object inside
3:55 Deserialize a JSON with Array inside
6:00 When we use Deserialize JSON Array activity
7:00 Deserialize a JSON with a List of Strings inside
9:45 Create a simple JSON
11:05 Create a JSON with an Object inside
12:17 Create a JSON with Array inside
14:05 Create a JSON with a List of Strings inside
15:55 Datatable to JSON
17:50 JSON to Datatable

Thanks,
Cristian Negulescu