关于C# 导出excel下载到服务端返回下载链接

关注

原创最新推荐文章于 2026-07-20 11:33:32 发布 591 阅读 AI 写同款· GEO 优化 ›

C# 导出 Excel 的各种方法总结第一种：使用 Microsoft.Office.Interop.Excel.dll 首先需要安装 office 的 excel，然后再找到Microsoft.Office.Interop.Excel.dll 组件，添加到引用。 View Code View Code 第一种方法性能实在是不敢恭维，而且局限性太多。首先必须要安装 office（如果计算机上面没有的话），而且导出时需要指定文件保存的路径。也可以输出到浏览器下载，当然前提是已经保存写入数据。第二种：使用Aspose.... 阅读详情

  public JsonResult NotSentExport()
        {
            var userID = this.UserID;

            Entities m_Et = new Entities();

            var query = from a in m_Et.DDD_BatchOrder
                        join b in m_Et.InportExcel on a.ExpressNo equals b.R_expressno
                        where a.Enable == 1 && a.Status == 2 && a.DriverID == userID
                        select new
                        {
                            a.BatchOrderID,
                            b.R_date,
                            a.Status,
                            b.R_expressno,
                            b.R_sender,
                            b.R_sendcity,
                            b.R_sendAddress,
                            b.R_sendPostCode,
                            b.R_sendEmail,
                            b.R_telphone,
                            b.R_toname,
                            b.R_sheng,
                            b.R_shi,
                            b.R_address,
                            b.R_postcode,
                            b.R_mobile,
                            b.R_description,
                            b.R_agency,
                            b.R_BranchId,
                            b.R_BusinessId,
                            a.DriverID
                        };


            var ret = query.OrderByDescending(i => i.BatchOrderID).ToList();

            var branchIDs = ret.Select(i => i.R_BranchId).ToList();

            var businessIDs = ret.Select(i => i.R_BusinessId).ToList();

            var branchList = m_BranchLogic.GetListAll(i => branchIDs.Contains(i.Id), i => i.Id,true);

            var businessList = m_BusinessLogic.GetListAll(i => businessIDs.Contains(i.Id), i => i.Id, true);

            var newList = SerializeHelper.SerializeToList(ret);

            for (int i = 0; i < newList.Count; i++)
            {
                var _d = newList[i];

                var status = Convert.ToByte(_d["Status"]);
                switch (status)
                {
                    case 1: _d["Status"] = "未揽收"; break;
                    case 2: _d["Status"] = "已揽收"; break;
                    case 3: _d["Status"] = "问题件"; break;
                    case 4: _d["Status"] = "取消"; break;
                }

                var branchId = Convert.ToInt32(_d["R_BranchId"]);

                var branchEntity = branchList.Where(a => a.Id == branchId).FirstOrDefault();

                if (branchEntity != null)
                {

                    _d["BranchName"] = branchEntity.Branch_name;
                }

                var businessId = Convert.ToInt32(_d["R_BusinessId"]);

                var businessEntity = businessList.Where(a => a.Id == businessId).FirstOrDefault();

                if (businessEntity != null)
                {

                    _d["BusinessName"] = businessEntity.Business_name;
                }

            }

            var path = System.AppDomain.CurrentDomain.BaseDirectory + "/Xml/OrderExport.xml";

            var context = new TemplateContext()
            {
                String = FileHelper.ReadFile(path, Encoding.UTF8),
                TemplateType = "preview",
                Source = new
                {
                    List = Tools.DicToInvariantCultureIgnoreCase(newList),
                    Length = newList.Count + 1,
                }
            };

            TemplateEngine.Current.Run(context);

            var datas = DateTime.Now.ToString("yyyyMMddhhmmss");

            if (query.FirstOrDefault() == null)
            {
                return Json(Result.GetError("暂无数据"), JsonRequestBehavior.AllowGet);
            }

            string fileName = query.FirstOrDefault().DriverID + datas + ".xls";

            //var paths = System.AppDomain.CurrentDomain.BaseDirectory + "/Export";

            string filePath = Path.Combine(HttpRuntime.AppDomainAppPath, "Export") + "/" + fileName;

            string folder = System.Web.HttpContext.Current.Server.MapPath("~/Export");
            if (!Directory.Exists(folder))
            {
                Directory.CreateDirectory(folder);
            }
            using (FileStream fs = new FileStream(folder + "/" + fileName, System.IO.FileMode.Create, System.IO.FileAccess.Write))
            {
                using (StreamWriter sw = new StreamWriter(fs, Encoding.UTF8))
                {
                    sw.WriteLine(context.Result() + "\r\n");
                    return Json(Result.GetSuccess(filePath), JsonRequestBehavior.AllowGet);
                }
            }

            //return Json(Result.GetSuccess(filePath), JsonRequestBehavior.AllowGet);
        }