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 !


Categories

...