In Excel files, headers and footers provide rich content at the top and bottom of worksheet pages. The content can include a logo, company name, page number, date, and time, etc. This article shows you how to add text, images, as well as fields (like page numbers) to Excel headers or footers using Spire.XLS for .NET.

• Add an Image and Formatted Text to Excel Header
• Add the Current Date and Page Numbers to Excel Footer

Spire.XLS for .NET provides the PageSetup class to work with the page setup in Excel including headers and footers. Specifically, it contains LeftHeader property, CenterHeader property, RightHeader property, LeftFooter property, etc. to represent the left section, center section and right section of a header or footer. To add fields to headers or footers, or to apply formatting to text, you’ll need to use the scripts listed in the following table.

Install Spire.XLS for .NET

To begin with, you need to add the DLL files included in the Spire.XLS for.NET package as references in your .NET project. The DLL files can be either downloaded from this link or installed via NuGet.

PM> Install-Package Spire.XLS

Add an Image and Formatted Text to Excel Header

The following are the steps to add an image and formatted text to the header of an existing Excel document using Spire.XLS for .NET.

• Create a Workbook object, and load a sample Excel file using Workbook.LoadFromFile() method.
• Get a specific worksheet through the Workbook.Worksheets[index] property.
• Load an image, scale it and set it as the image source of the left header through the PageSetup.LeftHeaderImage property.
• Display image in the left header section by setting the PageSetup.LeftHeader property to “&G”.
• Save the workbook to another Excel file using Workbook.SaveToFile() method.

using Spire.Xls;
using System.Drawing;

namespace AddImageAndTextToHeader
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook object
            Workbook wb = new Workbook();

            //Load an existing Excel file
            wb.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx");

            //Get the first worksheet
            Worksheet sheet = wb.Worksheets[0];

            //Load an image
            Image image = Image.FromFile(@"C:\Users\Administrator\Desktop\your-logo.png");

            //Scale the image
            Bitmap bitmap = new Bitmap(image, new Size(image.Width / 2, image.Height / 2));

            //Add image to header’s left section
            sheet.PageSetup.LeftHeaderImage = bitmap;
            sheet.PageSetup.LeftHeader = "&G";

            //Add formatted text to header’s right section
            sheet.PageSetup.RightHeader = "&\"Calibri\"&B&10&K4253E2Your Company Name \n Goes Here";

            //Save the file
            wb.SaveToFile("Header.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls
Imports System.Drawing

Namespace AddImageAndTextToHeader
    Class Program
        Shared  Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim wb As Workbook = New Workbook()
 
            'Load an existing Excel file
            wb.LoadFromFile("C:\Users\Administrator\Desktop\sample.xlsx")
 
            'Get the first worksheet
            Dim sheet As Worksheet = wb.Worksheets(0)
 
            'Load an image
            Dim image As Image = Image.FromFile("C:\Users\Administrator\Desktop\your-logo.png")
 
            'Scale the image
            Dim bitmap As Bitmap = New Bitmap(image, New Size(image.Width / 2, image.Height / 2)) 
 
            'Add image to header’s left section
            sheet.PageSetup.LeftHeaderImage = bitmap
            sheet.PageSetup.LeftHeader = "&G"
 
            'Add formatted text to header’s right section
            sheet.PageSetup.RightHeader = "&\"Calibri\"&B&10&K4253E2Your Company Name \n Goes Here"
 
            'Save the file
            wb.SaveToFile("Header.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace

Add the Current Date and Page Numbers to Excel Footer

The following are the steps to add the current date and page numbers to the footer of an existing Excel document using Spire.XLS for .NET.

• Create a Workbook object, and load a sample Excel file using Workbook.LoadFromFile() method.
• Get a specific worksheet through the Workbook.Worksheets[index] property.
• Add page numbers with formatting to the left footer section by setting the PageSetup.LeftFooter property to “&\"Calibri\"&B&10&K4253E2Page &P”.  You can customize the page numbers’ formatting according to your preference.
• Add the current date to the right footer section by setting the PageSetup.RightFooter property to “&\"Calibri\"&B&10&K4253E2&D”. Likewise, you can change the appearance of the date string as desired.
• Save the workbook to another Excel file using Workbook.SaveToFile() method.

using Spire.Xls;

namespace AddDateAndPageNumberToFooter
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a Workbook object
            Workbook wb = new Workbook();

            //Load an exsting Excel file
            wb.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx");

            //Get the first worksheet
            Worksheet sheet = wb.Worksheets[0];

            //Add page number to footer's left section
            sheet.PageSetup.LeftFooter = "&\"Calibri\"&B&10&K4253E2Page &P";

            //Add current date to footer's right section
            sheet.PageSetup.RightFooter = "&\"Calibri\"&B&10&K4253E2&D";

            //Save the file
            wb.SaveToFile("Footer.xlsx", ExcelVersion.Version2016);
        }
    }
}

Imports Spire.Xls

Namespace AddDateAndPageNumberToFooter
    Class Program
        Shared Sub Main(ByVal args() As String)
            'Create a Workbook object
            Dim wb As Workbook = New Workbook()
 
            'Load an exsting Excel file
            wb.LoadFromFile("C:\Users\Administrator\Desktop\sample.xlsx")
 
            'Get the first worksheet
            Dim sheet As Worksheet = wb.Worksheets(0)
 
            'Add page number to footer's left section
            sheet.PageSetup.LeftFooter = "&\"Calibri\"&B&10&K4253E2Page &P"
 
            'Add current date to footer's right section
            sheet.PageSetup.RightFooter = "&\"Calibri\"&B&10&K4253E2&D"
 
            'Save the file
            wb.SaveToFile("Footer.xlsx", ExcelVersion.Version2016)
        End Sub
    End Class
