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
Main.xaml (7.3 KB)
I need Help that i want every day copy Column (C) form excel sheet and Append to anthor sheet with today date
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)
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
thanks for your support any help please because that i’m stack in this steps in my project
thanks dear for your support