Export Image to Microsoft Office Excel using C#

Here I am trying to show how we can export an image to excel file.

References Used: Microsoft.Office.Interop.Excel;

Link for downloading the dlls and install : Office XP PIAs

(http://www.microsoft.com/downloads/details.aspx?FamilyID=c41bd61e-3060-4f71-a6b4-01feba508e52&displaylang=en)

Add Microsoft.Office.Interop.Excel.dll, office.dll to the bin folder.

String sFileImage = System.IO.Path.Combine(System.Configuration.ConfigurationManager.AppSettings["UploadPath"], Session["UserId"].ToString() + ".gif");

String sFilePath = System.IO.Path.Combine(System.Configuration.ConfigurationManager.AppSettings["UploadPath"], Session["UserId"].ToString() + ".xls");

if (File.Exists(sFilePath)) { File.Delete(sFilePath); }

Microsoft.Office.Interop.Excel.ApplicationClass objApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

Microsoft.Office.Interop.Excel.Worksheet objSheet = new Microsoft.Office.Interop.Excel.Worksheet();

Microsoft.Office.Interop.Excel.Workbook objWorkBook = null;

//object missing = System.Reflection.Missing.Value;

try

{

objWorkBook = objApp.Workbooks.Add(Type.Missing);

objSheet = (Microsoft.Office.Interop.Excel.Worksheet)objWorkBook.ActiveSheet;

//Add picture to single sheet1

objSheet = (Worksheet)objWorkBook.Sheets[1];

objSheet.Name = "Graph with Report";

////////////// Or multiple sheets

for (int iSheet = 0; iSheet < objWorkBook.Sheets.Count - 1; iSheet++)

{

objSheet = objWorkBook.Sheets[iSheet] as Worksheet;

///(objSheet as Microsoft.Office.Interop.Excel._Worksheet).Activate();

}

/////////////////

objSheet.Shapes.AddPicture(sFileImage, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoCTrue, 10, 10, 700, 350);

objWorkBook.SaveAs(sFilePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,

Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

}

catch (Exception)

{

//Error Alert

}

finally

{

objApp.Quit();

objWorkBook = null;

objApp = null;

}

2 Comments

Join the conversation! Your thoughts help the community grow.

Suthish Nair16y ago
The links provided are third party softwares. Above article using Microsoft.Office.Interop.Excel.dll only.
- dhanil das15y ago
  Got error, plz help me Error 4 The type 'Microsoft.Office.Core.MsoTriState' is defined in an assembly that is not referenced. You must add a reference to assembly 'Office, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. Am using VS 2010, have refrenced Excel.dll file