05-08-19 03:35 PM
Using Blue Prism on an Excel Worksheet how can I insert a new column before an existing column containing a known title/name, without knowing that columns location in the Worksheet?
Example: In an Excel Worksheet containing a range of A1:Z15 (i.e. a dataset of 15 rows in 26 columns, or from column A, row 1 to column Z, row 15) insert a column before the one named 'Percentage'. You will not know the index of the column.
--------------------------------------------------11-06-20 07:14 PM
21-12-20 12:49 PM
Dear Eric,
I'm trying to achieve the same, but my version of MS Excel VBO doesn't seem to have the "Insert Column" action.
We're on BPv6.4 currently...
Could you mabye send me the latest version of MS Excel VBO or tell me where I could download that?
Many thanks & regards
Astrid
21-12-20 03:05 PM
@astrid.stollberger the latest version of the base MS Excel VBO is available here:
https://digitalexchange.blueprism.com/dx/entry/9648/solution/ms-excel-blue-prism-utility
There's also the "Extended" version of the VBO that includes additional features/functionality. That's the one that includes the "Insert Columns" logic. It can be found here:
https://digitalexchange.blueprism.com/dx/entry/9648/solution/ms-excel-vbo---extended
Cheers,
------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------
21-12-20 03:23 PM
Dear @ewilson,
many thanks - I was actually searching the DX for it but didn't find it on the first results page and didn't realize there were more pages...
Thanks a lot!
------------------------------
Cheers Astrid
------------------------------