把ASP.NET页面的内容存进Execl

 

public void SaveExcel(string strLine)
    {
        string path = Server.MapPath(".") + "/EXCEL/";
        string d = DateTime.Now.ToString().Replace("-", "").Replace(" ", "").Replace(":", "");
        string path1 = path + "excel" +d + ".xls";
        string i = "excel" + d + ".xls";
        string FileName = path1;
        //System.Data.DataTable dt = new System.Data.DataTable();
        FileStream objFileStream;
        StreamWriter objStreamWriter;
        objFileStream = new FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write);
        objStreamWriter = new StreamWriter(objFileStream, System.Text.Encoding.Unicode);
        objStreamWriter.WriteLine(strLine);
     
        objStreamWriter.WriteLine("");
        objStreamWriter.Close();
        objFileStream.Close();

      Response.Write("<script language=javascript>window.open('ViewExecl.aspx?name=" + i + "',target='_blank');</script>");
    }

跳到下载的页面的代码

string i = Request.QueryString["name"].Trim();
            string path = "EXCEL/" + i ;
            link1.NavigateUrl = path;

link1为HyperLink