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 =)
Can you share current settings of GenerateDataTable? I suppose chr(9) as separator will work.
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
Thanks for the suggestion, but it’s not working for me
I have tried before but no luck. =(
If possible, can you share your data (result of GetFromClipboard) as a file using WriteTextFile activity?
Here is the file
Clipboard.txt (29.7 KB)
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)
Thanks! it’s work =) , didn’t notice the wizard not supporting Char(9), really appreciated your help
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.