public ExcelFileResult ExportExcel(int year, int Quarter) { TrainingPlanViewModel obj = new TrainingPlanViewModel(); TrainingPlanModel objModel = new TrainingPlanModel(); objModel.Year = year; objModel.Quarter = Quarter; //obj.ListTrainingPan = _ItrainingService.GetTrainingPlan(objModel); DataTable dt = _ItrainingService.GetTrainingPlanDataSet(objModel); dt.Columns.Remove("TrainingPlanId"); dt.Columns.Remove("Quarter"); dt.Columns.Remove("TrainingId"); dt.Columns.Remove("TrainingTypeId"); dt.Columns.Remove("month"); dt.Columns.Remove("isActive"); // DataTable dt = -- > get your data ExcelFileResult actionResult = new ExcelFileResult(dt) { FileDownloadName = "TrainingPlan.xls" }; //ExcelFileResult actionResult = new ExcelFileResult(dt) { FileDownloadName = string.Format("TrainingPlan{0}.xls", trainingcourseid) }; return(actionResult); }
public async Task <IActionResult> ExportToExcel(int reportID, [FromBody] IList <Filter> filters) { var tabularReport = await _reportService.GetTabularReport(reportID, true, filters); var result = new ExcelFileResult(tabularReport.Data, tabularReport.Report.ColumnDefinitions); return(result); }
public ExcelFileResult exportarExcel(string nombreArchivo) { nombreArchivo += ".xls"; ExcelFileResult actionResult = null; actionResult = new ExcelFileResult(dtReportPresencia) { FileDownloadName = nombreArchivo.ToString() }; dtVenta = null; return(actionResult); }