Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in RPA by (5.3k points)

Outside the out-of-the-box MS VBOs available with BluePrism. Has anyone successfully managed to import/reference (COM) Office Interop objects (Word, Excel, Outlook, etc...) for use in BluePrism code stages? Please, tell how?

1 Answer

0 votes
by (9.5k points)

i think you need to ensure that you add a namespace and reference to the object's Code Options 

enter image description here

Then you can use the objects from the DLL within code stages:

Application app = new Application(){ Visible = true }; Workbook wb = app.Workbooks.Add(); Worksheet ws = (Worksheet)wb.Worksheets.Add(); ws.Visible = XlSheetVisibility.xlSheetVisible;

As you can see, you can also use the named enums, but just like in C# you need to specify it fully (XlSheetVisibility.xlSheetVisible instead of just xlSheetVisible)

hope it helped

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 29, 2019 in RPA by noah kapoor (5.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.2k users

Browse Categories

...