Hi All,
Currently i have my UiPath to control my APP and copy the Grid into clipboard.
Normally there’s no issue if i just Crontol + V paste into Excel, everything will be in position.
But when using uipath, i have use “get from clipboard” and “generate Data Table”, but the data table that write to excel are incorrect, all column is not correct (Some of them merge).
here’s my print screen about my message String
Normal Copy Paste will be like this
UiPath Incorrect Copy.
And i trying to custom the column seperator, but still not wroking. Any advise? appreciate the help =)
Yoichi
(Yoichi)
April 16, 2022, 6:44am
2
Hi,
Can you share current settings of GenerateDataTable? I suppose chr(9) as separator will work.
Regards,
Hi
Instead of copying the grid and then pasting it you can use DATA SCRAPPING method to scrape that grid and have it as a datatable
Then you can write that datatable to a excel with simple WRITE RANGE activity
Have a view on this on how to use data scrapping with an example
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
Cheers @Likesh_Lim
1 Like
Hi Yoichi,
Thanks for the suggestion, but it’s not working for me
My Setting
the outcome
Hi Palaniyappan
I have tried before but no luck. =(
Yoichi
(Yoichi)
April 16, 2022, 5:43pm
6
Hi,
If possible, can you share your data (result of GetFromClipboard) as a file using WriteTextFile activity?
Regards,
Hi Yoichi,
Here is the file
Clipboard.txt (29.7 KB)
Yoichi
(Yoichi)
April 17, 2022, 4:51am
8
Hi,
Wizard of GenerateDataTable activity doesn’t support TAB character (chr(9)) as input. So it works in actual workflow. Can you try the following sample, then check result xlsx?
Sample20220416-1.zip (4.5 KB)
Regards,
1 Like
Hi Yoichi
Thanks! it’s work =) , didn’t notice the wizard not supporting Char(9), really appreciated your help
1 Like
system
(system)
Closed
April 20, 2022, 5:31am
10
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.