Spliting datatables

[Md_Hidayat]

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.

1. Read Range as dtAll in Test Sheet
2. Count the number of Row.
3. Get total rows in dt divide by 3
4. Create 3 new datatables base on result in 3.
   a. dt1 = row2 - 61
   b. dt2 = row 62 - 121
   c. dt3 = 122 to last row.

TestFile.xlsx (43.2 KB)

Thanks for helping out in advance!

Regards
Hidayat

[ppr (Peter Preuss)]

Process repeated for each multiple rows

@christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Segmentsize: 3 Following Building Blocks are used Calculation of the numbers of segments: [grafik] with the Ceiling method the fractions are uprounded to the next Integer with the Skip() and Take() Method the Rows for a segment can be retrieved. the different segments are bult by following [grafik] and do fetch the different segment rows by: …

[NIVED_NAMBIAR (NIVED N)]

Hi @Md_Hidayat

try this

1. Read excel file and store in datatable
2. Assign a int32 variable a = 60
3. 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 a= a+60

Let me know if it works

Thanks & Regards,
Nived N

[Md_Hidayat]

Thanks for the quick reply!

I tried your method. Is it possible to save the into 3 datatables to enable parallel processing?

Regards
Hidayat

[ppr (Peter Preuss)]

Yes,maybe need some little adaptions. But the building Blocks and the main Idea would be the same

[Md_Hidayat]

Thanks @ppr and @NIVED_NAMBIAR for pointing the correct direction.

I’m able to mix and match both of you guys solutions.

Regards
Hidayat