Asp.net汇出图片到Excel

1.将图片字节转换为图片存储在本地

       byte[] bt= chart.GetPicture();       string strUrl = Server.MapPath(".")+"/GifToExcel/Report1.gif";               Response.ContentType = "image/gif";//上传时，存储的图片类型    //输出图片文件二进制数据           Response.OutputStream.Write(bt,0,bt.Length);       System.IO.MemoryStream s = new System.IO.MemoryStream(bt);       System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(s);       bitmap.Save(strUrl);

2.将本地图片汇入到Excel的类

using System;using System.Collections.Generic;using System.Linq;using System.Web;using ex=Microsoft.Office.Interop.Excel;using System.Reflection;
/// <summary>/// ExcelReport 的摘要描述/// </summary>public class InsertPictureToExcel{    /// <summary>    /// 將圖片匯出到Excel    /// </summary>    /// <param name="excelTemple">excel模板路徑</param>    /// <param name="img">要匯入到excel的圖片路徑</param>    /// <param name="position">圖片放到excel的哪個位置</param>    public static void imgToExcel(string excelTemple, string img, string position)    {        object missing = Missing.Value;        //定义一个Excel应用程序        ex.ApplicationClass excelObj = new ex.ApplicationClass();        excelObj.DisplayAlerts = false;        excelObj.Visible = false;        ex.Workbooks wbooks = excelObj.Workbooks;        ex.Workbook wbook = wbooks.Open(HttpContext.Current.Server.MapPath(excelTemple), missing, missing, missing, missing, missing, missing,            missing, missing, missing, missing, missing, missing, missing, missing);
        ex.Sheets sheets = (ex.Sheets)wbook.Worksheets;        ex._Worksheet sheet = (ex._Worksheet)sheets.get_Item(1);        ex.Range exRange = (ex.Range)sheet.get_Range(position, missing);        exRange.Select();        //声明一个pictures对象，用来存放柱状图        ex.Pictures pics = (ex.Pictures)sheet.Pictures(missing);        //插入图片        pics.Insert(HttpContext.Current.Server.MapPath(img), missing);        string imgName = HttpContext.Current.Server.MapPath(img).Substring(0, HttpContext.Current.Server.MapPath(img).LastIndexOf('.'));        wbook.SaveAs(imgName + ".xlsx", missing, missing, missing, missing, missing,            Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing,           missing);        wbook.Close(false, missing, missing);
        excelObj.Quit();        //必须关闭释放所引用的COM对象,关闭Excel进程，否则会占用服务器资源        System.GC.Collect();        System.GC.WaitForPendingFinalizers();
    }}

3.JavaScript汇出图片到Excel中

<script type="text/javascript">function fnExportExcel(){   try{       var oXL=new ActiveXObject("Excel.Application");   }catch(e){       alert("Excel沒有安裝或瀏覽器設置不正確,請啟用所有Active控件和插件");   //工具-> Internet??-> 安全－＞自定???-> ??有??安全??的ActiveX控件?行初始化 ???用    return false;   }   var oWB=oXL.Workbooks.Add();   var oSheet=oWB.ActiveSheet;   oSheet.Cells(1,1).Select();   oSheet.Pictures.Insert(document.getElementById("img1").src);   oXL.Visible   =   true;      oXL.UserControl   =   true; }</script>

 在Web.config的<system.web>里加
<identity impersonate="true"/>
<!-- impersonate 指定是否对每一个请求使用客户端模拟 -->