Hi all, Is there a way to split this excel into 3 seperate datatables? The final output will be in step 4, which is to get 3 datatables. Read Range as dtAll in Test Sheet Count the number of Row. Get total rows in dt divide by 3 Create 3 new datatables base on result in 3. a. dt1 = row2 - 61 b…

Hi @Md_Hidayat try this Read excel file and store in datatable Assign a int32 variable a = 60 Use the while loop as below condition a<dt1.Rows.Count Inside the loop do the following a. dt_temp = dt1.AsEnumerable().Skip(a).Take(60).CopyToDataTable b. Write dt_temp into excel file c. Increment…

Spliting datatables

Help Activities

ppr (Peter Preuss) March 15, 2023, 4:20pm 2

Topic		Replies	Views
Split data table save 2 datatables Activities datatable , excel	6	1313	May 17, 2022
Split Datatable into 4 different tables Studio	6	12243	January 20, 2021
How to split data table from excel sheet Studio datatable , excel , studio	14	2483	February 19, 2022
Split the output data table into smaller data table which contain 50 rows per data table Studio studio , question , activities_panel	5	2024	December 6, 2022
How to split Data table Studio datatable , excel , selector , uiautomation , pdf , mail , orchestrator , activities , studio , data_scraping , web , string , studiox , question , activities_panel	1	2279	February 3, 2022

Spliting datatables

Related topics