Using C to find drawn arrows in Excel

Question

I wanted to know if there was a way to use C# to locate a drawn arrow in an excel spreadsheet. For instance, can a C# software access that excel file, search for arrows, and return the cells A2 and A6, or something similar if an arrow was drawn from A2 to A6? Sorry if this sounds silly, but I'm having trouble finding the answer to a "management question."

narikkadan · Answer 1 · Dec 15, 2022

There are 28 different varieties of arrow shapes when speaking of those in Excel. the photo below

enter image description here

The entire list can be retrieved from HERE

So when you are looping through shapes, you will have to account for all of these. Also what Richard Morgan mentioned in the comment is correct. You will have to use the TopLeftCell.Address and BottomRightCell.Address to find the range.

Your code would look like this. (BTW I am using Interop to automate Excel)

Let's say our worksheet looks like this. Now we don't want the Red Shapes as they are not Arrow Shapes.

enter image description here