/*
 * (c) Copyright 2001 MyCorporation.
 * All Rights Reserved.
 */

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;


/**
 * @version 	1.0
 * @author
 */
public class HeaderFooterTest {

    public static void main(String[] args) throws Exception {
        // create a new workbook
        HSSFWorkbook workbook = new HSSFWorkbook();

        // create a new worksheet within the workbook
        HSSFSheet sheet = workbook.createSheet("Header/Footer Test");
        
        // set the header and footer values
        sheet.getHeader().setLeft("left header");
        sheet.getHeader().setCenter("center header");
        sheet.getHeader().setRight("right header");
        
        sheet.getFooter().setLeft("left footer");
        sheet.getFooter().setCenter("center footer");
        sheet.getFooter().setRight("right footer");
        
        // retrieve the header/footer values and print them out
        System.out.println("left header: " + sheet.getHeader().getLeft());
        System.out.println("center header: " + sheet.getHeader().getCenter());
        System.out.println("right header: " + sheet.getHeader().getRight());
        
        System.out.println("left footer: " + sheet.getFooter().getLeft());
        System.out.println("center footer: " + sheet.getFooter().getCenter());
        System.out.println("right footer: " + sheet.getFooter().getRight());
        
        // insert some rows of data
        for (short i = 0; i < 10; i++) {
            HSSFRow row = sheet.createRow(i);
            for (short j = 0; j < 10; j++) {
                HSSFCell cell = row.createCell(j);
                cell.setCellValue(i + "," + j);
            }
        }
        
        // write out the spreadsheet
        workbook.write(new FileOutputStream(args[0]));
    }
}