使用 C# 将图像导出到 Excel

 

这里演示如何将图像导出到 Excel 文件。

使用的引用：Microsoft.Office.Interop.Excel；

下载和安装 DLL 的链接：Office XP PIAs

将 Microsoft.Office.Interop.Excel.dll 添加到 bin 文件夹。

将 office.dll 添加到 bin 文件夹。

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;

   //将图片添加到单个 Sheet1
   objSheet = (Worksheet)objWorkBook.Sheets[1];
   objSheet.Name = "Graph with Report";

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

   或者多个 Sheet

   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)
{
 //错误提示
}
finally
{
    objApp.Quit();
    objWorkBook = null;
    objApp = null;
}