Hello great community,
I’m copying the data (includes tables and text) from a website using
Ctrl + A. Now the data is on Clipboard.
Manual: When I’m pasted into a word document using Ctrl + V. The way it looks in the website got reflected in the word document.
Robot: I created a sequence to append the clipboard text into the word document using Word application scope-> append text. But, the tables and formatting didn’t reflected in the word document except broken pieces of text.
What is the ideal approach to copy and paste the data into the word document?
Thank you in advance.
Have the robot do it the same manual way.
I am preferring the background processing of the task instead of coming up with the challenge like Open/use application and then activating the window, pasting and saving the document.
I assume you are using the UiPath Word Activities, right?
Try getting the text from the clipboard, putting it to a string variable, and then use the append the text to the word document.
I have done as mentioned above. But I’m losing the formatting like tables.
Can you send me an exemple of how you want it to show on the document and how it`s showing? Or even send me the text you want to put in there so I can run some tests here.
Did you try right click and choose paste with formatting?
Word application scope-> append text .
It’s a background process. So, I didn’t tried that.
can you try this one ? In this package, it has an activity called
in the video , you can get the explanation.
I have uploaded a new package for word automation. I hope it will be very useful to make easy automation. And also very soon you will expect more activities in this package. Now it has the below activities.
Package Search Key Word in manage and package : balareva.word
Find Replace - Find and replace the entire document
RemoveDisplayLineNumber - Remove the display line number
WordStatistics- Obtain WordCount, Total Pages,Total Lines,Total Characters,Total CharactersWithSpaces and To…
This is why you have to just do it the manual way. None of the activities get the text from the document with formatting included.
Yes. Finally I have gone through manual way.
Thank you all for your suggestions. All are acceptable.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.