How to copy single row range like (A1-Z1) from one excel and paste into other excel

Help Studio
, ,
1

hello guys,
I want copy single row range like (A1-Z1) from one excel and paste into other excel .after paste the data I want do format painter on that pasted data … if any solution please help.

2

HI @Rahul_Thombare

  1. Use Read Range activity Range → “A1:Z1” Store it as Dt1

  2. Use Write range activity → Pass the Dt1

Regards
Gokul

3

HI @Rahul_Thombare

Checkout this steps

Enable modern in the filters

image
image354×601 14.3 KB

  • Excel process scope
    • Use Excel File for source (Pass your path)
      • Use Excel File for Desitination (Pass your Path)
        • Copy/Paste Range
          • Source Range will be Excel.Sheet(“SheetName”).Range(“A1:Z1”)
          • Destination Range will be Excel1.Sheet(“Sheet Name”).Range(“A1:Z1”) or Excel1.Sheet(“Sheet Name”).Range(“A1”)
          • Select What to copy as All
            image

Here
Excel refers to source excel
Excel 1 refers to destination excel

image
image601×898 24.8 KB

Hope this Helps

Regards
Sudharsan

4

Gives error like, range does not exit . i am giving like (“D1-P1”)

5

Look at his screenshots. The modern activities don’t take strings as the properties, they take objects now.

ExcelVar.Sheet(“Sheet Name”).Range(“D1-P1”)