public IActionResult UseQuery() { var queryList = new QueryViewModel(); queryList.AddQuery("select top 100 * from Person where IsMale = 0", "Female Person", TableStyles.Medium2); queryList.AddQuery("select * from Country", "Country", TableStyles.Medium20); queryList.AddQuery("select * from Car", "Car", TableStyles.Dark2); queryList.AddQuery("select top 100 * from Person where IsMale = 1", "Male Person", TableStyles.Dark10); // To use this method you need to configure the Dapper // See DataLayerConfiguration section var file = _excelMaker.ExcelMakeByQuery(queryList.GetList()); if (file == null) { return(Json("Excel could not be made")); } return(File(file, _excelMaker.ContentType(), "MyFile.xlsx")); }