public void ToExcel()
{
DataTable dt = record.recordset;
if (dt.Rows.Count > 0)
{
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename = excel.xls");
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = Encoding.GetEncoding("gb2312");
foreach (DataColumn column in dt.Columns)
{
Response.Write(column.ColumnName+ Convert.ToChar(9));
}
Response.Write("\r\n");
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
string str = dt.Rows[i][j].ToString();
str=str.Replace("\r", "");
str = str.Replace("\n", "");
str = str.Replace("\r\n", "");
Response.Write(str.Replace(Convert.ToChar(9).ToString(), "") + Convert.ToChar(9));
}
Response.Write("\r\n");
}
Response.End();
}
}