ExcelMakerExample

Create Excel By Three Simple Steps

First

You Must Install ExcelMaker Nuget

Second

You Must AddService ExcelMaker in Startup

---

ExcelMaker.Startup.ConfigureService(services)

---

Third : Use Sql Query

*** Attention : To Use SqlQuery You Need Configure Dapper

Use : var queryList = new QueryViewModel()

Add Query : queryList.AddQuery(SqlQuery, Excel Worksheet Name,TableStyles)

Use Method : var file = _excelMaker.ExcelMakeByQuery(queryList.GetList())

And you must return File : return File(file, _excelMaker.ContentType(), "MyFile.xlsx")

Third : Use Dynamic List

Use : var dynamicList = new DynamicListViewModel()

Add List : dynamicList.AddList<@ListType>(YourList, WorkSheet Name, TableStyles);

Use Method : var file = _excelMaker.ExcelMakeByList(dynamicList.GetList());

And you must return File : return File(file, _excelMaker.ContentType(), "MyFile.xlsx")