WorkbookDesigner mvc里面返回file

最新推荐文章于 2021-02-22 01:22:38 发布

weixin_30278311

最新推荐文章于 2021-02-22 01:22:38 发布

阅读量96

点赞数

原文链接：http://www.cnblogs.com/muer/p/WorkbookDesigner_mg.html

版权

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace test.Controllers
{
    using System.Data;
    using System.IO;
    using Aspose.Cells;


    public class ExcelController : Controller
    {
        public FileResult excels()
        {
            DataTable dt = new DataTable();
            dt.TableName = "table1";
            dt.Columns.Add(new DataColumn("ROW1", typeof(string)));
            dt.Columns.Add(new DataColumn("ROW12", typeof(string)));
            DataRow dr;
            for (int i = 0; i <= 10; i++)
            {
                dr = dt.NewRow();
                dr["ROW1"] = Guid.NewGuid().ToString();
                dr["ROW12"] = Guid.NewGuid().ToString();
                dt.Rows.Add(dr);
            }

            WorkbookDesigner designer = new WorkbookDesigner();
            string path = Server.MapPath("/Templete/DDD.xls");
            designer.Workbook.Open(path);
            designer.SetDataSource(dt);
            designer.Process();

            //将文件存在服务器端，名称是123.xls
            designer.Save(Server.MapPath("/Templete/123.xls"), FileFormatType.Default);

            //将服务器端的文件/Templete/123.xls下载到客户端
            return File(Server.MapPath("/Templete/123.xls"), "application/ms-excel", "dsds.xls");

            //将流文件写到客户端流的形式写到客户端，名称是_report.xls
           //designer.Save("_report.xls", SaveType.OpenInExcel, FileFormatType.Excel2003, System.Web.HttpContext.Current.Response);
           // Response.Flush();
           //Response.Close();
          //designer = null;
           // Response.End();
           // return View("getexcel");

        }