Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Worksheet Range As Collection

MartinReuter
Level 4

‎16-02-23 03:33 PM

Workaround: The action from Excel VBO is copying the range from Excel into the Clipboard and is then trying to parse it via ParseDelimSeparatedVariables. Even though the function fails the data remains in the clipboard. So one can use the GetClipboard action in Utility - Environment and then parse it using Utility - Strings (DX 10.0.0)... Hope this helps anyone



------------------------------
Martin Reuter
------------------------------
3 REPLIES 3

ManpreetKaur1
MVP

‎17-02-23 09:37 AM

Hi @Martin Reuter ,

Thanks for sharing your observation and the workaround.



------------------------------
Manpreet Kaur
Manager
Deloitte
*If you find this post helpful mark it as Best Answer
------------------------------
0 Likes

Neel1
MVP
In response to ManpreetKaur1

‎17-02-23 03:30 PM

hello @Martin Reuter - Thanks for the workaround but what issue you observed by going via the normal way.



------------------------------
Neeraj Kumar
Technical Architect
------------------------------
0 Likes

MartinReuter
Level 4
In response to Neel1

‎17-02-23 05:04 PM

Hi Neeraj, the action is not working as I described above. The action fails to parse the clipboard content correctly and returns empty collections instead. - Sure, one could incorporate the parsing directly into the code stage of the action, but this is no good idea as you then take away the pros of RPA (no coding unless you are working for BP ;-))



------------------------------
Martin Reuter
------------------------------