Using C to find drawn arrows in Excel

0 votes
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."
Dec 15, 2022 in Others by Kithuzzz
• 33,140 points
100 views

1 answer to this question.

0 votes

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

answered Dec 15, 2022 by narikkadan
• 58,640 points

Related Questions In Others

0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
251 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 58,640 points
219 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 58,640 points
326 views
0 votes
1 answer

Generate a flat list of all excel cell formulas

Hello, you'll have to follow certain steps ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,970 points
139 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 22,970 points
225 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 22,970 points
488 views
0 votes
1 answer

Export DataTable to Excel File

Add Interop References. First we need to ...READ MORE

answered Jun 9, 2022 in JQuery by gaurav
• 22,970 points
296 views
0 votes
1 answer

Using c# to select a worksheet in excel

Try this: Excel.Worksheet xlWorkSheetFocus = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2); xlWorkSheetFocus.Activate(); I hope this ...READ MORE

answered Nov 14, 2022 in Others by narikkadan
• 58,640 points
125 views
0 votes
1 answer

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

answered Nov 24, 2022 in Others by narikkadan
• 58,640 points
554 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP