public ActionResult ExportarExcel() { Microsoft.Office.Interop.Excel.Application application = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook workbook = application.Workbooks.Add(System.Reflection.Missing.Value); Microsoft.Office.Interop.Excel.Worksheet worksheet = workbook.ActiveSheet; worksheet.Cells[1, 1] = "Tecnico"; worksheet.Cells[1, 2] = "Fecha Inicio"; worksheet.Cells[1, 3] = "Fecha Fin"; worksheet.Cells[1, 4] = "Tarea"; worksheet.Cells[1, 5] = "Horas Totales"; AccesoBD miBD = new AccesoBD(); List <Tarea> ListaTareas = miBD.DevolverTareasLista((string)Session["proyecto"], (string)Session["criterio"], (string)Session["cadena"]); int fila = 2; foreach (Tarea tarea in ListaTareas) { worksheet.Cells[fila, 1] = tarea.Tecnico; worksheet.Cells[fila, 2] = tarea.FechaInicio; worksheet.Cells[fila, 3] = tarea.FechaFin; worksheet.Cells[fila, 4] = tarea.Nombre; worksheet.Cells[fila, 5] = tarea.HorasReales; } workbook.SaveAs(ControllerContext.HttpContext.Server.MapPath("~/Exportados/example.xls")); workbook.Close(); Marshal.ReleaseComObject(workbook); application.Quit(); Marshal.FinalReleaseComObject(application); return(RedirectToAction("Tareas", "Jefe", new { @proyecto = Session["proyecto"], @criterio = Session["criterio"], @cadena = Session["cadena"] })); }
public ActionResult MostrarLista(string proyecto, string criterio, string cadena) { AccesoBD miBD = new AccesoBD(); List <Tarea> tareas = miBD.DevolverTareasLista(proyecto, criterio, cadena); ViewBag.ListaTareas = tareas; Session["proyecto"] = proyecto; Session["criterio"] = criterio; Session["cadena"] = cadena; return(View()); }