cancel
Showing results for 
Search instead for 
Did you mean: 

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

Neel1
MVP

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.

Neel1_0-1745942515156.png

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

 

Neel1_3-1745942868616.png

@ewilson @GeoffHirst - your suggestion on this?

#ExcelgraphAPI

 

 

 

 

8 REPLIES 8

expertcr
Staff
Staff

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.

expertcr_0-1745943867012.png

 

Neel1
MVP

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

GeoffHirst
Staff
Staff

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

Geoff Hirst Senior DX Engineer - Digital Exchange - EMEA SS&C Blue Prism

GeoffHirst
Staff
Staff

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

Geoff Hirst Senior DX Engineer - Digital Exchange - EMEA SS&C Blue Prism

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

GeoffHirst
Staff
Staff

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

Geoff Hirst Senior DX Engineer - Digital Exchange - EMEA SS&C Blue Prism

GeoffHirst
Staff
Staff

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

Geoff Hirst Senior DX Engineer - Digital Exchange - EMEA SS&C Blue Prism

Neel1
MVP

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!