asp.net操作excel

public void aa(DataSet ds)
    {
        string strFileName = Server.MapPath(@"Nomarl.xls");
        string strSaveFileName = Server.MapPath(@"excel.xls");

        Excel.Application ThisApplication = new Excel.ApplicationClass();
        Excel.Workbook ThisWorkBook = null;
        Excel.Worksheet ThisSheet = null;
        object missing = System.Reflection.Missing.Value;

        try
        {
            ThisWorkBook = ThisApplication.Workbooks.Open(strFileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
            ThisApplication.Visible = false;
            int count = ThisApplication.Application.Worksheets.Count;

            DataRow dr = null;
            System.Data.DataTable dt = ds.Tables["customers"];
          
            for (int i =1; i < count+1; i++)
            {
                ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[i];
             
              

                for (int k = 0; k < dt.Rows.Count; k++)
                {
                     dr = dt.Rows[k];

                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        ThisSheet.Cells[1+k, j + 4] = dr[j].ToString();

                    }
                }
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);

        }
     
        ThisWorkBook.SaveCopyAs(HttpContext.Current.Server.MapPath(".") + "//" + "aa" + ".xls");

        ThisWorkBook.Close(false, null, null);
        ThisApplication.Quit();
        System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisWorkBook);
        System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisApplication);
        ThisWorkBook = null;
        ThisApplication = null;
        GC.Collect();

        string path = HttpContext.Current.Server.MapPath("aa" + ".xls");
        System.IO.FileInfo file = new System.IO.FileInfo(path);
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Charset = "utf-8";
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
        HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpContext.Current.Server.UrlEncode(file.Name));
        HttpContext.Current.Response.AddHeader("Content-Length", file.Length.ToString());
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        HttpContext.Current.Response.WriteFile(file.FullName);
        HttpContext.Current.Response.End();
    }
 

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值