Add Header and Footer to Excel Worksheets in JAVA

Headers and footers can define your Excel file while you print it, and they can show page numbers, file names, dates, or any other information you like to have on your printed file. Meanwhile, please note that headers and footers are only visible in Print Preview and Page Layout View. You won’t see them in Normal View worksheets.

This article will show you how to add header and footer to Excel using Java codes from the following aspects.

l  Add image header to Excel

l  Add text footer to Excel

l  Add different header and footer for Odd and Even pages

l  Add different header and footer for first page and other pages

DEPENDENCY

I used a free third-party library called Free Spire.XLS for Java to finish operations above. Before running codes, we need to add Spire.Xls.jar to IDEA. There are two methods to do it. One is that downloading the package of the free library from the link, finding Spire.Xls.jar in the “lib” folder and then manually adding it to IDEA. The other is that creating a Maven project in IDEA, typing the following codes in the pom.xml file and finally clicking the button “import changes”.

<repositories>
<repository>
<id>com.e-iceblue</id>
<name>e-iceblue</name>
<url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
</repository>
</repositories>
<dependencies>
<dependency>
<groupId>e-iceblue</groupId>
<artifactId>spire.xls.free</artifactId>
<version>3.9.1</version>
</dependency>
</dependencies>

USING THE CODES
Add image header to Excel
import com.spire.xls.*;
import javax.imageio.ImageIO;
import java.awt.image.BufferedImage;
import java.io.*;

public class ImageHeader {
    public static void main(String[] args) throws IOException {
        //Create a workbook and load a file
        Workbook workbook = new Workbook();

        //Get the first sheet
        Worksheet worksheet = workbook.getWorksheets().get(0);

        //Load an image from disk
        BufferedImage image = ImageIO.read( new File("C:\\Users\\Test1\\Desktop\\Image.png"));

        //Set the image header
        worksheet.getPageSetup().setLeftHeaderImage(image);
        worksheet.getPageSetup().setLeftHeader("&G");

        //Set the view mode as layout
        worksheet.setViewMode(ViewMode.Layout);

        //Save the document to file
        workbook.saveToFile("output/ImageHeader.xlsx", ExcelVersion.Version2010);
    }
}
Output

Add text footer to Excel
import com.spire.xls.*;
public class TextFooter {
    public static void main(String[] args) {
        //Create a workbook and load a file
        Workbook workbook = new Workbook();

        //Get the first sheet
        Worksheet worksheet = workbook.getWorksheets().get(0);

        //Set center footer
        worksheet.getPageSetup().setCenterFooter("technical demo");

        //Set the view mode as layout
        worksheet.setViewMode(ViewMode.Layout);

        //Save the document to file
        workbook.saveToFile("output/TextFooter.xlsx", ExcelVersion.Version2010);
    }
}
Output

Add different header and footer for Odd and Even pages
import com.spire.xls.*;

public class HeaderFooter {
    public static void main(String[] args) {
        //Create a workbook and load a file
        Workbook workbook = new Workbook();

        //Get the first sheet
        Worksheet worksheet = workbook.getWorksheets().get(0);

        worksheet.getCellRange("A1").setText("Page 1");
        worksheet.getCellRange("J1").setText("Page 2");

        //Set different header footer for Odd and Even pages
        worksheet.getPageSetup().setDifferentOddEven((byte)1);

        //Set the header footer with font, size, bold and color
        worksheet.getPageSetup().setOddHeaderString( "&\"Arial\"&12&B&KFFC000 Odd_Header");
        worksheet.getPageSetup().setOddFooterString ( "&\"Arial\"&12&B&KFFC000 Odd_Footer");
        worksheet.getPageSetup().setEvenHeaderString ( "&\"Arial\"&12&B&KFF0000 Even_Header");
        worksheet.getPageSetup().setEvenFooterString ( "&\"Arial\"&12&B&KFF0000 Even_Footer");

        //Set the view mode as layout
        worksheet.setViewMode(ViewMode.Layout);

        //Save the document to file
        workbook.saveToFile("output/DifferentHeaderFooter.xlsx", ExcelVersion.Version2010);
    }
}
Output



Add different header and footer for first page and other pages
import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
public class HeaderFooter2 {
    public static void main(String[] args) {
        //Create a Workbook instance
        Workbook workbook = new Workbook();

        //Get the first worksheet
        Worksheet sheet = workbook.getWorksheets().get(0);

        //Insert text in A1 and J1
        sheet.getCellRange("A1").setText("page 1");
        sheet.getCellRange("J1").setText("page 2");

        //Set different first page
        sheet.getPageSetup().setDifferentFirst((byte)1);

        //Set header string and footer string for the first page
        sheet.getPageSetup().setFirstHeaderString("First header");
        sheet.getPageSetup().setFirstFooterString("First footer");

        //Set header string and footer string for other pages
        sheet.getPageSetup().setCenterHeader("Header of other pages");
        sheet.getPageSetup().setCenterFooter("Footer of other pages");

        //Save the document
        workbook.saveToFile("output/DifferentFirstPage.xlsx", FileFormat.Version2016);
    }
}
Output