How to split data table from excel sheet

[Gokul001 (Gokul Balaji)]

HI @Giriraj_Vishwas_Hande

Have a look on the thread

Split Datatable into 4 different tables

@thomasb82 lets assume following variables: [grafik] NoOfSegments is indicating how many splits we do want have Doing an integer division to find out how many rows will be in a split (we cannot fetch a rows count with fractions e.g. 14.25 rows [grafik] with following LINQ we can produce a list of datatables with the splits: [grafik] (From i In Enumerable.Range(0,NoOfSegments) Let opart = dtData.AsEnumerable.Skip(i*FullSegmentSize).toList Let spart = If(i = (NoOfSegments - 1), opart, opa…

Regards
Gokul