package org.apache.poi.xssf.usermodel.examples;

import java.io.FileOutputStream;

import org.apache.poi.ss.usermodel.Footer;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class PageNumberOnFooter {

    public static void main(String[]args) throws Exception{

	   Workbook wb = new XSSFWorkbook();

	   Sheet sheet = wb.createSheet("format sheet");

	   sheet.createRow(0).createCell(0).setCellValue(123);

	   Footer footer = sheet.getFooter();

	   //&P == current page number

	   //&N == page numbers

	    footer.setRight( "Page &P of &N" );

	    // Create various cells and rows for spreadsheet.

	    FileOutputStream fileOut = new FileOutputStream("pageNumerOnFooter.xlsx");

	    wb.write(fileOut);

	    fileOut.close();

    }

}

package org.apache.poi.xssf.usermodel.examples;

import java.io.FileOutputStream;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class SelectedSheet {

    public static void main(String[]args) throws Exception{

	Workbook wb = new XSSFWorkbook();

	Sheet sheet = wb.createSheet("row sheet");

	Sheet sheet2 = wb.createSheet("another sheet");

	Sheet sheet3 = wb.createSheet(" sheet 3 ");

	sheet3.setSelected(true);

	// Create various cells and rows for spreadsheet.

	FileOutputStream fileOut = new FileOutputStream("selectedSheet.xlsx");

	wb.write(fileOut);

	fileOut.close();

    }

}

package org.apache.poi.xssf.usermodel.examples;

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFFont;

import org.apache.poi.hssf.util.HSSFColor;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.CreationHelper;

import org.apache.poi.ss.usermodel.Font;

import org.apache.poi.ss.usermodel.Hyperlink;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.xssf.usermodel.XSSFHyperlink;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class HyperlinkExample {

    public static void main(String[]args) throws Exception{

	    Workbook wb = new XSSFWorkbook();

	    //cell style for hyperlinks

	    //by default hypelrinks are blue and underlined

	    CellStyle hlink_style = wb.createCellStyle();

	    Font hlink_font = wb.createFont();

	    hlink_font.setUnderline(HSSFFont.U_SINGLE);

	    hlink_font.setColor(HSSFColor.BLUE.index);

	    hlink_style.setFont(hlink_font);

	    Cell cell;

	    Sheet sheet = wb.createSheet("Hyperlinks");

	    CreationHelper createHelper = wb.getCreationHelper();

	    //URL

	    cell = sheet.createRow(0).createCell((short)0);

	    cell.setCellValue("URL Link");  

	    Hyperlink link = createHelper.createHyperlink(Hyperlink.LINK_URL);

	    link.setAddress("http://poi.apache.org/");

	    cell.setHyperlink(link);

	    cell.setCellStyle(hlink_style);

	    //link to a file in the current directory

	    cell = sheet.createRow(1).createCell((short)0);

	    cell.setCellValue("File Link");

	    link = createHelper.createHyperlink(Hyperlink.LINK_FILE);

	    link.setAddress("link1.xls");

	    cell.setHyperlink(link);

	    cell.setCellStyle(hlink_style);

	    //e-mail link

	    cell = sheet.createRow(2).createCell((short)0);

	    cell.setCellValue("Email Link");

	    link = createHelper.createHyperlink(Hyperlink.LINK_EMAIL);

	    //note, if subject contains white spaces, make sure they are url-encoded

	    link.setAddress("mailto:poi@apache.org?subject=Hyperlinks");

	    cell.setHyperlink(link);

	    cell.setCellStyle(hlink_style);

	    //link to a place in this workbook

	    //create a target sheet and cell

	    Sheet sheet2 = wb.createSheet("Target Sheet");

	    sheet2.createRow(0).createCell((short)0).setCellValue("Target Cell");

	    cell = sheet.createRow(3).createCell((short)0);

	    cell.setCellValue("Worksheet Link");

	    XSSFHyperlink link2 = (XSSFHyperlink)createHelper.createHyperlink(Hyperlink.LINK_DOCUMENT);

	    link2.setAddress("'Target Sheet'!A1");

	    link2.setLocation("'Target Sheet'!A1");

	    cell.setHyperlink(link2);

	    cell.setCellStyle(hlink_style);

	    FileOutputStream out = new FileOutputStream("hyperinks.xlsx");

	    wb.write(out);

	    out.close();

    }

}

	public String getLocation() {

		return ctHyperlink.getLocation();

	}

	public void setLocation(String location){

		ctHyperlink.setLocation(location);

	}