End Namespace

Apply for a Temporary License

If you'd like to remove the evaluation message from the generated documents, or to get rid of the function limitations, please request a 30-day trial license for yourself.

During software development, developers may need to convert Word to HTML. Different from many available ways on Internet, in this example, the solution for converting Word to HTML enables WPF developers load a predefined Doc, Docx, or RTF document, fill it with data, convert the document to HTML.

Spire.Doc for WPF is a professional component specializing in manipulating Word document for WPF. To convert a Word to HTML simply in WPF, developers need to invoke document.LoadFromFile(), which is used to load document and document.SaveToFile(), which is used to convert document.

The following screenshot shows parts of contents of original Word document. The target HTML is at the bottom after this coding. It is shown in Firefox, same as the original document.

Download and install Spire.Doc for WPF on your system. Then, add a button in MainWindow and double click it to use the following code to convert Word to HTML in WPF

using Spire.Doc;
using System.Windows;

namespace WpfApplication1
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, RoutedEventArgs e)
        {
            //Load Document
            Document document = new Document();
            document.LoadFromFile(@"E:\work\Documents\Humor Them.docx");

            //Convert to HTML
            document.SaveToFile("ToHTML.html", FileFormat.Html);

            //Launch Document
            System.Diagnostics.Process.Start("ToHTML.html");

        }



    }
}

Imports Spire.Doc
Imports System.Windows

Namespace WpfApplication1
	Public Partial Class MainWindow
		Inherits Window
		Public Sub New()
			InitializeComponent()
		End Sub
		Private Sub button1_Click(sender As Object, e As RoutedEventArgs)
			'Load Document
			Dim document As New Document()
			document.LoadFromFile("E:\work\Documents\Humor Them.docx")

			'Convert to HTML
			document.SaveToFile("ToHTML.html", FileFormat.Html)

			'Launch Document
			System.Diagnostics.Process.Start("ToHTML.html")

		End Sub



	End Class
End Namespace

After running, you can get the result as following:

Spire.Doc is an Microsoft Word component which enables users to perform a wide range of Word document processing tasks directly, such as generate, read, write and modify Word document in WPF, .NET and Silverlight.

Software developers are often asked to find a way to convert Microsoft Excel into PDF as PDF files are widely used for exchanging documents between organizations, government sectors and individuals. This solution demonstrates a way of converting Excel  to PDF for WPF developers and maintains high visual fidelity in the conversion.

Spire.XLS for WPF is a WPF Excel component which enables your WPF applications to fast generate, read, write and modify Excel document without Microsoft Office Excel Automation. It also fully supports converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image and Excel to XML. All the conversion is independent of any other software.

Any kind of trial and evaluation is always welcomed. Please feel free to download Spire.XLS for WPF to have a trial and convert your Excel to PDF for personal use. Below is a screenshot of the source Excel file we load in this demo. At the end, a screenshot of PDF will be demonstrated for comparison with the source Excel file.

Now this is the key procedure for converting Excel to PDF in WPF.

Step 1: Load Excel file or Create Excel from scratch.

In this step, instantiate an object of the Workbook class by calling its empty constructor and then you may open/load an existing template file or skip this step if you are creating the workbook from scratch.

// load Excel file
Workbook workbook = new Workbook();
workbook.LoadFromFile("D:\\test.xlsx");                  

[VB.NET]

' load Excel file
Dim workbook As New Workbook()
workbook.LoadFromFile("D:\test.xlsx")

Step 2: Set PDF template.

In this step, we will set PDF template which will be used below.

// Set PDF template
PdfDocument pdfDocument = new PdfDocument();
pdfDocument.PageSettings.Orientation = PdfPageOrientation.Landscape;
pdfDocument.PageSettings.Width = 970;
pdfDocument.PageSettings.Height = 850;                  

' Set PDF template
Dim pdfDocument As New PdfDocument()
pdfDocument.PageSettings.Orientation = PdfPageOrientation.Landscape
pdfDocument.PageSettings.Width = 970
pdfDocument.PageSettings.Height = 850

Step 3: Convert Excel to PDF in WPF.

Now we will use the template which we have already set above to convert Excel to PDF in WPF.

//Convert Excel to PDF using the template above
PdfConverter pdfConverter = new PdfConverter(workbook);
PdfConverterSettings settings = new PdfConverterSettings();
settings.TemplateDocument = pdfDocument;
pdfDocument = pdfConverter.Convert(settings);            

'Convert Excel to PDF using the template above
Dim pdfConverter As New PdfConverter(workbook)
Dim settings As New PdfConverterSettings()
settings.TemplateDocument = pdfDocument
pdfDocument = pdfConverter.Convert(settings)

Step 4: Save and preview PDF.

Please use the codes below to save and preview PDF.

// Save and preview PDF
pdfDocument.SaveToFile("sample.pdf");
System.Diagnostics.Process.Start("sample.pdf");        

' Save and preview PDF
pdfDocument.SaveToFile("sample.pdf")
System.Diagnostics.Process.Start("sample.pdf")

The picture below is a screenshot of the PDF, Please see: