Please need yours help i have excel sheet and i want copy data From Column C and past in last column with header today date

Please need yours help i have excel sheet and i want copy data From Column C and past in last column with header today date
please check snap and xaml

please dears need your help
@nimin

insercolumn.xaml (11.3 KB)

Hii @Mohamed_Abbas,

Please have a look at the workflow. copy_column_date.xaml (10.9 KB)
This will copy the column C to a new column with today’s date as header. Change your system date when testing the workflow multiple times on the same day, otherwise the header will duplicate.

Warm regards,
Nimin

@Mohamed_Abbas
Use read range activity to get the data to datatable( dt ) .

Then use assign activity
Dt=dt.DefaultView.ToTable(false,"columnname")

Use write range to write it in ur excel sheet.

Dear @nimin

thanks for your solution realy appreciate your support it’s working fine but actuly it’s like copy cell by cell there is now way to copy all column then past to faster than now
tha nks dear for your support

thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.