web c# 內容輸出為Excel

來源:互聯網
上載者:User
UsersDAL usDAL = new UsersDAL();
        DataTable dt = usDAL.GetDataTable(where);
        StringWriter sw = new StringWriter();
        sw.WriteLine("自動編號"t姓名"t電話"temail"t地址"tQQ"t身份證"t中獎等級"t中獎日期"t狀態"tIP");
        foreach (DataRow dr in dt.Rows)
        {
            string state = (bool.Parse(dr["state"].ToString()) == true) ? "審核" : "未審核";
            sw.WriteLine(dr["uid"] + ""t" + dr["name"] + ""t" + dr["phone"] + ""t" + dr["email"] + ""t" + dr["adress"] + ""t" + dr["qq"] + ""t" + dr["idcard"] + ""t" + dr["rate"] + ""t" + dr["luckday"].ToString() + ""t" + state + ""t" + dr["ip"]);
        }
        sw.Close();
        Response.AddHeader("Content-Disposition", "attachment; filename=data.xls");
        Response.ContentType = "application/ms-excel";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        Response.Write(sw);

        Response.End();

-----------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------

string fileName = page.Server.MapPath(System.DateTime.Now.ToString("yyyyMMddhhmmss") + System.DateTime.Now.Millisecond.ToString() + (new Random()).Next(0, 1000).ToString() + ".xls");
            FileStream fs = new FileStream(fileName, FileMode.CreateNew, FileAccess.Write, FileShare.None);
            StreamWriter swFromFile = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312"));
            
           swFromFile.WriteLine(fileValue);//要寫入的資料         

            swFromFile.Flush();
            swFromFile.Close();

            page.Response.Clear();
            page.Response.ClearHeaders();
            page.Response.Buffer = false;
            page.Response.ContentType = "Application/x-msexcel";
            page.Response.AppendHeader("Content-Disposition", "attachment:filename=" + page.Server.UrlEncode(System.IO.Path.GetFileName(fileName)));
            page.Response.WriteFile(fileName);
            page.Response.Flush();
            File.Delete(fileName);
            page.Response.End();

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.