Inserting data in Excel file

I scrapped data from a website, (Book name, Author name, Book price). Now I need to store these data in excel file. But I only want to insert data in only first 2 columns for some specific rows, i.e. Book name & Author name.
How to achieve this?

Hi
Welcome to uipath community
Hope we would have got a datatable variable on data scrapping
Lest name it as Finaldt
—now use a assign activity like this
dt = dt.DefaultView.ToTable(False,”columnname1”,”cumnname2”)

Then we can specify this dt as input to WRITE RANGE activity and enable Add Headers property

Cheers @Vaibhav_Phadke

Thanks for your quick response, will try this & let you know.

1 Like

Cheers @Vaibhav_Phadke

I want to achieve this “add records to excel, having value in only some of the columns”.

1 Like

First Read range the excel where you want to update the values then use the assign activity inside the for each row to update the datatable and write range it, to see the updated datatable.
In assign use,
row(“ColumnName”) = “ScrapedValue”.

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