aspx输出Excel word 及其他文件的方法

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值