I need to copy the 1st 500 rows from a spreadsheet and paste in an ERP application. Then move on to the 501st line and copy the next 500 rows and so on.
How do I achieve this in UiPath Studio? I am storing all the rows in a datatable.
sb = new StringBuilder()
For each - dt.Select.Skip(500).Take(500)
{
sb.Append(String.Join(Convert.ToChar(9), row.ItemArray)+Environment.NewLine)
}
Set to clipboard - sb.ToString
Thanks @whyyouandi. But when I tried to paste (using send hotkey - ctrl + v) the first 500 rows in the ERP application, some XML code got pasted instead of the actual data. Am I supposed to use some clipping region activity to achieve this?
@whyyouandi Yes it works when you paste it manually.
I checked and it looks like rows are not getting copied from the excel using select range and hotkey. Can you please check your code once? Thanks!