asp.net datatable 导出为 txt

最新推荐文章于 2023-04-11 00:06:54 发布

weixin_30240349

最新推荐文章于 2023-04-11 00:06:54 发布

阅读量134

点赞数

CC 4.0 BY-SA版权

文章标签： ui

原文链接：http://www.cnblogs.com/chenshulin01/p/3296486.html

本文详细介绍了如何使用C#将数据导出到TXT文件和EXCEL表格的方法，包括标题和内容的写入步骤及响应设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

如下是导出到TXT的方法

 public static void ToTxt(DataTable dv, string FileName)
        {
            System.IO.StringWriter sw = new System.IO.StringWriter();
            StringBuilder sb = new StringBuilder();
            //写标题
            for (int i = 0; i < dv.Columns.Count; i++)
            {
                if (i > 0)
                {
                    sb.Append("\t ");
                }

                 sb.Append(dv.Columns[i].ColumnName);
            }

            sw.WriteLine(sb.ToString());
            //写内容
            for (int rowNo = 0; rowNo < dv.Rows.Count; rowNo++)
            {

                StringBuilder sbTemp = new StringBuilder();

                for (int columnNo = 0; columnNo < dv.Columns.Count; columnNo++)
                {
                    if (columnNo > 0)
                    {
                        sbTemp.Append("\t ");
                    }
                    sbTemp.Append(dv.Rows[rowNo][columnNo].ToString());
                }
                sw.WriteLine(sbTemp.ToString());
            }
         
            System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
            response.Clear();
            response.Buffer = true;
            response.ContentEncoding = System.Text.Encoding.Default;
            response.ContentType = "text/plan";
            response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ".txt");
            response.Charset = "gb2312";
            response.Write(sw.ToString());
            response.End();
            sw.Close();
        }

如下是导出到EXCEL的方法

/// <summary>
		/// Renders the html text before the datagrid.
		/// </summary>
		/// <param name="writer">A HtmlTextWriter to write html to output stream</param>
		private static void FrontDecorator(HtmlTextWriter writer)
		{
			writer.WriteFullBeginTag("HTML");
			writer.WriteFullBeginTag("Head");

			writer.WriteEndTag("Head");
			writer.WriteFullBeginTag("Body");
		}

		/// <summary>
		/// Renders the html text after the datagrid.
		/// </summary>
		/// <param name="writer">A HtmlTextWriter to write html to output stream</param>
		private static void RearDecorator(HtmlTextWriter writer)
		{
			writer.WriteEndTag("Body");
			writer.WriteEndTag("HTML");
		}

		public static void ToExcel(System.Web.UI.WebControls.DataGrid DataGrid2Excel,string FileName,string Title, string Head)
		{
			System.IO.StringWriter sw = new System.IO.StringWriter();
			System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);

			FrontDecorator(hw);
			if ( Title != "")
				hw.Write(Title + "<br>");
			if ( Head != "")
				hw.Write(Head + "<br>");
			
			DataGrid2Excel.EnableViewState = false;
			DataGrid2Excel.RenderControl(hw);

			RearDecorator(hw);
   
			System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
			response.Clear();
			response.Buffer = true;
            response.ContentEncoding = System.Text.Encoding.Default;
			response.ContentType ="application/Excel";
			response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ".xls");
			response.Charset = "gb2312";
			response.Write(sw.ToString());
			response.End();
		}

转载于:https://www.cnblogs.com/chenshulin01/p/3296486.html