BE THE CODER > Excel > Java Excel API Examples > How to set Spreadsheet Header and Footer

Java Excel API is an open source java library to read, write and modify Excel spread sheets. This requires the library jxl-2.6.12.jar to be in classpath. The following example shows how to set the Header and Footer of an Excel Spread sheet.

File Name :	com/bethecoder/tutorials/jexcelapi/write/SheetHeaderFooterTest.java
Author :	Sudhakar KV
Email :	[email protected]


package com.bethecoder.tutorials.jexcelapi.write;



import java.io.File;

import java.io.IOException;



import jxl.HeaderFooter;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;



public class SheetHeaderFooterTest {



  /**

   * @param args

   * @throws IOException 

   * @throws IOException 

   * @throws WriteException 

   * @throws BiffException 

   */

  public static void main(String[] args) throws IOException, WriteException {

    //Creates a writable workbook with the given file name

    WritableWorkbook workbook = Workbook.createWorkbook(new File("C:/JXL/HeaderFooter.xls"));

    

    //Create sheet and add a label

    WritableSheet sheet = workbook.createSheet("My Sheet", 0);

    

    //Add Header and Footer

      HeaderFooter header = new HeaderFooter();

      header.getLeft().appendWorkbookName();

      header.getCentre().append("BE THE CODER");

      header.getRight().appendWorkSheetName();

      sheet.getSettings().setHeader(header);



      HeaderFooter footer = new HeaderFooter();

      footer.getLeft().appendDate();

      

      footer.getCentre().append("Page ");

      footer.getCentre().appendPageNumber();

      footer.getCentre().append("/");

      footer.getCentre().appendTotalPages();

      

      footer.getRight().appendTime();

      sheet.getSettings().setFooter(footer);

    

    

    sheet.addCell(new Label(1, 2, "ABCD"));

    sheet.addCell(new Label(1, 200, "ABCD"));

    

    //Writes out the data held in this workbook in Excel format

    workbook.write(); 

    

    //Close and free allocated memory 

    workbook.close(); 

  }



}