Read data from excel and put into webtable

[ppr (Peter Preuss)]

@chiranjit.saha1
have a look here on slicing the datatable / processing in segments:

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

Split Datatable with Fixed Number of Rows

@nestor.zarallo welcome to the forum find starter help here: DTSlice_BySegmentSize_ToTableList.xaml (10.5 KB)