Update to MS Excel VBO Posted

[ewilson]

All,

An update has been posted to the Digital Exchange for the MS Excel VBO. The new version is 6.10.4. You can find it at the following link:

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

The new version includes the following 3 new actions:

• Autocalculate
  • Provides the ability to disable/enable the Auto Calculation feature of Excel. This can be used in cases where you experience issues with calculations in large workbooks causing things to slow down when you update cell(s) linked to those calculations.
• Format Range
  • The VBO has had actions for formatting individual cells, but this action will allow you to change the formatting of a range of cells (ex. an entire column).
• Text to Columns
  • This action can be used to take the contents of a single column, where the cells contain delimited data, and expand that delimited data to multiple columns. As an example, the following column of comma delimited data could be parsed and expanded to two columns (Last Name and First Name). 

Before

After

#Excel #VBO

Cheers,

​​

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

[lookman]

Thanks Eric for the update.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------