asp.net项目下载Excel文件

2019独角兽企业重金招聘Python工程师标准>>>

单sheet，传入Dataset：

 private void CreateExcel(DataSet ds)
        {
            string time = DateTime.Now.ToString("yyMMddHHmmss");
            string filename = "f" + time;

            HttpResponse resp;
            resp = Page.Response;
            resp.ContentEncoding = Encoding.GetEncoding("utf-8");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
            Response.ContentType = "application/ms-excel";
            string colHeaders = "", lsItem = "";
            DataTable dt = ds.Tables[0];
            DataRow[] myRow = dt.Select("");
            int i = 0;
            //取得数据表各列标题，各标题之间以\t分割，最后一个列标题后加回车符 
            for (i = 0; i < dt.Columns.Count; i++)
            {
                if (i == dt.Columns.Count - 1)
                {
                    colHeaders += dt.Columns[i].Caption + "\n";
                }
                else
                {
                    colHeaders += dt.Columns[i].Caption + "\t";
                }
            }
            resp.Write(colHeaders);
            foreach (DataRow row in myRow)
            {
                for (i = 0; i < dt.Columns.Count; i++)
                {
                    if (i == dt.Columns.Count - 1)
                    {
                        lsItem += row[i] + "\n";
                    }
                    else
                    {
                        lsItem += row[i] + "\t";
                    }
                }
                // 
                resp.Write(lsItem);
                lsItem = "";
            }
        }

多sheet，传入Dataset[]

private void CreateExcel(DataSet[] ds)
        {
            Response.ClearContent();
            Response.BufferOutput = true;
            Response.Charset = "utf-8";
            Response.ContentType = "application/ms-excel";
            Response.AddHeader("Content-Transfer-Encoding", "binary");
            Response.ContentEncoding = Encoding.UTF8;
            string time = DateTime.Now.ToString("yyMMddHHmmss");
            string filename = "data" + time;
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
            Response.Write("<?xml version='1.0'?><?mso-application progid='Excel.Sheet'?>");
            Response.Write(@"<Workbook xmlns='urn:schemas-microsoft-com:office:spreadsheet'
      xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel'
      xmlns:ss='urn:schemas-microsoft-com:office:spreadsheet' xmlns:html='http://www.w3.org/TR/REC-html40'>");
            for (int i = 0; i < ds.Length; i++)
            {
                DataTable dt = ds[i].Tables[0];
                DataRow[] myRow = dt.Select("");
                Response.Write("<Worksheet ss:Name='Sheet" + (i + 1) + "'>");
                Response.Write("<Table x:FullColumns='1' x:FullRows='1'>");
                Response.Write("\r\n<Row ss:AutoFitHeight='1'>");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    Response.Write("<Cell><Data ss:Type='String'>" + dt.Columns[j].ColumnName +
                                   "</Data></Cell>");
                }
                Response.Write("\r\n</Row>");
                foreach (DataRow row in myRow)
                {
                    Response.Write("<Row>");
                    for (int k = 0; k < dt.Columns.Count; k++)
                    {
                        Response.Write("<Cell><Data ss:Type='String'>" + row[k] +
                                       "</Data></Cell>");
                    }
                    Response.Write("</Row>");
                }
                Response.Write("</Table>");
                Response.Write("</Worksheet>");
                //Response.Flush();
            }
            Response.Write("</Workbook>");
            Response.End();
        }

转载于:https://my.oschina.net/mandy4107/blog/480753