using System; using System.Text; using System.IO; using NPOI.HSSF.UserModel; using NPOI.HPSF; using NPOI.POIFS.FileSystem; using NPOI.SS.UserModel; namespace CreateHeaderFooterInXls { class Program { static void Main(string[] args) { InitializeWorkbook(); Sheet s1 = hssfworkbook.CreateSheet("Sheet1"); s1.CreateRow(0).CreateCell(1).SetCellValue(123); //set header text s1.Header.Left = "&P"; s1.Header.Center = "This is a test sheet"; //set footer text s1.Footer.Left = "Copyright NPOI Team"; s1.Footer.Right = "created by NPOIExcel(NPOI)"; WriteToFile(); } static HSSFWorkbook hssfworkbook; static void WriteToFile() { //Write the stream data of workbook to the root directory FileStream file = new FileStream(@"test.xls", FileMode.Create); hssfworkbook.Write(file); file.Close(); } static void InitializeWorkbook() { hssfworkbook = new HSSFWorkbook(); //create a entry of DocumentSummaryInformation DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation(); dsi.Company = "NPOI Team"; hssfworkbook.DocumentSummaryInformation = dsi; //create a entry of SummaryInformation SummaryInformation si = PropertySetFactory.CreateSummaryInformation(); si.Subject = "NPOI SDK Example"; hssfworkbook.SummaryInformation = si; } } }