System.Text.StringBuilder sb = new System.Text.StringBuilder();
for(int i=0;i<dt.Rows.Count;i++)
{
for(int j=0;j<dt.Columns.Count;j++)
{
sb.AppendFormat("{0}\t",Convert.ToString(dt.Rows[i][j]));
}
sb.Append("\r\n");
}
System.IO.StreamWriter sw = new System.IO.StreamWriter(Server.MapPath("月度.xls"),false,System.Text.Encoding.GetEncoding("gb2312"));
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
for(int i=0;i<dt.Rows.Count;i++)
{
for(int j=0;j<dt.Columns.Count;j++)
{
sb.AppendFormat("{0}\t",Convert.ToString(dt.Rows[i][j]));
}
sb.Append("\r\n");
}
System.IO.StreamWriter sw = new System.IO.StreamWriter(Server.MapPath("月度.xls"),false,System.Text.Encoding.GetEncoding("gb2312"));
sw.Write(sb.ToString());
sw.Flush();
sw.Close();