• web c# 内容输出为Excel


    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();

  • 相关阅读:
    Echarts Jqplot嵌extjs4 windows 装配方法
    法学类人猿生存方案--升华成掌握可能的方式
    LeetCode Merge k Sorted Lists 解决报告
    Swift
    Swift
    Swift
    Swift
    Swift
    Swift
    Swift
  • 原文地址:https://www.cnblogs.com/jiangchongwei/p/1305626.html
Copyright © 2020-2023  润新知