public ActionResult GenerarReporteExcel(string ventas) { ExcelExportHelper excel = new ExcelExportHelper(ventaMinoristaBL); DataTable tablaCompras = excel.ArmarExcel(ventas, Constants.VENTA_MINORISTA_EXCEL); string[] columns = { "Id", "Fecha", "Local", "Importe Informe Z", "IVA", "Importe IVA", "Factura nº", "Tipo Factura", "Primer Número Ticket", "Último Número Ticket" }; //byte[] filecontent = ExcelExportHelper.ExportExcel(technologies, "Technology", true, columns); byte[] filecontent = ExcelExportHelper.ExportExcel(tablaCompras, "Reporte Ventas Minoristas", true, columns); string fecha = string.Format("{0}{1}{2}", DateTime.Now.Date.Day, DateTime.Now.Date.Month, DateTime.Now.Date.Year); return(File(filecontent, ExcelExportHelper.ExcelContentType, "ReporteVentaMinorista_" + fecha + ".xlsx")); }
public ActionResult GenerarReporteExcel(string compra) { ExcelExportHelper excel = new ExcelExportHelper(compraBL); DataTable tablaCompras = excel.ArmarExcel(compra, Constants.COMPRA_EXCEL); string[] columns = { "Id", "Proveedor", "CUIT", "IIBB", "Mes Año", "Tipo", "Factura", "Suma Total", "Descuento %", "Descuento", "Subtotal", "IVA", "Importe IVA", "IIBB BSAS", "IIBB CABA", "Percepción IVA", "Clasificación", "Total" }; //byte[] filecontent = ExcelExportHelper.ExportExcel(technologies, "Technology", true, columns); byte[] filecontent = ExcelExportHelper.ExportExcel(tablaCompras, "Reporte Compras", true, columns); string fecha = string.Format("{0}{1}{2}", DateTime.Now.Date.Day, DateTime.Now.Date.Month, DateTime.Now.Date.Year); return(File(filecontent, ExcelExportHelper.ExcelContentType, "ReporteCompra_" + fecha + ".xlsx")); }