Insert image in excel using VS 2010

Question

Hi I suppose we can insert an image in excel sheet using c# language in Visual studio 2010. But how to perform exactly please give an example any-body.... Thank you..

Garry Gibson · Answer

Hi here is an alternative you could try: ExcelFile ef = new ExcelFile (); ExcelWorksheet ws = ef.Worksheets.Add( Images ); ws.Cells[ A1 ].Value = Image example ; ws.Pictures.Add( Sample.jpg  PositioningMode .Move new AnchorCell (ws.Columns[ A ] ws.Rows[1] true )); ef.Save( Sample.xlsx ); With this you avoid the hassle of COM environment which you get in excel automation .

Lalit M · Answer

Hi Try this link http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=3&sid=35 http://rameshswaminathan.wordpress.com/2010/05/27/inserting-an-image-to-excel-document-using-c/ http://social.msdn.microsoft.com/Forums/en-NZ/csharplanguage/thread/26135619-8d77-4550-af7e-4288103dec6d