Not pasting data into website

[Laura2 (Sol)]

I am trying to take the first 30,000 rows only in Column A and paste into a website. Then take the next 30,000 or less rows in column A and paste into the website again. This is what i have so far but I am not successful in it copying any data to paste. (i am a beginner)

(i used a filtered data table because I only want to copy the first column of data and not the other columns. There are 34,000 rows in the first column so i need to copy the first 30,000 and paste and then go back and take the remaining amount and paste that dynamically b/c the count will vary.

rowCount = dtData.Rows.Count
dtBatch= dtData.AsEnumerable.Take(30000).CopyToDatatable
dtData = dtData.AsEnumerable.Skip(30000).CopyToDataTable

rowCount = dtData.Rows.Count

[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.

[Anil_G (Anil Gorthi)]

@Laura2

Basically inside your for loop you are sending key shift+f12 but the value is not being sent…

Manually how do you paste the value?

And do you need to paste all the roes at once into the field?

If yes then use set to clipboard activity and assign the complete data to clipboard String.Join(Environment.Newline,dtbatch.AsEnumerable.Select(function(x) x(0).ToString)) this will join whole of the column with newlines and convert it into string and assign to clipboard

Now you can use ctrl+v to paste the data from clipboard to the field you need

Cheers

[Laura2 (Sol)]

Thank you! that works. I am having an issue with it copying all the data again and not skipping the rows that was already posted to the clipboard. Do you think I have the assign activity (dtData = dtData.AsNumerable.Skip(30000).CopyToDataTable in the wrong location?

[Anil_G (Anil Gorthi)]

@Laura2

Yes…may be use it immediately after take…so that it skips…for next iteration if used in loop

Make sure data is not read again else the rows would come back

Cheers

[Laura2 (Sol)]

Ah ok thank you so much!