I need Help that i want every day copy Column (C) form excel sheet and Append to anthor sheet with today date

Dear All
every day i there data in excel sheet i want to copy Column © from this sheet and Appen to anthor sheet with today Date
i try to read range Column © and use Read Range activity but nothing thappen and give me error
please check snap and XAML
thanks
Main.xaml (7.3 KB)

You can get the column c value by index with this:

Fdt(Fdt.Rows.Count - 1)(2)

This works dynamically regardless of how many rows are in the source spreadsheet.

Then you should create a new data table that is the same format as your target spreadsheet, add a row that includes the current date and column c value, and append range to the target spreadsheet using the new data table.

I have attached a working example.

20190118_CopyAndAppendExcelColumn.zip (24.4 KB)

1 Like

Hi @tjust
Thanks for your help dear but no if i want Copy Column C and past in same excel as show in photo
and also in your xaml that i need to Write line activity
thanks for your help

Any Help pleaseeee

Hi @tjust

thanks for your support any help please because that i’m stack in this steps in my project

thanks dear for your support