Office 365 Excel VBO - Get Worksheet As Collection' Errors

[MatHanley]

There seems to be quite a few errors with the 'Get Worksheet As Collection' action in the 365 Excel VBO - I've not yet been able to get it work. It seems to be some issues with the getting the JSON to collection steps. Here's some errors I've had so far. 

When offsetting the lookup:

"Internal : Could not execute code stage because exception thrown by code stage: Unexpected character encountered while parsing value: T. Path '', line 0, position 0. "

Action: "Parse Row Count & Col Count"

When not offsetting the range:

"Internal : Could not execute code stage because exception thrown by code stage: Unable to cast object of type 'System.String' to type 'System.Data.DataTable'."

Action: "Get Text Collection"

------------------------------
Mat Hanley
------------------------------

[ewilson · Accepted solution]

@MatHanley

Have you tried downloading the latest version of the Utility - JSON VBO from the DX?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[ManpreetKaur1]

Hi @MatHanley ,

Are you trying to get the filtered data in collection or the unfiltered one?
Also, are you facing the issue only with this action or other actions as well (e.g. get worksheet range as exception, get worksheet as collection fast etc.)

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

[MatHanley]

Oh my, that fixed it. 

We had the latest version, but with a different name/ID as I was meant to compare them with the objects we had so we didn't overwrite custom changes we made but the JSON VBO had been missed!

Replaced the VBO with the new version and it's perfect. Thank you! 

------------------------------
Mat Hanley
------------------------------