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(); } }