ASP.NET MVC5 - AngularJS, Create XLS file using ExcelPackage

using System; 
using System.Collections.Generic; 
using System.Data.Entity; 
using System.Data.Entity.Infrastructure; 
using System.Linq; 
using System.Net; 
using System.Net.Http; 
using System.Web.Http; 
using SampleEF6.Models; 
using System.Threading.Tasks; 
using System.Web; 
using System.IO; 
using System.Net.Http.Headers; 
 
namespace SampleEF6.Controllers 
{ 
    public class ReportController : ApiController 
    { 
        // GET api/<controller> 
        [HttpGet] 
        public async Task<httpresponsemessage> GetXLSReport() 
        { 
            string fileName = string.Concat("Contacts.xls"); 
            string filePath = HttpContext.Current.Server.MapPath("~/Report/" + fileName); 
 
            ContactController contact = new ContactController(); 
            List<contact> contacList = contact.Get().ToList(); 
 
            await SampleEF6.Report.ReportGenerator.GenerateXLS(contacList, filePath); 
 
            HttpResponseMessage result = null; 
            result = Request.CreateResponse(HttpStatusCode.OK); 
            result.Content = new StreamContent(new FileStream(filePath, FileMode.Open)); 
            result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); 
            result.Content.Headers.ContentDisposition.FileName = fileName; 
 
            return result; 
        } 
    } 
}
</contact></httpresponsemessage></controller>

 Create the GenerateXLS method like this:

using OfficeOpenXml; 
using OfficeOpenXml.Style; 
using SampleEF6.Models; 
using System; 
using System.Collections.Generic; 
using System.Drawing; 
using System.IO; 
using System.Linq; 
using System.Reflection; 
using System.Threading.Tasks; 
using System.Web; 
 
namespace SampleEF6.Report 
{ 
    public class ReportGenerator 
    { 
        public static Task GenerateXLS(List<contact> datasource, string filePath) 
        { 
            return Task.Run(() => 
            { 
                using (ExcelPackage pck = new ExcelPackage()) 
                { 
                    //Create the worksheet 
                    ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Contacts"); 
 
                    ws.Cells[1, 1].Value = "Id"; 
                    ws.Cells[1, 2].Value = "Name"; 
                    ws.Cells[1, 3].Value = "Address"; 
                    ws.Cells[1, 4].Value = "City"; 
                    ws.Cells[1, 5].Value = "Country"; 
 
                    for (int i = 0; i < datasource.Count(); i++) 
                    { 
                        ws.Cells[i + 2, 1].Value = datasource.ElementAt(i).Id; 
                        ws.Cells[i + 2, 2].Value = datasource.ElementAt(i).Name; 
                        ws.Cells[i + 2, 3].Value = datasource.ElementAt(i).Address; 
                        ws.Cells[i + 2, 4].Value = datasource.ElementAt(i).City; 
                        ws.Cells[i + 2, 5].Value = datasource.ElementAt(i).Country; 
                    } 
 
                    using (ExcelRange rng = ws.Cells["A1:A5"]) 
                    { 
                        rng.Style.Font.Bold = true; 
                        rng.Style.Fill.PatternType = ExcelFillStyle.Solid;        //Set Pattern for the background to Solid 
                        rng.Style.Fill.BackgroundColor.SetColor(Color.DarkGray);  //Set color to DarkGray 
                        rng.Style.Font.Color.SetColor(Color.Black); 
                    } 
 
                    pck.SaveAs(new FileInfo(filePath)); 
                } 
            }); 
        } 
    } 
}
</contact>

STEP 4 - Run Application

Resources

• My personal blog: http://joaoeduardosousa.wordpress.com/
• EPPlus-Create advanced Excel spreadsheets on the server