private static string GenerarExcel(string razonSocial, string fechaEmision, int PAGE_SIZE = int.MaxValue, int PAGE_NUMBER = 1)
        {
            string path = HttpContext.Current.Server.MapPath("~/Plantillas/");
            string nombreArchivo = string.Format("CxP_{0}.xlsx", DateTime.Now.ToString("yyyyMMdd"));
            path += nombreArchivo;
            CredencialesCE objCredencial = Mod_Utilitario.F_ReturnCredencial();
            System.Data.DataTable dt = new Tst_Ingresos_CobranzaCN().F_ReporteCuentaCobrarPrincipal(razonSocial, fechaEmision, PAGE_SIZE, PAGE_NUMBER);
            int rowNumber = 4;
            if (System.IO.File.Exists(path))
            {
                System.IO.File.Delete(path);

            }
            using (var package = new ExcelPackage())
            {
                ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("REPORTE");
                worksheet.TabColor = System.Drawing.Color.Blue;
                worksheet.Cells["A1:J1"].Value = "REPORTE COBRANZA PRINCIPAL";
                worksheet.Cells["A1:J1"].Merge = true;
                worksheet.Cells["A1:J1"].Style.Font.Size = 14;
                worksheet.Cells["A1:J1"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

                worksheet.Row(3).Height = 20; //fila 3
                //Stilos y Bordes cabecera
                using (var cabecera = worksheet.Cells[3, 1, 3, 10]){
                    cabecera.Style.Border.Top.Style = ExcelBorderStyle.Thin;
                    cabecera.Style.Border.Left.Style = ExcelBorderStyle.Thin;
                    cabecera.Style.Border.Right.Style = ExcelBorderStyle.Thin;
                    System.Drawing.Color colFromHex = System.Drawing.ColorTranslator.FromHtml("#CCCCCC");
                    cabecera.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
                    cabecera.Style.Fill.BackgroundColor.SetColor(colFromHex);
                    cabecera.Style.Font.Bold = true;
                }

                foreach (System.Data.DataColumn columna in dt.Columns)
                {
                    if (columna.Caption == "T_RazonSocial") {
                        worksheet.Cells[rowNumber - 1, 1].Value = "Razón social";
                        worksheet.Column(1).Width=50f;
                    }
                    if (columna.Caption == "F_FechaEmision") {
                        worksheet.Cells[rowNumber - 1, 2].Value = "Emisión";
                        worksheet.Column(2).Width = 14f;
                    }
                    if (columna.Caption == "T_TipoDoc") {
                        worksheet.Cells[rowNumber - 1, 3].Value = "Tipo";
                        worksheet.Column(3).Width = 14f;
                    }
                    if (columna.Caption == "T_NroDocumento") {
                        worksheet.Cells[rowNumber - 1, 4].Value = "Doc";
                        worksheet.Column(4).Width = 16f;
                    }
                    if (columna.Caption == "F_FechaVencimiento") {
                        worksheet.Cells[rowNumber - 1, 5].Value = "Vcto";
                        worksheet.Column(5).Width = 14f;
                    }
                    if (columna.Caption == "N_TipoCambio") worksheet.Cells[rowNumber - 1, 6].Value = "TC";
                    if (columna.Caption == "N_MontoMN") {
                        worksheet.Cells[rowNumber - 1, 7].Value = "Monto";
                        worksheet.Column(7).Width = 25f;
                    }
                    if (columna.Caption == "N_SaldoMN") {
                        worksheet.Cells[rowNumber - 1, 8].Value = "Saldo";
                        worksheet.Column(8).Width = 25f;
                    }
                    if (columna.Caption == "N_MontoME") {
                        worksheet.Cells[rowNumber - 1, 9].Value = "Monto $";
                        worksheet.Column(9).Width = 25f;
                    }
                    if (columna.Caption == "N_SaldoME") {
                        worksheet.Cells[rowNumber - 1, 10].Value = "Saldo $";
                        worksheet.Column(10).Width = 25f;
                    }
                }

                foreach (System.Data.DataRow item in dt.Rows)
                {
                    worksheet.Cells[rowNumber, 1].Value = item["T_RazonSocial"];
                    worksheet.Cells[rowNumber, 2].Value = item["F_FechaEmision"];
                    worksheet.Cells[rowNumber, 3].Value = item["T_TipoDoc"];
                    worksheet.Cells[rowNumber, 4].Value = item["T_NroDocumento"];
                    worksheet.Cells[rowNumber, 5].Value = item["F_FechaVencimiento"];

                    worksheet.Cells[rowNumber, 6].Value = item["N_TipoCambio"];
                    worksheet.Cells[rowNumber, 6].Style.Numberformat.Format = "#,##0.00";

                    worksheet.Cells[rowNumber, 7].Value = item["N_MontoMN"];
                    worksheet.Cells[rowNumber, 7].Style.Numberformat.Format = "#,##0.00";

                    worksheet.Cells[rowNumber, 8].Value = item["N_SaldoMN"];
                    worksheet.Cells[rowNumber, 8].Style.Numberformat.Format = "#,##0.00";

                    worksheet.Cells[rowNumber, 9].Value = item["N_MontoME"];
                    worksheet.Cells[rowNumber, 9].Style.Numberformat.Format = "#,##0.00";

                    worksheet.Cells[rowNumber, 10].Value = item["N_SaldoME"];
                    worksheet.Cells[rowNumber, 10].Style.Numberformat.Format = "#,##0.00";
                    using (var filas = worksheet.Cells[rowNumber, 1, rowNumber, 10])
                    {
                        filas.Style.Border.Top.Style = ExcelBorderStyle.Thin;
                        filas.Style.Border.Left.Style = ExcelBorderStyle.Thin;
                        filas.Style.Border.Right.Style = ExcelBorderStyle.Thin;
                        filas.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
                    }
                    rowNumber++;
                }

                package.SaveAs(new FileInfo(path));
            }

            return nombreArchivo;
        }