Split excel file with dynamic row count

[dhouha.cherif]

Hello Everyone
I have a daily excel file to work with (with variable row count ).
I need to split this file into multiple files ( every 1000 line in a file or data table)
How can i do it with a dynamic row count

[Anil_G (Anil Gorthi)]

@dhouha.cherif

If you read the data into datatable…

Then you can use the following two function in a loop to get or skip

Dt.AsEnumerable.Take(1000) will get first 1000
Dt.AsEnumerable.Skip(1000) will skip the first 1000 records

Repeat this in loop …end the loop when the count is reached to dt.rowcount

Cheers

[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: …

And also:

Split the output data table into smaller data table which contain 50 rows per data table

can be done with skip take: in the combination with copytodatatable split results are datatables: In Additiona to above find a compacted variation: Assign Activity: SegmentSize | Int32 = 50 Assign Activity: NoOfSegments | Int32 = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize)) Assign Activity: TableList | List(Of DataTable) = Enumerable.Range(0,NoOfSegments).Select(Function (x) dtData.AsEnumerable.Skip(x*SegmentSize).Take(SegmentSize).CopyToDataTable).ToList() For each…