ASP.NET 导出Excel文档-优快云博客

本文介绍了一种使用C#将DataTable中的数据导出到Excel文件的方法。通过创建StreamWriter对象并指定字符编码，可以逐行写入表格结构及数据内容。此过程包括设置表格样式、插入表头和遍历数据行。

 1 System.IO.TextWriter writer = new System.IO.StreamWriter(Server.MapPath("/provprice.xls"), false, System.Text.Encoding.GetEncoding("utf-8"));
 2             writer.Write("<table cellspacing=\"3\" style=\"font-family:宋体\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
 3             writer.WriteLine("<tr style=\"font-weight:bold\"><td>");
 4             writer.Write("供货商");
 5             writer.Write("</td><td>");
 6             writer.Write("商品");
 7             writer.Write("</td><td>");
 8             writer.Write("库存");
 9             writer.Write("</td><td>");
10             writer.Write("价格");
11             writer.Write("</td><td>");
12             writer.Write("开始时间");
13             writer.Write("</td><td>");
14             writer.Write("结束时间");
15             writer.Write("</td>");
16             writer.WriteLine("</tr>");
17             ///这里搜索要导出的数据信息（DataTable）
18             foreach (DataRow dr in dt.Rows)
19             {
20                 writer.Write("<tr><td>");
21                 writer.Write(dr["ProviderName"].ToString());
22                 writer.Write("</td><td>");
23                 writer.Write(dr["Name"].ToString());
24                 writer.Write("</td><td>");
25                 writer.Write(dr["Inventory"].ToString());
26                 writer.Write("</td><td>");
27                 writer.Write(dr["Prices"].ToString());
28                 writer.Write("</td><td>");
29                 writer.Write(dr["Begin_Time"].ToString());
30                 writer.Write("</td><td>");
31                 writer.Write(dr["End_Time"].ToString());
32                 writer.Write("</td></tr>");
33             }
34             writer.Write("</table>");
35             writer.Close();
36             dt = null;