Copy Pasting Data From One Sheet To Another

Help Activities
, ,
1

I have 300 rows Of Dummy Data. I Need To Take First 25 Rows Copy And Paste It Into A New Excel Sheet. I should Continue The Process Untill The Last Row. 25 25 etc In Each Sheet. Can Anyone Help Me With This.

2

Hi @MD_Mubarak,WELCOME
Here is the workflow,

- Read Range (input: source excel file)
- For Each (input: read range data)
  - If (condition: counter modulo 25 = 0)
    - Create Workbook (input: file path)
    - Write Range (input: current 25 rows, destination: created workbook)
  - End If
  - Increment counter
- End For Each
1 Like
3

@Shanmathi Counter Modulo Will BE My Variable Right.

4

@Shanmathi
I Am Not Able To Get. Can You Help Me In More Detail.

5

What Will Be There In Then And Else inside If Condition.

6

Hello @MD_Mubarak , Welcome to UiPath Community
Refer this sample flow, you may get some idea
Forum_ExcelSplitRange.zip (6.2 MB)

1 Like
7

Can You Guide Me In A simple Manner.

8

@Gokul_Jayakumar Can You Look Into It.

9

Hi @MD_Mubarak ,

Hope this might give you some idea on the use case.
ExcelRowsSplitToSheets.zip (10.4 KB)