导出excel
private void OutputContactExcel(string strFileName, DataTable dtOutPut, string strTextType)
{
StringWriter sw = new StringWriter();
string strColumns = "";
foreach (DataColumn Columns in dtOutPut.Columns)
{
strColumns = strColumns + "\t" + Columns.ColumnName;
}
sw.WriteLine(strColumns.Substring(1));
foreach (DataRow dr in dtOutPut.Rows)
{
strColumns = "";
foreach (DataColumn Columns in dtOutPut.Columns)
{
strColumns = strColumns + "\t" + dr[Columns.ColumnName];
}
sw.WriteLine(strColumns.Substring(1));
}
sw.Close();
System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + strFileName);
System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
if (strTextType != "")
{
System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding(strTextType); //"GB2312"
}
System.Web.HttpContext.Current.Response.Write(sw);
System.Web.HttpContext.Current.Response.End();
}