Remove/delete image from excel file using C#

Question

0.00/5 (No votes)

See more:

i want to delete specific image from excel file sheet , but i found nothing or most code i found doesn't match with my methode excel.Interop !

What I have tried:

 Excel.Application APPXL = new Excel.Application();      
    Excel.Workbook RapportXlWorkBook = APPXL.Workbooks.Open(excelfilePath)
    Excel.Worksheet RapportXlSheet = (Excel.Worksheet)RapportXlWorkBook.Worksheets[1];

/// remove code 
 //RapportXlSheet.Shapes(imageName).Delete !!! ??

I found only how to delete ALL shapes (pictures/images) in excel file , but not a specific shape !

foreach (Excel.Shape sh in RapportXlSheet.Shapes)
            {
                sh.Delete();
            }

Posted 1-Feb-18 23:31pm

EM_Y

Updated 6-Feb-18 22:02pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2018-02-02T03:26:00

Solution 1

Looks like you've got a VBA / VB.NET code sample, and you need to convert it to C#. Try:

C#

RapportXlSheet.Shapes[imageName].Delete();

EDIT: As discussed in the comments, the indexer isn't supported properly. You have to use the Item method instead:

C#

RapportXlSheet.Shapes.Item(imageName).Delete();

Posted 2-Feb-18 3:26am

Richard Deeming

Updated 8-Feb-18 0:48am

v2

Comments

Maciej Los 2-Feb-18 15:03pm

5ed!

EM_Y 6-Feb-18 3:19am

Thank you for your help and time , but it doesn't work ! :) @Richard Deeming

Richard Deeming 6-Feb-18 8:04am

"It doesn't work" is not a description of a problem that anyone can help you with.

EM_Y 7-Feb-18 2:53am

you are right ,
I'll try to explain better.

When I used

 RapportXlSheet.Shapes[imageName].Delete();

Error message shows : Cannot apply indexing with [] to an expression of type 'Microsoft.Office.Interop.Excel.Shapes' !

*I appreciate your attention :) .

Richard Deeming 7-Feb-18 10:35am

OK, try:

RapportXlSheet.Shapes.Item(imageName).Delete();

Sometimes Interop can't handle the indexer properly, and exposes it as a method instead.

EM_Y 8-Feb-18 2:28am

You'r genius :p ^^ , it works perfectly .
I appreciate your help .

EM_Y 7-Feb-18 4:29am

I found also how to delete all shapes (pictures/images ) from excel file but couldn't transform it to delete only one specific shape !

foreach (Excel.Shape sh in RapportXlSheet.Shapes)
            {
                sh.Delete();
            }

Ziee-M 8-Feb-18 7:54am

Can you please mark the solution as an answer.

EM_Y 9-Feb-18 6:47am

Done.