Exemple #1
0
        public FileStreamResult ExcelExport(Parameters parameters_)
        {
            ex.mainmodel  = mm;
            ex.parameters = parameters_;
            string filename = Path.Combine(Server.MapPath(@"~/App_Data"), @"report.xlsx");

            parameters_.formatSelcted  = param.DateFormatReturn;
            parameters_.entitySelected = param.EntityReturn;

            ex.QueryFromParameters(db, parameters_);

            if (System.IO.File.Exists(filename))
            {
                System.IO.File.Delete(filename);
            }
            //System.IO.File.Create(filename);
            // pm.ExportToExcel(pm.FD_ACQ, filename);

            ex.ExcelExport(filename, mm);

            return(new FileStreamResult(new FileStream(filename, FileMode.Open), "application/vnd.openxmlformats-officedocument.spreadsheet.sheet"));
        }