Adding Headers Or Footers To A Worksheet In C#

Introduction

Headers or footers are invisible on the worksheet in Normal view. They are only displayed in Page Layout view or the printed pages. We can add the headers or footers at the top or bottom of a printed worksheet to display page number, worksheet name, current data, text or a picture.

In this article, I am going to introduce how to programmatically add the headers or footers to an Excel sheet from the three aspects, given below-

• Add formatted text to the headers or footers.
• Add image to the headers or footers.
• Set different header or footer for odd and even pages.

Background

This solution requires a .NET Excel component, which provides a PageSetup class to deal with all page setup settings. Specifically, it contains LeftHeader, CenterHeader, LeftHeaderImage, OddHeaderString and similar properties to represent header/footer text, image, odd header/footer and even header/footer in Excel. Besides, this component provides some special script commands, which allows you to set header and footer formatting.