How do I copy a set of values from excel and paste it into a data table online?

For example, I would like to copy this column of values from D1:D15 to a data table in a website.

How do i do it ?
Thanks!

Hi @LYKE

Use datatscrapping feature in Uipath to scrap the particular column and add to datatable

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

2 Likes

Hi @LYKE When you read a value from excel , UiPath saves it in data table format only. Once the data is saved in the data table, you can either directly pate the data in the web data table or run a loop and paste the data 1 by 1.

2 Likes

Hi,

For reading data from an excel, you can use the Read Range activity https://docs.uipath.com/activities/docs/excel-read-range, while for pasting your data you can use Type Into activity https://docs.uipath.com/activities/docs/type-into

However, if you would like to add your datatable read from your excel file into a table from your website database, perhaps the following thread can help you https://docs.uipath.com/activities/docs/insert-data-table

Best regards,
Marius

1 Like