topic Problem with implementing ClosedXml In blueprism in Product Forum

Problem with implementing ClosedXml In blueprism

okud — Wed, 05 Jun 2024 17:52:35 GMT

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'.

Action 1

Code1

Error

Validate

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

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

Re: Problem with implementing ClosedXml In blueprism

asilarow — Thu, 06 Jun 2024 07:12:09 GMT

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.

Re: Problem with implementing ClosedXml In blueprism

devneetmohanty07 — Thu, 06 Jun 2024 07:21:53 GMT

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.

Re: Problem with implementing ClosedXml In blueprism

okud — Thu, 06 Jun 2024 10:50:05 GMT

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.