导出EXCEL、WORD中带有图片的无敌替换法

1.简单的asp导出只要跳转到某个页面带上一个参数即可：

//导出Excel

     int mIsExport = RequestHelper.GetQueryString<int>(“IsExport”, 0);
     if (mIsExport == 1)
     {

         Response.Clear();
         Response.Buffer = true;
         Response.AppendHeader(“Content-Disposition”, “attachment;filename=” + DateTime.Now.ToString(“yyyyMMdd”) + “.xls”);
         Response.ContentEncoding = System.Text.Encoding.Default;
         Response.ContentType = “application/vnd.ms-excel”;
         this.EnableViewState = false;
     }

//导出Word

     int mIsExport = RequestHelper.GetQueryString<int>(“IsExport”, 0);
     if (mIsExport == 1)
     {

         Response.Clear();
         Response.Buffer = true;
         Response.AppendHeader(“Content-Disposition”, “attachment;filename=” + DateTime.Now.ToString(“yyyyMMdd”) + “.doc”);
         Response.ContentEncoding = System.Text.Encoding.Default;
         Response.ContentType = “application/vnd.ms-word”;
         this.EnableViewState = false;
     }

以上方法很方便快捷，但是存在局限性，图片并不能一起导出，因此介绍第二种方法：

2.替换法：

优点：可以一起导出文字、表格、图片

缺点：模板确定性，不可循环，如果模板中有动态内容不推荐使用

局限性：偶然发现一个问题，模板是由office2007转换成的htm网页文件，但是导出结果WPS或者office2003似乎不支持图片，同时，我尝试用2003或者wps转成模板，但是2003或者wps不支持带图片转成模板。遇到瓶颈，求高手指点！

a).首先我们需要将要导出的文件（Word或者Excel~Whatever~）整理好，将页面需要填写数据的地方存在数据的都删除。同时多句嘴，最好打印预览一下文件是不是A4纸大小，方便导出的文件直接可以打印。

b).保存好模板（.doc或者.xls）然后将模板另存为-》其他个格式-》.htm文件注意将附属文件一起保存到一个文件夹中（不懂怎么设置的请咨询我）

c).到程序部分了，新建一个页面，页面内容如下：

<%@ Page Language=”C#” AutoEventWireup=”true” %>
<%@ Import Namespace=”AgileCorp.CBO.Service” %>
<%@ Import Namespace=”AgileCorp.Core.DB” %>
<%@ Import Namespace=”System.Collections.Generic” %>
<%@ Import Namespace=”AgileCorp.Core.ExFile” %>
<%@ Import Namespace=”AgileCorp.Core.Web” %>
<%@ Import Namespace=”System.Data” %>
<%@ Import Namespace=”AgileCorp.Core.Web.Html” %>
<%@ Import Namespace=”AgileCorp.SystemProvider” %>
<%

        String tplContent = Server.MapPath(“~/CargoDan.htm”);
        String tmpContent = FileHelper.ReadFile(tplContent);
        String fileName = Server.MapPath(“~/CargoDan.xls”);
        FileHelper.DeleteFile(fileName);

        /*取需要的数据*/
    String mConsignmentNum = RequestHelper.GetQueryString(“ConsignmentNum”);
    //得到货运主表信息
    List<DbParam> mDicSysParam = new List<DbParam>();
    List<DbParam> mDicInputParam = new List<DbParam>();
    mDicInputParam.Add(new DbParam(“Action”, “getone”));
    mDicInputParam.Add(new DbParam(“ConsignmentNum”, mConsignmentNum));
    mDicInputParam.Add(new DbParam(“PageIndex”, 0));
    mDicInputParam.Add(new DbParam(“PageSize”, 0));
    DataTable mDtFormDetail = AgileCorpAppSystemService.GetDataFunctionDataTable(“QueryCargo”, mDicInputParam, out mDicSysParam);


    String mFromPlace = “”;       //出发地
    String mToPlace = “”;//到达地
    String mAreaTel = “”;         //到达地电话
    String mWayBillNum = “”;//航班编号
    String mReceiveCompanyName = “”;//收件人
    String mRealTotalCount = “”;//总数量
    String mRealWeightAll = “”;//总重量
    String mRealEnterName = “”;//货物性质（即货物品名等等）
    String mToPlaceAreaType = “”;
    String mFlight1 = “”;
    String mCargoDate = “”;

    if (mDtFormDetail != null && mDtFormDetail.Rows.Count > 0)
    {
        mFromPlace = mDtFormDetail.Rows[0][“FromPlace”].ToString();
        mToPlace = mDtFormDetail.Rows[0][“ToPlace”].ToString();
        mAreaTel = mDtFormDetail.Rows[0][“AreaTel”].ToString();
        mWayBillNum = mDtFormDetail.Rows[0][“WayBillNum”].ToString();
        mReceiveCompanyName = mDtFormDetail.Rows[0][“ReceiveCompanyName”].ToString();
        mRealTotalCount = mDtFormDetail.Rows[0][“RealTotalCount”].ToString();
        mRealWeightAll = mDtFormDetail.Rows[0][“RealWeightAll”].ToString();
        mRealEnterName = mDtFormDetail.Rows[0][“RealEnterName”].ToString();
        mToPlaceAreaType = mDtFormDetail.Rows[0][“ToPlaceAreaType”].ToString();
        mFlight1 = mDtFormDetail.Rows[0][“Flight1”].ToString();
        mCargoDate = mDtFormDetail.Rows[0][“CargoDate”].ToString();
        if (!String.IsNullOrEmpty(mCargoDate))
        {
            mCargoDate = DateTime.Parse(mDtFormDetail.Rows[0][“CargoDate”].ToString()).ToString(“yyyy-MM-dd”);
        }
        //临时数据
        tmpContent = tmpContent.Replace(“{ConsignmentNum}”, mConsignmentNum);
        tmpContent = tmpContent.Replace(“{FromPlace}”, mFromPlace);
        tmpContent = tmpContent.Replace(“{ToPlace}”, mToPlace);
        tmpContent = tmpContent.Replace(“{AreaTel}”, mAreaTel);
        tmpContent = tmpContent.Replace(“{WayBillNum}”, mWayBillNum);
        tmpContent = tmpContent.Replace(“{ReceiveCompanyName}”, mReceiveCompanyName);
        tmpContent = tmpContent.Replace(“{RealTotalCount}”, mRealTotalCount);
        tmpContent = tmpContent.Replace(“{RealWeightAll}”, mRealWeightAll);
        tmpContent = tmpContent.Replace(“{RealEnterName}”, mRealEnterName);
        tmpContent = tmpContent.Replace(“{ToPlaceAreaType}”, mToPlaceAreaType);
        tmpContent = tmpContent.Replace(“{Flight1}”, mFlight1);
        tmpContent = tmpContent.Replace(“{CargoDate}”, mCargoDate);