topic RE: Insert Column in Excel Worksheet using Blue Prism in Product Forum

Insert Column in Excel Worksheet using Blue Prism

Digital_WorkerB — Mon, 05 Aug 2019 14:35:00 GMT

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.

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by kishore kumar R.

RE: Insert Column in Excel Worksheet using Blue Prism

ewilson — Thu, 11 Jun 2020 18:14:00 GMT

Hello Kishore,

I haven't done this myself, but I imagine you could cycle through the cells using the actions Get Active Cell Value and Go To Next Cell from the MS Excel VBO - Enhanced. Then you would check the value of the cell until you find the one with the header name you're interested in. Once you have that you know what column it is, so you can then use the Insert Column(s) action to insert the new column.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Insert Column in Excel Worksheet using Blue Prism

astrid.stollberger — Mon, 21 Dec 2020 12:49:00 GMT

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

------------------------------
Cheers Astrid
------------------------------

RE: Insert Column in Excel Worksheet using Blue Prism

ewilson — Mon, 21 Dec 2020 15:05:00 GMT

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

RE: Insert Column in Excel Worksheet using Blue Prism

astrid.stollberger — Mon, 21 Dec 2020 15:23:00 GMT

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