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

[_Amlansahoo]

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

[_Amlansahoo]

Okay Thanks Eric !

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

[GeoffHirst]

Gentlemen,

After much deliberation on how best to proceed, I am pleased to say we have a new version that will be available from the DX, as soon as it makes it through QA.

Version 10.1,5 should see everyone happy. Thanks for your assistance in bringing this to us and helping us get a resolution.

Please report back to this thread how this update works for you.

regards

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

[_Amlansahoo]

Hi, @GeoffHirst @ewilson  Thanks for making the changes and accommodating both new and old ways in the same code. It really works great for me.
Actually, this is a problem for Till better if he can take a call.

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

[til.minet]

Hello there,

A big thanks to all you guys for resolving the matter in such a pace! 

Unfortunately I am to blame for misspelling the former column names. Instead of "Column0", "Column1" etc. it formerly was "Column 0", "Column 1" etc and so on. 

I hope this won't make too much of an effort to fix again?

Best regards
Til

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

[kray1642]

Hello Til and Amlan,

I am working on developing a solution to keep the outputs the same while preserving the new method for "Get Worksheet as Collection Offset" and "Get Worksheet Range as Collection".

After looking at previous versions of this VBO, it appears that "Get Worksheet as Collection" followed the pattern "Column1, Column2, Column3..."
and "Get Worksheet as Collection Offset" and "Get Worksheet Range as Collection" followed the pattern "Column 0, Column 1, Column 2...".

Before sending out an update, are these the column headers you are looking for?

Regards,

------------------------------
Kennadee Griggs
------------------------------

[_Amlansahoo]

Hi Kennadee,
Thanks for taking this up. Yes that's the correct resolution.

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

[til.minet]

Hey Kennadee,

Agreed - Amlan is correct. Thanks for clarifying!

Regards
Til

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

[kray1642]

Til and Amlan,

The latest release (10.1.6) is now available on the Digital Exchange.

I am happy to help if anything new comes up during testing. 

Thank you for bringing this to our attention.

Regards,

------------------------------
Kennadee Griggs
------------------------------

[RománSánchez_Pé]

Hi Everyone,

I'm facing another issue with this action.
When using Write Collection (fast) does not maintain the same Cell Format as you can see in the attached picture:

Inserted Values:

Collection Values:

Please check the field "NET INCOME" & "Exchange Rates"
Using the regular action "Write Collection" I don't face this issue.

Is there a solution for this?

Thank you & Kind regards,

------------------------------
Román Sánchez
RPA Developer
------------------------------

------------------------------
Román Sánchez Pérez
------------------------------

[GeoffHirst]

Hi Roman,

Thank you for being a SSC Blue Prism customer and for using Blue Prism. I am sorry you are experiencing issues with the Excel VBO Asset.

Now, the problem you highlight, I think may have been raised earlier this year. So, before I go diving into code and trying to replicate your issue, could you tell me if you are on the latest version that is on the DX which is 10.1.10. If you are, then we need to delve a little deeper, however your issue does look similar to one I corrected earlier this year.

Please come back to me with your findings.

regards

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