Simple Picture Insert into Excel Worksheet

HumptyNotSoDumpty

Would someone please kindly explain how I can do a simple insert of a picture into an Excel worksheet? I am using C#.Net 2003 with Microsoft Excel 2000, and have been able to insert an image using VB.Net, but cannot accomplish the same with C#. For example, VB.Net: _____appXL.ActiveSheet.Pictures.Insert("C:\Images\Image1.jpg").Select() In C# I have been trying to use different variations of the following: _____Image imgLogo1 = Image.FromFile( @"C:\Images\Image1.jpg"); _____((Excel.Range) objWorksheet.Cells[5, 5]).Select(); _____objWorksheet.Pictures( imgLogo1); If anyone knows, please help!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

HumptyNotSoDumpty22y ago
That great thanks. I find it can be a bit tricky figuring out the syntax for Excel within C#.
rajeshmandot22y ago
use this....it works for me... Excel.Worksheet TheSheet=new Excel.WorksheetClass(); TheSheet = (Excel.Worksheet)ExcelAppObj.ActiveWorkbook.Worksheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing); TheSheet.Shapes.AddPicture(ImageName, Microsoft.Office.Core.MsoTriState.msoFalse,Microsoft.Office.Core.MsoTriState.msoTrue,10,10,550,400);