Hello,
my requirement is to copy data from excel rows from A1:A2000 and write in webpage textbox.
but when i am trying this it is writing on by one row in textbox not copying whole data in one go.
i am reading data using read range then converting dt to string using output data table activity and then using classic type into activity passing then converted text value in it.
help me on same
as there are more than 1000 names it is taking time to write one by one name
help me on same
in latest type into activity you have an option to use clipboard which pastes the data directly instead of typing try the same
or if you have only old activities then use set to clipboard to set the data to clipboard and then use send hotkeys to send ctrl+v
also if you are using hardaware events you can switch to chromium api or simulate
cheers
I have tried with new type into activity but issue is it is giving selector error
Please show what selector error are you getting
first try to refine or use a stable selector
also you have second way to set to clipboard and the use send hotkeys
cheers
i have only kept chome in window selector.
actually it is one woindow opening after clicking one button in webpage and there i ned to write names in one shot u can see screenshot
properly validating as well
tryed with hardware event,simulate and chromium api but nothing worked same error
so are there two windows?
one main and another is this sub window?
then its window selector issue..you need to use a separate use app/browser indicate second window make it unique as both windows are chrome and then can be used
cheers
The reason it’s pasting one row at a time is because Output Data Table converts each row separated by a newline but Type Into sends each line separately, depending on the webpage textbox behavior.
To paste all 2000 rows in one single shot, try one of the following methods
Instead of converting the whole DataTable, simply join the values from column A:
textToPaste = String.Join(Environment.NewLine, dt.AsEnumerable().Select(Function(r) r(“A”).ToString()))
Then use Type Into → Simulate Type = ON.
This pastes everything at once into the textbox.
1. Read Range → dt
Clipboard.SetText(String.Join(Environment.NewLine, dt.AsEnumerable().Select(Function(r) r(“A”).ToString())))
3. Use Type Into:
Ctrl + V
This is much faster for thousands of rows.
Best method when there are 1000+ rows — pastes instantly.