Answered

Is there any way to check if provided worksheet name is exists or not in excel?

(0) Share

Report

Posted on by PratikD21

Hi, I have sharepoint doc library, where excel is uploaded. I wanted to check if particular worksheet is exists or not in the file. Thanks in advance !

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Good news!

THere is an action block called 'Get worksheets'

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#get-worksheets

Hope this helps

Was this reply helpful? Yes No
PratikD21 38 on at

Like (0)

Report
Copy link

Link copied!

@efialttes I have tried, but not able to validate. The requirement is like these users will upload an excel file to SP Doc Library which contains multiple spreadsheets. And, we have a Configuration List where the Spreadsheet name is stored as one of the item.

Now, i am able to get SP List Item with value but not able compare with Get worksheets connectos repsponse.

Any example/flow diagram for comparison would be helpful.

Thanks.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Try with this approach:

So you can see 'Get worksheets' output is an array whose elements are objects, each objects represents one workshhet, one of its attributes is 'name'.

Hope this helps

Was this reply helpful? Yes No
PratikD21 38 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for your response. I am newbie to this technology and not aware how to find/compare string value in the response.

Could you please help me in this.

Thanks.

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Eh voila! Just replace 'myTargetWorksheetName' with the one you are looking for.

I am assuming in an Excel doc, two worksheets cannot share the same name, so if length is not 1, then it means target worksheet is not defined inside

Hope this helps

Was this reply helpful? Yes No