cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pollyo
Frequent Visitor

How to extract text from Excel shapes

I need to extract the text from Excel shapes, but the "Extract data from window" step only returns the name of the shape, and the sheet is protected so I cannot use "Edit Text". Any tips?

4 REPLIES 4
rolign
Advocate III
Advocate III

You can always try extracting text with OCR.

Is there any way you can click the Shapes with mouse or send keys? Then you could do a ctrl+a ctrl+c with send keys and get the text to clipboard.

pollyo
Frequent Visitor

Thanks for the reply.

 

Right-click does nothing and left-click opens an editor window, which is the clunky workaround I am using now to validate the text. That works for now, but code changes could break the relationship and I would not know it.

 

I can look at using OCR.

@pollyo 

Any specific reason you are not unprotecting the sheet using a vbscript or a macro and then making it easy to extract the text?

pollyo
Frequent Visitor

@VJR Thanks, it may come to that but I'm wary of embedding passwords and the unprotect/edit/protect sequence is another possible point of failure.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (19,469)