@Daniyal_Tahir
Logic is same a described in the links. It is just modified to write out the Excel Sheets
Variables:
Flow:
Statements:
NoOfSegments = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize))
segment = Enumerable.Range(0,NoOfSegments).ToList
RowSet = dtData.AsEnumerable.Skip(segment*SegmentSize).Take(SegmentSize).toList
Find starter Help:
SplitTable_BySegmentSize_ToTable_WriteSheet.xaml (13.0 KB)