首页 > 其他 > 详细

ActiveReports之导出excel

时间:2017-12-03 13:37:45      阅读:411      评论:0      收藏:0      [点我收藏+]

前提概要参考:http://www.cnblogs.com/liandy0906/p/7936524.html

技术分享图片
            DbContextBase db = new DbContextBase();
            var list = db.PurchaseOrderTBs.ToList();
            List<PurchaseOrderView> list2 = new List<PurchaseOrderView>();
            foreach (var item in list)
            {
                list2.Add(new PurchaseOrderView()
                {
                    OrderNo = item.OrderNo,
                    PickNum = item.PickNum,
                    ProductPrice = item.ProductPrice,
                    ProductAmount = item.ProductPrice * item.PickNum
                });
            }
            ReportDataSource ReportDataSource = new ReportDataSource();
            ReportDataSource.Name = "DataSet1";
            ReportDataSource.Value = list2;

            ReportViewer rvDoc = new ReportViewer();
            rvDoc.LocalReport.ReportPath = Server.MapPath("~/Reports/Report2.rdlc");
            rvDoc.LocalReport.DataSources.Add(ReportDataSource);
            #region 导入excel
            Warning[] warnings;
            string[] streamids;
            string mimeType;
            string encoding;
            string extension;

            byte[] bytes = rvDoc.LocalReport.Render(
               "Excel", null, out mimeType, out encoding,
                out extension,
               out streamids, out warnings);

            FileStream fs = new FileStream(@"c:\output.xls",
               FileMode.Create);
            fs.Write(bytes, 0, bytes.Length);
            fs.Close();
            #endregion
View Code

 

ActiveReports之导出excel

原文:http://www.cnblogs.com/liandy0906/p/7965894.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!