将已经存在的文件在aspx网页中输出的方法

来源：互联网发布：家装颜色搭配技巧知乎编辑：程序博客网时间：2024/06/06 15:44

            //通过自己写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();