public FileResult exportChartData() { XLExport objExp = new XLExport(Convert.ToString(TempData["processor"])); string flName = objExp.ExcelExportChartData(); return(File(flName, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", Path.GetFileName(flName))); }
public ActionResult generateFile(WMReportInputs input) { try { Response.Cookies.Remove("fileDownload"); repository objRep = new repository(); WMRPTErrViewModel rep = objRep.GetHistory(input); XLExport objExp = new XLExport(rep); string flName = objExp.ExcelExport(); return(Json(new { success = true, fileName = flName }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
static void Main(string[] args) { try { //Run the report and Create the excel sheet attach it to email and send. repository objRepository = new repository(); //Added below two dates for shashank's request for weekly frequency DateTime?startDt, endDt; startDt = endDt = null; startDt = DateTime.Now.AddDays(-Freq); endDt = DateTime.Now; String team = Convert.ToString(args[0]); WMReportDataViewModal objRpt = objRepository.GetRawData(startDt, endDt); XLExport objExport = new XLExport(objRpt); String fileName = objExport.GenerateExcel(ConfigurationManager.AppSettings["ExcelPath"], team); //Send an email with attachment from this file. SendEmail(fileName); Logger.Log(Logger.LogType.Info, "Email Has been generated for the day"); } catch (Exception ex) { Logger.Log(Logger.LogType.Error, ex.ToString()); } }