ASP.NET导出excel
//取到数据 DataSet ds = SmsS.SmServerSetExcel(this.StartTime.SelectedValue.Value.ToString("yyyy-MM-dd"), this.EndTime.SelectedValue.Value.ToString("yyyy-MM-dd"));
DataTable dt = ds.Tables[0];
StringWriter sw = new StringWriter();
//EXCEL显示的列头名
sw.WriteLine("手机号\t内容\t发送时间");
//读取数据
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(dr["MoBiLe"] + "\t" + dr["MsgContent"] + "\t" + dr["CreateDate"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=Sms.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//输出
Response.Write(sw.ToString());
Response.End();
DataTable dt = ds.Tables[0];
StringWriter sw = new StringWriter();
//EXCEL显示的列头名
sw.WriteLine("手机号\t内容\t发送时间");
//读取数据
foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(dr["MoBiLe"] + "\t" + dr["MsgContent"] + "\t" + dr["CreateDate"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=Sms.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//输出
Response.Write(sw.ToString());
Response.End();