Not pasting data into website

[supermanPunch (Arpan)]

Hi @Laura2 ,

Could you maybe take a look at the below post. It has a Linq Implementation on Segmenting the Datatable based on Segment Size (For your case 30000). You will get the Output as list of Datatables each with the 30000 rows.

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

Also, Once you have read the Excel sheet, you can keep the remaining activities outside the Excel application Scope, Just to keep the Excel scope related activities separate.

Let us know if you were able to understand and implement the approach.