In this section, you will learn how to create footer on a sheet using Apache POI.

Excel Sheet Footer

In this section, you will learn how to create footer on a sheet using Apache POI.

In the given below example, we will create footers having different position on sheet. These footers will appear on the hardcopy(print out) . You can see this by taking print preview of the sheet.

Given below the code :

import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFHeader;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Footer;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

public class XLFooter {
public static void main(String args[]) throws IOException {
Workbook wb = new HSSFWorkbook();
CreationHelper createHelper = wb.getCreationHelper();
Sheet sheet = wb.createSheet("new sheet");

Row row = sheet.createRow((short) 0);
// Create a cell and put a value in it.
row.createCell(0).setCellValue(
createHelper.createRichTextString("Take Print Preview to View Footers"));
Footer footer= sheet.getFooter();
footer.setRight("A Roseindia Product");
footer.setCenter("Center Footer");
footer.setLeft("Left Footer");
footer.setRight(HSSFHeader.font("Stencil-Normal", "Italic")
+ HSSFHeader.fontSize((short) 10) + "A Roseindia Product");

FileOutputStream fileOut = new FileOutputStream(
"xls/workbookFooters.xls");
wb.write(fileOut);
fileOut.close();
}
}

OUTPUT

When you take its print preview, the footers will appear like below :

Download Source Code

Related Tags for Excel Sheet Footer:

More Tutorials from this section

• Create Simple Excel(.xls) document using Apache POI
• Create Excel(.xlsx) document using Apache POI
• Read Simple Excel(.xls) document using Apache POI
• Read Excel(.xlsx) document using Apache POI
• Format Cell of Simple Excel Sheet(.xls)
• Checking Date Value of Excel Cells
• Drawing a Shape in Excel Sheet
• Excel Freeze Pane Feature
• Insert Image into Excel Sheet
• Set Zoom Magnification of Excel Sheet
• Excel Sheet Footer
• Excel Sheet Header
• Excel Splits Pane Feature
• Identify Excel's cell data type
• Apache POI API for Microsoft Doc's Manipulation
• Excel Cell Comment
• Excel Cell Drop Down List
• Excel Data validation
• Excel Prompt User on Focus
• Creating Shapes using Shape Groups