?
Solved

insert pictures into Excel

Posted on 2014-02-03
5
Medium Priority
?
396 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 21

Accepted Solution

by:
netcmh earned 2000 total points
ID: 39830692
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 21

Expert Comment

by:netcmh
ID: 39830714
0
 

Author Comment

by:VBdotnet2005
ID: 39830798
Even a third party commercial object can't do it?
0
 
LVL 21

Expert Comment

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

Expert Comment

by:netcmh
ID: 39841665
Thanks for the grade. Good luck.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

765 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