Problem with implementing ClosedXml In blueprism

[okud]

Hello Guys,

We are trying to avoid the use of VBA's and conventional blue prism actions to process excel. We want to use the closedXML. I download the nuget package on visual studio and perfromed a simple read excel to datatabel and it worked. the problem now is that when I try to move the dll to blue prism  I have two errors.

the external package is link to closed xml nuget 

Action 1

Code1

Error

Validate

Compiler error at line 20: 'Skip' is not a member of 'IXLRows'.

No

Action 1

Code1

Error

Validate

Compiler error at line 23: 'Count' is not a member of 'IXLCells'.

No

here is what my global code looks like, initially I had 17 errors but I have managed to clear them to 2:

Thanks in advance

[asilarow · Accepted solution]

The errors you are mentioning are happening because you are trying to use methods that are not a part of the classes you are using.

https://docs.closedxml.io/en/latest/api/index.html#interface-ClosedXML.Excel.IXLCells

Count does not appear to be a valid method for IXCL.Cells, and Skip does not appear for IXCL.Rows either.

[devneetmohanty07]

Hi @okud ,

Can you share the code where you are facing this issue? This would help us to exactly see how you are using these attributes as IXCL.Cells and IXCL.Rows cannot access these attributes directly as @asilarow has already mentioned.

[okud]

Hello @asilarow . Yes You are right. Thank you . I also noticed that my blue prism does not support .net 8.0 and I think the version of ClosedXml that implements count and skip might be in a much higher .net version. I have decided to implement my own custom dll using Open XML SDK with .net 4.0 and it works now.