I want to check data if data have >200 row —> separate sheet data 1-200 row , 201-400 ,until end. But if data <200. not change file input.xlsx (11.8 KB) output : input_1.xlsx (9.3 KB) input_2.xlsx (9.3 KB) input_3.xlsx (7.9 KB)

@fairymemay - I have found another thread where PPR provided different approach … Split_Datatable_Rows.zip (48.1 KB) Run this workflow as is, you will see 3 files will be created in the project folder…I have just added couple of steps and created the output… Here is the reference to the post… …

Separate excel file if data have > 200 rows?

Help Activities

prasath17 (Guru) August 4, 2021, 3:15am 4

@fairymemay - Have you downloaded the xaml file?

Split CSV File into multiple files according to File Size

Topic		Replies	Views
How to separate excel file if data have > 200 rows? Activities excel , activities , question	8	1202	August 7, 2021
How to split Data table Studio datatable , excel , selector , uiautomation , pdf , mail , orchestrator , activities , studio , data_scraping , web , string , studiox , question , activities_panel	1	2267	February 3, 2022
Trying to create separate Excel files of 500 rows with a single datatable of 10000+ Studio excel	2	1579	February 17, 2021
Split excel files if they exceed 500 rows Studio	3	2023	November 9, 2020
How to split data table from excel sheet Studio datatable , excel , studio	14	2450	February 19, 2022

Most Active Users - Yesterday
ashokkarale
Anil_G
ppr
SorenB
sharazkm32
k.sakaguchi0804
sven.wullum1
supermanPunch
sonaliaggarwal47
basavarajbennur07
More details...

Separate excel file if data have > 200 rows?

Related topics