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

Learn Academy Feedback
, ,
1

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

2

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
3

snap
snap1366Ɨ648 127 KB

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

4

Any Help pleaseeee

5

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