public Excel(rf.NPOI.HSSF.UserModel.HSSFWorkbook workbook)
{
hssfworkbook = workbook;
////create a entry of DocumentSummaryInformation
rf.NPOI.HPSF.DocumentSummaryInformation dsi = rf.NPOI.HPSF.PropertySetFactory.CreateDocumentSummaryInformation();
dsi.Company = "rf.NPOI Team";
hssfworkbook.DocumentSummaryInformation = dsi;
////create a entry of SummaryInformation
rf.NPOI.HPSF.SummaryInformation si = rf.NPOI.HPSF.PropertySetFactory.CreateSummaryInformation();
si.Subject = "rf.NPOI SDK Example";
hssfworkbook.SummaryInformation = si;
}
/// <summary>
/// Resposne via OutputStream
/// </summary>
/// <param name="package"></param>
/// <param name="Response"></param>
public static void saveAs(rf.NPOI.HSSF.UserModel.HSSFWorkbook hssfworkbook, System.Web.HttpResponse Response, string name = "temp.xls", 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();
System.IO.MemoryStream file = new System.IO.MemoryStream();
hssfworkbook.Write(file);
file.WriteTo(Response.OutputStream);
}
catch (Exception ex)
{
}
}
public Excel()
{
this.package = new rf.OfficeOpenXml.ExcelPackage();
hssfworkbook = new rf.NPOI.HSSF.UserModel.HSSFWorkbook();
}
