Is it possible to add values to a column until the last row in excel sheet? n

Help
1

Hello All, i am trying to automate a process in which i have to add current date inside an excel sheet until last row of the sheet. here is the scenarion

There are 4 columns: DATE1 ,DATE2, DATE3 ,DATE4 I want to append these columns with current date. once its appended, i want the file to be saved as it is.

how is this possible to do. PLEASE HELP!

2

Hi @Saad_rehman

Use read range activity and give the range as empty
Use append range based on current date

Thanks
Ashwin.S

3

as of my understanding, you need to add current date as a last record of an excel file
Simply you can use append range activity it appends the data to the existing.

4

If i do so will it not append the whole sheet with current date? i have other columns as well in the sheet which i dont want to change

5

Hi @Saad_rehman

As Karun said in append range activity we have an option overwrite so if you check the property it won’t affect anything

Thanks
Ashwin.S

6

@Karun i dont want the last record to excel file. What i want is to current data to all rows and all columns (the column are 4 out of total 8 columns)

7

with the Append Range activity i am not sure how the Data Table works

8

when i try to give empty as Range. This is the error i get

Message: object reference not set to an instance of an object

9

hI @Saad_rehman

Can you try specifying the range by hardcoding it

Thanks
Ashwin S

10

yes i can do that but when i do so the only way it works is when i specify the exact cell and don’t work for the whole column. for example, when i write M2 in Range. it only appends the row in M2 and not the whole column. what i want to automate is to add a date in all rows for all 4 columns as mentioned in my first message

11

Hi @Saad_rehman

Use Append range and write date based on current date with range as “A2:D300”

Thanks
Ashwin S

12

so you are saying to not use read range activity and only use Append Range?

13

Hi @Saad_rehman

Use both read range and append range and give the same range what you have given previously for append range

Thanks
Ashwin S

14

I am getting same error as i mentioned earlier, can you please share xaml of this task ?