Data Table - How to create a data table with some specific column names & add data into the Data Table

My requirement,

I need to create a fresh Data table of two columns header (Name, Designation).
Later I need to add some data into it using column header.

How we can achieve this using UI Path. If possible add sample xaml file.

@Palaniyappan @Lahiru.Fernando

Hello

Use Build Data table activity
then use for each row inside use add data row activity to add rows into the table
and outside for each row use write range and pass your datatable.

Thanks
@Ashish6541

1 Like

Hi @Ashish6541,

Use Build datatable activity click edit(Datatable button) to add columns or rename the column names
And use Add data row activity to add values to the datatable

2 Likes

Hi @Ashish6541

1.Use Build Data Table Activity click Data Table there enter your column names and enter data.

2.In properties create output data table variable.

3.Use write range activity and pass the path of excel file where you want to save and pass data table variable and then in properties check add headers.

Please find below attached workflow.

BuildDataTable.zip (18.9 KB)

Regards,
Kommi Jeevan.

Thanks @kommijeevan

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.