how to send a picture in a picturebox to excel?

Question

0.00/5 (No votes)

See more:

C#

ı want to send a picture in a picturebox to excel cell for exmp:excel.cells[10,10]

is there possible?

Posted 23-May-11 22:48pm

wellcometoend

Add a Solution

Comments

S Houghtelin 24-May-11 8:20am

Yes it is possible.

Where is the picturebox? (A form in excel?, another spreadsheet? an application outside of Excel?)

More information would be helpful for others to help.

Regards.

wellcometoend 24-May-11 8:37am

APPLİCATİON OUTSİDE OF EXCEL

there is a windows form and picture come to a picturebox if ı click print button all information about this guy and this guy picture must go to excel.I did a excel template. Picture must go cell[10,10]in excel.

wellcometoend 24-May-11 8:39am

this is my print button has include like this code

MExcel.Application Exceluygulama = new MExcel.Application();
MExcel.Workbook Excelkitap = Exceluygulama.Workbooks.Add(Application.StartupPath + "\\Rapor\\ogrencibelgesi.xls");
MExcel.Worksheet Excelsayfa = (MExcel.Worksheet)Exceluygulama.ActiveSheet;
Exceluygulama.Visible = true;
Exceluygulama.Cells[5, 5] = comboBox1.Text;
Exceluygulama.Cells[8, 10] = DateTime.Now.ToShortDateString();
Exceluygulama.Cells[16, 4] = textBox6.Text;

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)

S Houghtelin · Answer 1 · 2011-05-24T04:56:00

Add a reference to Excel under Project menu Add Reference. Under the COM tab and select Excel of the version to be used.

Add the following two lines to the directive at the top of the form code.

C#

using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;

Inside your clickevent:

C#

private void button1_Click(object sender, EventArgs e)
        {
            Excel.Application Exceluygulama;
            Excel.Workbook Excelkitap;
            Excel.Worksheet Excelsayfa;
            try
            {
                // Start Excel
                Exceluygulama = new Excel.Application();
                Exceluygulama.Visible = true;
                //Create workbook.
                Excelkitap = (Excel.Workbook)(Exceluygulama.Workbooks.Add(Missing.Value));
                Excelsayfa = (Excel.Worksheet)Excelkitap.ActiveSheet;
                //Get and display image in picture object
                Excelsayfa.Shapes.AddPicture("C:\\MyPic.Bmp", Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 425, 130, 100, 125);

                // ...And so forth
                Exceluygulama.Cells[5, 5] = "Text Item 1";
                Exceluygulama.Cells[8, 10] = DateTime.Now.ToShortDateString();
                Exceluygulama.Cells[16, 4] = "Text Item 2";
            }
            catch // Do something in case there is an error
            {     // such as Excel not installed.
              
            }
        }

The numbers at the end of the AddPicture are the Left, Top, Width and Height of the picture. You will need to size and locate he picture so that you can place the picture over the Cell(10,10) location.

There is more information here: http://support.microsoft.com/kb/302084[^]

You should be able to navigate the workbook, copy paste etc. using cell referencing.

Regards.