?
Solved

insert pictures into Excel

Posted on 2014-02-03
5
Medium Priority
?
410 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 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

Independent Software Vendors: 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 This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month15 days, left to enroll

839 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