Overwrite in Excel with an adaptable range

Help
1

Hi,

I am downloading an Excel file each day. For each day, several lines will be added to the Excel file and the existing ones will be updated. So the Excel file both changes in values and gets bigger in time.

The Excel file covers the previous month and the current month.

Here is my question
How can I make UiPath overwrite the data from the same days, but when we enter a new month, the overwriting-range should move accordingly, so that new dates will be added while UiPath only overwrites the data from the previous and current month?

2

Hi @Karsten_Bertelsen

Have you used Write Range which sets the overwrite property

Thanks
Ashwin S

3

Hi Ashwin S,

Yes, I am trying to use the write range, but how can the range be adaptable?

So that when we go from August into September, the range in Write range should change to the first cell in Excel that contains a date within August?

4

Hi @Karsten_Bertelsen

You can set the range as empty and use overwrite property

Thanks
Ashwin S

5

Hi Ashwin S,

How will an empty range know to write in cell “A620” if this cell is the first cell in column A that contains a date within August?

6

Hi @Karsten_Bertelsen

With an empty range we can define how many rows and columns can be define

if not mention the Range as A1:A+Dt.rows.count.ToString

Thanks
Ashwin S