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

[expertcr]

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.

[Neel1]

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

[GeoffHirst]

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

[GeoffHirst]

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

[Neel1]

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

[GeoffHirst]

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

[GeoffHirst]

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

[Neel1]

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! 

[Neel1]

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.