//通过自己写xls文件的内容导出xls文件,可以与数据库相连,输出数据库内容
StringWriter sw = new StringWriter();
sw.WriteLine("自动编号/t姓名/t年龄");
sw.WriteLine("12/t王家卫/t33");
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=exportdata.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
//方法2:将已经存在的文件在aspx网页中输出
Response.AddHeader("Content-Disposition", "attachment; filename=exportdata.xls");
Response.ContentType = "application/ms-excel";
// Response.AddHeader("Content-Disposition", "attachment; filename=exportdata.doc");
// Response.ContentType = "application/ms-word";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Stream outstream = Response.OutputStream;
string fileName = @"D:/1.xls";
FileStream fs = new FileStream(fileName, FileMode.Open);
BinaryReader br = new BinaryReader(fs);
byte b ;
int i = 0;
while (i<br.BaseStream.Length)
{
b = br.ReadByte();
outstream.WriteByte(b);
i++;
}
br.Close();
Response.End();
//方法3;将已经存在的文件在aspx网页中输出
string fileName = @"D:/1.xls";
Response.AddHeader("Content-Disposition", "attachment; filename=exportdata.xls");
Response.ContentType = "application/ms-excel";
Response.WriteFile(fileName);
Response.Flush();
Response.End();