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:02am 2

@fairymemay - Please check this post…and try as mentioned…

Topic		Replies	Views
How to separate excel file if data have > 200 rows? Activities excel , activities , question	8	1207	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	2269	February 3, 2022
Trying to create separate Excel files of 500 rows with a single datatable of 10000+ Studio excel	2	1600	February 17, 2021
Split excel files if they exceed 500 rows Studio	3	2077	November 9, 2020
How to split data table from excel sheet Studio datatable , excel , studio	14	2455	February 19, 2022

Separate excel file if data have > 200 rows?

Related topics