Solved

insert pictures into Excel

Posted on 2014-02-03
5
375 Views
Last Modified: 2014-02-07
Is there a way to insert pictures into Excel at a specified cell position?
0
Comment
Question by:VBdotnet2005
  • 4
5 Comments
 
LVL 20

Accepted Solution

by:
netcmh earned 500 total points
Comment Utility
Directly, it would be Right-click cell > Insert Comment > right-click on shaded area on the outside of the comment box > Format Comment > Colors and Lines > Fill > Color > Fill Effects > Picture > (Browse to picture) > Click OK

When you hover over the cell, it picture will appear.

Using C#? You can't. Inserting pictures into cells is not do-able. Your approach should be something like trying to align them with the cell by using the top and left properties.

You'll probably have to use Sheet.Shapes.AddPicture() and calculate coordinates where to put the picture. Google the function and coordinates, and you'll probably hit the workaround code people have been doing to achieve just that.
0
 
LVL 20

Expert Comment

by:netcmh
Comment Utility
0
 

Author Comment

by:VBdotnet2005
Comment Utility
Even a third party commercial object can't do it?
0
 
LVL 20

Expert Comment

by:netcmh
Comment Utility
I'll defer to the other experts on the 3rd party object. I haven't heard of any.
0
 
LVL 20

Expert Comment

by:netcmh
Comment Utility
Thanks for the grade. Good luck.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now