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.
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
@Shanmathi Counter Modulo Will BE My Variable Right.
I Am Not Able To Get. Can You Help Me In More Detail.
What Will Be There In Then And Else inside If Condition.
@ There Are 3 xaml Files It is Really Confusing. Can You Guide Me In A simple Manner.
@Gokul_Jayakumar Can You Look Into It.
Hi @MD_Mubarak ,
Hope this might give you some idea on the use case.
ExcelRowsSplitToSheets.zip (10.4 KB)
AS I am Learning UiPath. I am Fresher. Its Really Complicated. @vishal.kp