topic Re: Excel Graph API - Issue in Get worksheet Name and Hide worksheet Action in Product Forum

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

Neel1 — Tue, 29 Apr 2025 16:09:47 GMT

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

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

expertcr — Tue, 29 Apr 2025 16:25:29 GMT

Can you let us know the version of the VBO that you are using?

Have you tried using a new version of the VBO?

Here is an example of how to look for the VBO version.

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

Neel1 — Tue, 29 Apr 2025 16:28:11 GMT

Hello @expertcr - I am using the latest 1.5.1 version . i mentioned the link in my post.

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

GeoffHirst — Wed, 30 Apr 2025 10:05:20 GMT

Hi @Neel1

Sorry to hear you are having issues with this asset. I will investigate your concerns and revert back to you with an update.

regards

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

GeoffHirst — Thu, 01 May 2025 09:05:03 GMT

Hi @Neel1 ,

Just a progress update. I have added the missing output parameter, worksheet name, to the asset. The other issue you raised, I am still investigating. I am setting up a test harness, to try and replicate the issue. I will revert back with further details when I have them.

Appreciate you bringing this to our attention.

regards

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

Neel1 — Mon, 05 May 2025 12:04:41 GMT

Thanks @GeoffHirst for update. Will wait for further news on this.

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

GeoffHirst — Wed, 07 May 2025 16:06:29 GMT

Hi @Neel1

A further update for you.

I have found the issue with the Hide Worksheet. For some reason it was sending a POST instead of a PATCH. However, I am in the process of updating the asset to fix the issue you mentioned but in addition to add some actions to aid in getting access to some of the needed ID's that the Graph API requires. Right now, these are dependent on other assets, namely the Sharepoint asset. So, it will be a little longer before the update is posted, possibly into next week as I can't post it without the documentation being duly revised also.

So, please bear with me a little longer.

regards

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

GeoffHirst — Fri, 16 May 2025 13:01:01 GMT

Hi @Neel1

Sorry for the delay in this fix. I can confirm I have now completed the fix and it is on its way through QA and should be available on the DX in the next week or so. I have done the fix I mentioned previously I have also added some helper actions to assist in the gathering of the various ID's that this API likes to use. I hope you find it useful.

Thank you for notifying us of this issue, it enables us to maintain assets for the benefit of all our users and for this we extend our appreciation. Thank you.

regards

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

Neel1 — Fri, 16 May 2025 14:05:16 GMT

Thanks @GeoffHirst for the update and your collaboration!

i am in processing of evaluating more actions. i noticed autofit column action is also not working. but i will give it one/two more retry with different Excel sets before i confirm on this!

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

Neel1 — Wed, 30 Jul 2025 14:58:08 GMT

Hello @GeoffHirst Thanks for publishing latest VBO of Excel Graph.

I tested with new version (1.5.3) and Get worksheet names is working but Hide worksheet is still not working.

Can you re-check once also at your end. below are the output of Hide worksheet action.

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

GeoffHirst — Fri, 01 Aug 2025 11:49:53 GMT

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

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

Neel1 — Fri, 08 Aug 2025 10:43:57 GMT

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.

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

GeoffHirst — Fri, 08 Aug 2025 11:03:44 GMT

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

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

Neel1 — Fri, 08 Aug 2025 11:21:38 GMT

Yes. i have raised the idea !

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

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

GeoffHirst — Mon, 11 Aug 2025 12:07:10 GMT

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

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

Neel1 — Mon, 11 Aug 2025 12:10:15 GMT

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?

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

GeoffHirst — Mon, 11 Aug 2025 12:54:56 GMT

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

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

Neel1 — Fri, 24 Oct 2025 09:29:12 GMT

hello @GeoffHirst - Can you share when v1.5.5 will be published?