How to add new column with data to Excel sheet everyday

Hi I am scraping price data for a range of products from a e-commerce site. The price scrape will happen daily

I want to add the scraped price data everyday to a master file with prices added to a new column.

  1. How do i add the price data to a new column, is it possible to make write range activity to be dynamic for coloumn as well as rows?
  2. How do i get the column header to be the date of that respective date

I have done the robot up to scraping the data and filtering the data to the few products i want using Join data table activity as filtering tool. I’m stuck with how to get the prices in to a new column everyday and for the column header to have the date

1 Like

Ho
Welcome to uipath community
Yah that’s possible with ADD DATACOLUMN activity

And to mention the date of each day as header
In add data column activity mention as DateTime.Now.ToString(“dd-MM-yyyy”)

Cheers @tharinda

Hi,

Thanks you, and thanks a lot for the response.

How do you do this in an excel, if the i want to keep on adding new columns with date header every day. If i do it this way, i will need to read the excel into data table, then add the new days data using add data column activity and then rewrite to excel. Is there a way to do this via excel?

Apologies if im asking the obvious, just started off with UIPath, and have zero programming skills :grinning: