一个将web中datatable下载到本地excel的函数

最新推荐文章于 2024-04-24 09:07:52 发布

gaotianle

最新推荐文章于 2024-04-24 09:07:52 发布

阅读量798

点赞数

文章标签： excel web string office table html

本文链接：https://blog.csdn.net/gaotianle/article/details/4059928

版权

private void DownloadExcel(string fileName, string sheetName, DataTable myDataTable)
  {
   StringWriter sw = new StringWriter();
   sw.WriteLine("<html xmlns:x=/"urn:schemas-microsoft-com:office:excel/">");
   sw.WriteLine("<head>");
   sw.WriteLine("");
   sw.WriteLine("</head>");
   sw.WriteLine("<body>");
   sw.WriteLine("<table>");
   sw.WriteLine(" <tr>");
   //Write Title
   foreach(DataColumn col in myDataTable.Columns)
   {
    sw.Write(String.Format("<td><b>{0}</b></td>",col.ColumnName));
   }
   sw.WriteLine(" </tr>");

   //Write Data
   foreach (DataRow dr in myDataTable.Rows)
   {
    sw.WriteLine(" <tr>");

    foreach(DataColumn col in myDataTable.Columns)
    {
     sw.Write(String.Format("<td>{0}</td>",dr[col.ColumnName]));
    }
    sw.WriteLine(" </tr>");
   }
   sw.WriteLine("</table>");
   sw.WriteLine("</body>");
   sw.WriteLine("</html>");
   sw.Close();
   Response.Clear();
   Response.Buffer = true;
   Response.Charset = "UTF-8";
   this.EnableViewState = false;
   Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName +".xls");
   Response.ContentType = "application/ms-excel";
   Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
   Response.Write(sw);
   Response.End();
  }

gaotianle

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
一个将web中datatable下载到本地excel的函数

private void DownloadExcel(string fileName, string sheetName, DataTable myDataTable) { StringWriter sw = new StringWriter(); sw.WriteLine(""); sw.WriteLine(""); sw.WriteLine(""); sw.WriteL
复制链接

扫一扫