How to Copy the specific range from one excel into another excel without column name

Help Activities
, ,
1

Im having a Excel1:
Marketing Performance copy.xlsx (7.3 KB)
Excel2:Marketing Performance Dashboard week ending.xlsx (202.2 KB)

I need to copy a R2:S4 range from Exel1 Sheet name:Sheet1 into Excel2 sheet name:Traffic Report in same range R2:S4.

Can any one please help…

2

Hi,

use a Read Range activity, then a Write Range activity. These practically fill out themselves. Just insert FilePath, SheetName, Range (“R2:S4”) and use a DataTable variable as output of Read Range and input of Write Range.

Happy Automating

3

Can you please provide xmal…

4

No, please practice yourself.

1 Like
5

Hi @keerthi_arumugam
Here is the sample workflow
Copy Range.xaml (6.1 KB)

Hope this will work for you

Let me know if you face any issues.
Its resolved your query than mark it solved

Regards
Gokul

1 Like
6

yeah sure will send you xmal file please check it,if it reach as your expectations.

7

12
12796×515 15 KB

What is the missed activity?

8

@keerthi_arumugam

Install Uipath.System.Activities in Manage packages

  • Kill Process Activity
  • Change the Excel path
1 Like
10

Hi @keerthi_arumugam

  • Install BalaReva.EasyExcel.Activities Manage packages

Here is the Update Work flow
Copy Range.xaml (10.0 KB)

image

Hope this will help you

Regards
Gokul

1 Like
11

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