- protected void Page_Load(object sender, EventArgs e)
- {
- DataTable dt = new DataTable();
- dt.Columns.Add("C1");
- dt.Columns.Add("C2");
- DataRow dr = dt.NewRow();
- dr[0] = "11";
- dt.Rows.Add(dr);
- ExportExcel(dt, @"d:/h.xls");
- }
- public void ExportExcel(DataTable dt, string fileName)
- {
- try
- {
- StreamWriter w = new StreamWriter(fileName, false, System.Text.Encoding.GetEncoding("GB2312"));
- w.Write("<table align=center border=1 width=100%><tr>");
- for (int i = 0; i < dt.Columns.Count; i++)
- {
- w.Write("<td align=left style='font-weight:bold;background:#f6f6f6'>");
- w.Write(dt.Columns[i]);
- w.Write("</td>");
- }
- w.Write("</tr>");
- object[] values = new object[dt.Columns.Count];
- foreach (DataRow dr in dt.Rows)
- {
- values = dr.ItemArray;
- w.Write("<tr>");
- for (int i = 0; i < dt.Columns.Count; i++)
- {
- w.Write("<td align=left>");
- w.Write(values[i]);
- w.Write("</td>");
- }
- w.Write("</tr>");
- }
- w.Write("</table>");
- w.Flush();
- w.Close();
- }
- catch { Response.Write("wrong"); }
- }
导出excel的方法
最新推荐文章于 2022-11-07 15:01:43 发布