topic RE: Issue in Write Collection (Fast) action in MS Excel VBO in Product Forum

Issue in Write Collection (Fast) action in MS Excel VBO

_Amlansahoo — Tue, 11 Apr 2023 17:26:00 GMT

Hi Team,

I am facing an issue while using Write Collection (Fast) action in Excel VBO. When there is already data in Excel and Bot is trying to write from the specific cell it's replacing the adjacent column or Row with blank values.
@ewilson Please look into the issue it seems to be a bug in the code stage.

Below is an example of the same.
Initial Value in my Excel as below image,

Now BOT is using Write Collection (Fast) to write Value in B2 as 10, then the adjacent rows and column value automatically became blank

Similarly when BOT is using Write Collection (Fast) to write Value in B2 as 10 and B3 as 5, then the adjacent column turns to blank.

------------------------------
Amlan Sahoo
Senior RPA Consultant
WonderBotz
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Thu, 13 Apr 2023 08:20:00 GMT

Amlan,

Thank you for being a SSC Blue Prism customer and for using Blue Prism.

This issue you have, does it occur also with the Get Worksheet As Collection action? I am asking to see if there is a problem across both actions. I will take a look into this today and revert back with my findings.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

_Amlansahoo — Thu, 13 Apr 2023 08:56:00 GMT

Hi Geoff,

I have not checked that but please have a look into that as well.
For now, while developing I faced this issue only for Write Collection (Fast) action.

------------------------------
Amlan Sahoo
Senior RPA Consultant
WonderBotz
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Thu, 13 Apr 2023 09:22:00 GMT

Amlan,

Having looked at the asset (latest version is 10.1.0) the Get Worksheet As Collection (Fast) action has been deprecated and left there simply for backwards compatibility. The recommendation is to use the Get Worksheet As Collection. Now, if you take a look at the updates done to this asset you will see that an update was done to this function back in February that may well resolve the issue you have.

Please let me know how you get on.

thanks.

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

_Amlansahoo — Thu, 13 Apr 2023 09:31:00 GMT

Hi Geoff,

I guess you are not understanding properly I am talking about Write Collection (Fast) not Get Worksheet As Collection (Fast) .
For Write Collection (fast) I am using latest VBO Dx and this recently got added.

------------------------------
Amlan Sahoo
Senior RPA Consultant
WonderBotz
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Thu, 13 Apr 2023 09:38:00 GMT

Amlan,

Apologies. My bad. I will examine this issue.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Thu, 13 Apr 2023 18:30:00 GMT

Amlan,

I think i have a solution for your issue. Now, as I have made other updates to the Excel VBO it will not be available until close of business Friday 14th April 2023 as I need to update documentation.

If you need the fix urgently, please let me know as the fix I have is a single line change in the code for the action.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

_Amlansahoo — Fri, 14 Apr 2023 02:02:00 GMT

Hi Geoff,

I have tried editing code but could not able to make it successful run. You can share the code I want to know the solution. Later once updated VBO will be available. I will test the scenario again and update you.

Thanks for your prompt response!

------------------------------
Amlan Sahoo
Senior RPA Consultant
WonderBotz
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Fri, 14 Apr 2023 07:37:00 GMT

Amlan,

Please see the image below and how to change the line. It's an easy change and from replicating the issue you mentioned this seemed to solve the problem. However, I will await your confirmation that we have a resolution.

I will update documentation accordingly when you confirm the issue is resolved.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

_Amlansahoo — Fri, 14 Apr 2023 08:27:00 GMT

Hi Geoff,

Thanks for your response. It's working fine now.
I hope this fix will be available in the MS Excel VBO update in DX.

------------------------------
Amlan Sahoo
Senior RPA Consultant
WonderBotz
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Fri, 14 Apr 2023 09:23:00 GMT

Hi Amlan,

That's great news. Yes this fix will be in the next release along with a new requested feature. Due to this new feature it will be necessary for QA to review the asset so it may not make it to the DX for a few days.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

_Amlansahoo — Tue, 18 Apr 2023 10:45:00 GMT

Hi Geoff,

The newly published Excel VBO has one action unpublished. "Add Criteria to Autofilter" action is not published. Could you please fix this anyway I have fixed this by myself but I think it needs to be fixed while uploading in DX.

@ewilson Please look into this issue.

------------------------------
Amlan Sahoo
Senior RPA Consultant
WonderBotz
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Tue, 18 Apr 2023 11:38:00 GMT

Hi Amlan,

Thanks for this. Not quite sure how this became unpublished but I will resolve today.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

ewilson — Tue, 18 Apr 2023 14:30:00 GMT

@_Amlansahoo

The issue has been addressed and an update has been posted to the DX.

Cheers,

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

RE: Issue in Write Collection (Fast) action in MS Excel VBO

til.minet — Tue, 25 Apr 2023 08:02:00 GMT

Hi there,

We encounter a new issue after updating the VBO to version 10.1.3. This occurs when we use the actions "Get Worksheet Range as Collection" and "Get Worksheet as Collection Offset".

Whenever we use the option "Use Header = False" we are used to the enumeration starting with index 0, e.g. Column0, Column1 etc. Now with the new version the enumeration starts at 1, e.g. Column1, Column2 etc.

This resulted in several processes crashing. Is this the new normal behaviour or will this be fixed?

Best regards
Til

------------------------------
Til Minet
RPA Developer
EWE AG Germany
Oldenburg
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Tue, 25 Apr 2023 08:09:00 GMT

Hi Til,

Thank you for being a SS&C Blue Prism customer and for using Blue Prism.

I am sorry you are having an issue with the component. I will take a look into your issue immediately and revert back to you with any issues I find. Please note, there were no changes to the actions you are having issues with in version 10.1.3.

What version were you using previously, perhaps I can compare the code between the two versions.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

til.minet — Tue, 25 Apr 2023 08:22:00 GMT

Hi Geoff,

Thanks for your fast reply and your efforts!

We used version 10.0.4 beforehand.

Best regards
Til

------------------------------
Til Minet
RPA Developer
EWE AG Germany
Oldenburg
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

til.minet — Tue, 25 Apr 2023 08:26:00 GMT

Sidenote: The changelog states that the two actions mentioned by me were modified... 😉

------------------------------
Til Minet
RPA Developer
EWE AG Germany
Oldenburg
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

GeoffHirst — Tue, 25 Apr 2023 08:38:00 GMT

Hi Til,

Indeed it does sir. Now, it seems this asset has also been updated to v10.1.4 very recently, the changelog to this version however hasn't been updated but our repository shows some updates to GetWorksheetVisibleRangeAsCollection.

Please could I ask you give me a little time to get this latest (the very latest!) version installed and I will be able to see what the differences are. For the record, I have compared the code that handles the first row as headers between your original version and that of 10.1.3 and that has not changed. So, the issue lies elsewhere. If you wish to try 10.1.4 and see if that changes anything for you that would also be useful.

I will report back to you by 12pm (my time - Scotland).

In the interim, if your investigations reveal anything else relevant please keep me posted.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Issue in Write Collection (Fast) action in MS Excel VBO

til.minet — Tue, 25 Apr 2023 08:52:00 GMT

Hi Geoff,

This morning we updated to 10.1.4 and the issue persists. Thanks for looking into this - take all the time you need.

Best regards
Til

------------------------------
Til Minet
RPA Developer
EWE AG Germany
Oldenburg
------------------------------