Excel导出

写了好久了，都快记不清了

 1 //导出DataTable到Excel
 2     public void ExportToExcel(DataTable datatable, string FileType, string FileName)
 3     {
 4         //DataTable datatable = IListOut<T>(ResList);
 5 
 6         Response.Clear();
 7         Response.Charset = "utf-8";
 8         Response.Buffer = true;
 9         Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
10         Response.AddHeader("Content-Disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls\"");
11         Response.ContentType = FileType;
12         string colHeadrs = string.Empty;
13         string ls_item = string.Empty;
14         DataRow[] myrow = datatable.Select();
15 
16         int i = 0;
17         int cl = datatable.Columns.Count;
18 
19         for (i = 0; i < cl; i++)
20         {
21             if (i == (cl - 1))
22             {
23                 ls_item += datatable.Columns[i].ToString().Replace("\r", "").Replace("\n", "") + "\n";
24             }
25             else
26             {
27                 ls_item += datatable.Columns[i].ToString().Replace("\r", "").Replace("\n", "") + "\t";
28             }
29         }
30         Response.Output.Write(ls_item);
31         ls_item = string.Empty;
32         foreach (DataRow row in myrow)
33         {
34             for (i = 0; i < cl; i++)
35             {
36                 if (i == (cl - 1))
37                 {
38                     ls_item += row[i].ToString().Replace("\r", "").Replace("\n", "") + "\n";
39                 }
40                 else
41                 {
42                     ls_item += row[i].ToString().Replace("\r", "").Replace("\n", "") + "\t";
43                 }
44             }
45             Response.Output.Write(ls_item);
46             ls_item = string.Empty;
47         }
48         Response.Output.Flush();
49         Response.End();
50     }

从数据库导出数据到Excel，挺实用的

转载于:https://www.cnblogs.com/Doumiao/p/6699685.html