Open XML DX asset

[Neel1]

I attempted to use the Open XML Asset from the Blue Prism Digital Exchange
(https://digitalexchange.blueprism.com/cardDetails?id=132937), but I am encountering multiple errors in the VBO.

Initially, the object failed with errors related to OpenXML.Framework. While reviewing the VBO guide, I noticed that DocumentFormat.OpenXml.Framework.dll is not explicitly mentioned as a required dependency, \

After manually adding this DLL, the initial framework error was resolved. However, additional errors are still present across several actions within the object, and the VBO does not compile or function as expected.

  @GeoffHirst  @ewilson  Could you please advise:

• The exact and complete list of DLLs (including versions) required for this asset
• Any known issues or compatibility constraints with specific Blue Prism versions
• Whether there is a validated workaround or updated asset available

[GeoffHirst]

Hi @Neel1 

Thank you for being a Blue Prism customer and for using Blue Prism. Your interest in the OpenXML asset is appreciated.

We are sorry your experience is not what we would hope you would have. 

Your issue is now being looked into and we will revert back to you with our findings.

In the meantime, could you provide us with your Blue Prism Version and installation type and also the version of Excel that you are working with. In addition, could you provide the version of the dependency dll that you are using also?

The answers to the above questions will assist us to finding a solution or workaround for you.

regards

[Neel1]

thanks @GeoffHirst   for looking into this.

Below are the environment and setup details:

• Blue Prism version: 7.3.1
• Deployment type: On‑premises
• Excel version: Version 2512, Build 16.0 (64‑bit)

As per the user guide, I have done the following:

• Downloaded OpenXML DLL version 3.4.1 from the net46 folder
• Referenced WindowsBase.dll and System.Core.dll from .NET Framework v4.7.2 

Used OpenXML.Framework version 3.4.1

let me know if any additional details are required.

[GeoffHirst]

Hi @Neel1 

I am looking into your issue, but as a possible quick solution could you try using V2.19 of the asset. This is some years old, but it is the version that was used when the asset was created.
My thoughts are that the latest version is using element of .NET that are more recent than what Blue Prism uses and as such are causing you the issues.

Let me know how you get on, I am going to continue to get this working locally.

regards

[Neel1]

Hello @GeoffHirst 
I didn’t fully understand your earlier response. Could you please clarify where I can download or access version 2.19?

[GeoffHirst]

Hi @Neel1 

The various revisions of the dependency can be found here

NuGet Gallery | DocumentFormat.OpenXml 3.4.1

I would not expect the latest version of this dependency to work with the current versions of Blue Prism Desktop. The reason being Blue Prism Desktop is based on .NET 4.x. The latest version of this dependency will likely be based on more recent versions of the NET framework.

I hope this explains the situation.

regards

[GeoffHirst · Accepted solution]

Hi @Neel1 

After testing the asset with V2.19 of the DocumentFormat.OpenXml.dll I am finding it to be working fine with V7.4.1 of Blue Prism desktop.

I may update the asset with an example process and possibly a video in the coming days to align this asset with others that we have done this for.

If you have any further issues with the asset, please come back here and let us know.

regards

[Neel1]

hello @GeoffHirst 

Thanks for working on this. Please let me know if you’ll also be updating the user guide as part of this change.

I’ll test the asset with version 2.19 on Blue Prism 7.3.1 and 7.5 from my side and share any feedback.

[Neel1]

I tested with version 2.19 of openxml and it work like charm with Blue prism 7.3.1.