topic RE: Office 365 Excel VBO - Get Worksheet As Collection' Errors in Digital Exchange

Office 365 Excel VBO - Get Worksheet As Collection' Errors

mat-tvp — Wed, 22 Feb 2023 09:21:00 GMT

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
------------------------------

RE: Office 365 Excel VBO - Get Worksheet As Collection' Errors

ewilson — Wed, 22 Feb 2023 21:30:00 GMT

@mat-tvp

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
------------------------------

RE: Office 365 Excel VBO - Get Worksheet As Collection' Errors

ManpreetKaur1 — Thu, 23 Feb 2023 08:11:00 GMT

Hi @mat-tvp ,

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
------------------------------

RE: Office 365 Excel VBO - Get Worksheet As Collection' Errors

mat-tvp — Thu, 23 Feb 2023 09:05:00 GMT

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
------------------------------