Excel Graph API - Issue in Get worksheet Name and Hide worksheet Action

[Neel1]

I am in processing of validating actions for Excel graph API connector (https://digitalexchange.blueprism.com/cardDetails?id=130238)

1st observation is Get worksheet name Action do not have actual output which will give name of worksheet. It has only these output.

2nd - i tried hide worksheet Action 2-3 times but it is not hiding the worksheet. My workbook has 2 worksheets.

@ewilson @GeoffHirst - your suggestion on this?

#ExcelgraphAPI

[GeoffHirst]

Hi @Neel1 

I am sorry to hear you are still having issues. I think there has been an update issue with this asset. I am currently looking into this matter and awaiting a response from a colleague. The version I have the hide worksheet works fine and I have a video that proves it.

So, your issue is being looked into and I will revert back to you with an update when I have one. Thanks for bringing this issue to our attention, it is appreciated.

regards

[Neel1]

hello @GeoffHirst - Latest asset Version 1.5.4 solve the issue of Hide Worksheet. Although there is no action/option to unhide worksheet but the original issue stand closed.

[GeoffHirst · Accepted solution]

Hi @Neel1 ,

I am pleased this has solved your issue. With regards the additional action, it would be a good addition and if you would like it to be considered, make a feature request at the ideation pages.

Thank you for being a SS&C Blue Prism Customer and for using Blue Prism.
regards

[Neel1]

Yes. i have raised the idea !

 https://dxassetideas.blueprism.com/ideas/DXASSETS-I-232

[GeoffHirst]

Hi @Neel1 

Just for your reference the work has been done and the update 1.5.5 is working through our QA. The new action is called Worksheet Visibility and it effectively will allow you to hide, unhide and 'veryhide' a worksheet via an input parameter. I have left the existing hide worksheet in place for compatibility but any new developments I would recommend using the new action and passing in the appropriate visibility parameter for your particular requirements. I hope this meets your needs.

regards

[Neel1]

Thanks @GeoffHirst  for attending to idea so quickly.

will the asset will have option to hide/unhide multiple worksheets as well or only a single one?

[GeoffHirst]

Hi @Neel1 

Given the functionality of the GraphAPI and how it works, it will be single worksheets, but there is no reason why multiple actions could not be combined.

regards