/// <summary>
/// Resposne via OutputStream
/// </summary>
/// <param name="package"></param>
/// <param name="Response"></param>
public static void saveAs(rf.OfficeOpenXml.ExcelPackage package, System.Web.HttpResponse Response, string name = "temp.xlsx", string cookieKey = defaultDownloadedCookieKey, string cookieValue = defaultDownloadedCookieValue)
{
try
{
Response.Cookies.Add(new System.Web.HttpCookie(cookieKey, cookieValue));
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}", name));
Response.Clear();
package.SaveAs(Response.OutputStream);
}
catch (Exception ex)
{
}
}
/// <summary>
/// Response via BinaryWrite
/// </summary>
/// <param name="package"></param>
/// <param name="Response"></param>
public static void binaryWrite(rf.OfficeOpenXml.ExcelPackage package, System.Web.HttpResponse Response, string name = "temp.xlsx", string cookieKey = "Downloaded", string cookieValue = "True")
{
try
{
Response.Cookies.Add(new System.Web.HttpCookie(cookieKey, cookieValue));
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=" + name);
Response.Clear();
Response.BinaryWrite(package.GetAsByteArray());
}
catch (Exception ex)
{
}
}
/// <summary>
/// Store ExcelPackage's Stream to Page.Application
/// </summary>
/// <param name="package"></param>
/// <param name="Application"></param>
/// <param name="name"></param>
public static void storeToApplication(rf.OfficeOpenXml.ExcelPackage package, System.Web.HttpApplicationState Application, String name)
{
Application[name] = package.Stream;
}
public Excel(rf.OfficeOpenXml.ExcelPackage excelPackage)
{
this.suffix = Suffix.xlsx;
this.package = excelPackage;
}
