Copy paste range2

[mkankatala (Mahesh Kankatala)]

Use the Find First\Last row activity inside Use excel file activity and then create a variable of name LastRowValue.

After Find First\Last row activity insert this Clear Sheet/Range/Table activity to clear the specified range.

Then the error will gone… @yogitagaikwad2206

[yogitagaikwad2206]

in column name what should i give because i need column A1:CA

[mkankatala (Mahesh Kankatala)]

Give one of the column in the excel Give the column name in A or CA… @yogitagaikwad2206

[yogitagaikwad2206]

Cloumn A is present but it gives an error

This is my workflow

[mkankatala (Mahesh Kankatala)]

You have to specify the column name in the Excel not A. Give the SR as column name in the Find First/Last row activity… @yogitagaikwad2206

Hope it helps!!

[yogitagaikwad2206]

for clear sheet activity this error is come

my excel column A to CA

[yogitagaikwad2206]

Hi,
I only want copy A:CA data from output excel & paste in base file excel

[yogitagaikwad2206]

Hi can u do this using this files
Dash.xlsx (1.4 MB)
Output.xlsx (11.5 KB)

I want to copy Output file data from column A to CA & paste in Dash excel file from A to CA column. In Dash file other column data from CB I want as it is, can u do this?

[mkankatala (Mahesh Kankatala)]

Hi @yogitagaikwad2206

Follow the below steps to copy the A:CA range from Output Excel file and paste it in Dash excel file in A:CA range,
→ Use the Excel Process scope activity inside of it insert the Use excel file activity and give the path of the Output Excel file.
→ Inside Use excel file activity insert the Find First\Last row activity, and give the below parameters.

- Source - OutputExcel.Sheet("Sheet1")
- Check the Has Headers option
- Column name - "SR"
- Select the Last populated row from the Configure Last row as dropdown
- Save last row number as - Create a variable in the field called LastRowValue

→ After Find First\Last row activity insert the Use the another Use excel file activity and give the path of the Dash excel file.
→ Inside the second use excel file activity insert the Copy\Paste range activity and give the below parameters,

- Source - OutputExcel.Sheet("Sheet1").Range("A1:CA"+LastRowValue.ToString)
- Destination - DashExcel.Sheet("Base file - Claims").Range("A1:CA"+LastRowValue.ToString)
- Select the All from the first dropdown.

Check the below workflow for better understanding,
Sequence3.xaml (15.3 KB)

It is working for me.

Hope it helps!!