Solved

insert pictures into Excel

Posted on 2014-02-03
5
383 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
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 20

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 20

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 20

Expert Comment

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

825 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