using OfficeOpenXml;
using System.IO;
public void _Excel()
{
string Ruta_Publica_Excel = Server.MapPath("~/ExcelWeb.xlsx");
if (!string.IsNullOrWhiteSpace(Ruta_Publica_Excel))
{
if (File.Exists(Ruta))
{
File.Delete(Ruta);
}
}
ExcelPackage Package = new ExcelPackage(new System.IO.FileInfo(Ruta_Publica_Excel));
var Hoja_1 = Package.Workbook.Worksheets.Add("Contenido_1");
/*------------------------------------------------------*/
Hoja_1.Cells["A14"].Value = "Mi Nombre es: ";
Hoja_1.Cells["E14"].Value = "JOSE F VASQUEZ - LWP";
/*------------------------------------------------------*/
Package.Save();
/*------------------------------------------------------*/
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition",string.Format("attachment; filename={0}", "ExcelWeb.xlsx"));
Response.BinaryWrite(Package.GetAsByteArray());
#endregion
/*------------------------------------------------------*/
}
Comentarios sobre la versión: 1.0 (0)
No hay comentarios