Hi Experts… Let’s assume i have 2Lakh records in Excel (This is dynamic). Some times we may get 1Lakh50Thousand as well. I need to divide the range. Assume 350 (This is also dynamic, I will decide the records manually. As of now lets consider 350 ) Rows and dump this in to new excel with headers… …

Hello @Unknown_User Kindly refer to this updated Flow Refer FinalRange2.XAML file Forum_ExcelSplitRangeWrite.zip (178.9 KB)

Divide the range in excel

Gokul_Jayakumar (Gokul Jai) September 14, 2022, 1:04pm 6

@Unknown_User
Kindly update the conditions in flow decision

DtDymanic.Rows.count=0 or String.IsNullorEmpty(DtDymanic.Rows(0)(0).ToString)

Topic		Replies	Views
How to split particular range row and update value in each split in excel Activities datatable , excel , activities , question	7	395	May 9, 2023
How to split 2 data table from single sheet Activities excel , activities , question	4	615	September 4, 2022
Excel rows division Activities excel , activities , question	3	1213	November 30, 2021
How to copy set of records to new sheet Studio studio , question , activities_panel	8	918	September 17, 2022
Read Range activity - Excel Help	3	1234	September 25, 2019