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);
}
