NPOI_2.1.3 _ Learning Record (5)-create an Excel header and footer and npoi_2.1.3 Header

NPOI_2.1.3 _ Learning Record (5)-create an Excel header and footer and npoi_2.1.3 Header

Add the following code before writing a file based on the Learning Record (3 ):

Sheet1.Header. Right = HeaderFooter. Page; sheet1.Header. Center = "This is a test sheet"; sheet1.Footer. Left = "Copyright NPOI Team"; sheet1.Footer. Right = "created by Murray ";

Generally, only a few headers and footers are used in Excel, and fewer people know it.

I use Excel 2010 to find the header and footer:

As shown in figure: