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(); }