topic RE: Excel_VBO in University Forum

Excel_VBO

ZejunSun — Thu, 25 Aug 2022 03:50:00 GMT

BP可以实现合并单元格的操作吗，如果可以的话应该怎么实现，大佬们有具体的方法吗？谢谢大家！

------------------------------
Zejun Sun
------------------------------

RE: Excel_VBO

loganathan.s — Thu, 25 Aug 2022 11:22:00 GMT

Yes you can do. you can use Code code for that option.

May be you can try this.

//Merge the Cells
worksheet.Range["C6:H6"].Merge()

------------------------------
loganathan s
Project Lead Developer
HCL Technology
Asia/Kolkata
------------------------------

RE: Excel_VBO

michaeloneil — Thu, 25 Aug 2022 14:34:00 GMT

Hi

You will have to create a new action in the excel vbo and add the following code:

Dim ws As Object

ws = GetWorksheet(Handle, Workbook, Worksheet)

ws.Activate()

ws.Range(Range).Merge

The input parameters are Handle, Workbook, Worksheet and Range.
Hope this helps 🙂

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Excel_VBO

ewilson — Thu, 25 Aug 2022 19:37:00 GMT

Since @Michael ONeil went to the trouble of documenting a complete solution we went ahead and added it to the latest release of the VBO (v6.10.9). This is now available on the DX.

WARNING: Merging cells call result in the loss of data. Excel only keeps data from the upper-left cell. Any other data in the cell range is discarded. Keep this in mind before you use this action. 😉

Cheers,

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

RE: Excel_VBO

ZejunSun — Fri, 26 Aug 2022 02:36:00 GMT

您好，非常感谢您的帮助，这个方法确实可以实现合并单元格，但是Excel会弹出这个窗口会导致流程终止，可以麻烦您，这个怎么处理吗，非常感谢，谢谢！

------------------------------
Zejun Sun
------------------------------

RE: Excel_VBO

ewilson — Fri, 26 Aug 2022 02:47:00 GMT

@ZejunSun,

Are you using the method specifically as @Michael ONeil described it above, or are you using the updated VBO from the DX? In the VBO, we added the following additional line before the merge:

Application.DisplayAlerts = False

Cheers,

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

RE: Excel_VBO

ZejunSun — Fri, 26 Aug 2022 05:47:00 GMT

谢谢您的帮助，非常感谢！

------------------------------
Zejun Sun
------------------------------

RE: Excel_VBO

ZejunSun — Fri, 26 Aug 2022 05:51:00 GMT

我使用了@Michael ONeil的方法，没有使用DX

------------------------------
Zejun Sun
------------------------------

RE: Excel_VBO

ZejunSun — Fri, 26 Aug 2022 06:18:00 GMT

DX是需要我重新安装BP吗，我刚尝试了好像还是没有找到关于合并单元格的action

------------------------------
Zejun Sun
------------------------------

RE: Excel_VBO

ewilson — Fri, 26 Aug 2022 11:43:00 GMT

@ZejunSun,

Go to the following link, sign into the DX, and then download the latest MS Excel VBO bprelease file. Once you've downloaded that, you'll need to import it into your Blue Prism instance.

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

You do NOT have to reinstall Blue Prism.

Cheers,

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