com.azalient.api.file.xls
Interface PageF

public interface PageF

Workbook formatting utilities for a workbook, applies primarily if book is saved in XLS format

Method Summary

void	comment(int col, int row, String s, int w, int h) Add a comment to a cell
void	footer(String left, String centre, String right) Set the page footer
void	freeze(int rows, int cols) Freeze view from scrolling (a value of -1 for either parameter means unfreeze)
void	header(String left, String centre, String right) Set the page header
void	height(int row, int height) Set row height in points
void	landscape() Set page to print in landscape format (it is portrait by default)
void	lock(String password) lock the page
void	merge(int col1, int row1, int col2, int row2) Merge the given cells
FontF	newCellFont(FontF.FontFace face, int point, boolean bold, boolean italic, boolean underline, NamedColour nc) Get a new font object
FontF	newCellFont(FontF ff) Get a new font object based on an existing font
CellF	newCellFormatter(BookF.DataType dt, CellF.Justification h, CellF.Justification v) Get a new cell formatter
CellF	newCellFormatter(CellF fc) Get a new cell formatter basd on an exisiting one
void	width(int col, int width) Set column width
void	zeroes(boolean b) Show zero values
void	zoom(int z) Set zoom actor for display

Method Detail

newCellFormatter

CellF newCellFormatter(BookF.DataType dt,
                       CellF.Justification h,
                       CellF.Justification v)

Get a new cell formatter

newCellFormatter

CellF newCellFormatter(CellF fc)

Get a new cell formatter basd on an exisiting one

newCellFont

FontF newCellFont(FontF.FontFace face,
                  int point,
                  boolean bold,
                  boolean italic,
                  boolean underline,
                  NamedColour nc)

Get a new font object

newCellFont

FontF newCellFont(FontF ff)

Get a new font object based on an existing font

zeroes

void zeroes(boolean b)

Show zero values

zoom

void zoom(int z)

Set zoom actor for display

freeze

void freeze(int rows,
            int cols)

Freeze view from scrolling (a value of -1 for either parameter means unfreeze)

width

void width(int col,
           int width)

Set column width

height

void height(int row,
            int height)

Set row height in points

comment

void comment(int col,
             int row,
             String s,
             int w,
             int h)

Add a comment to a cell

lock

void lock(String password)

lock the page

header

void header(String left,
            String centre,
            String right)

Set the page header

footer

void footer(String left,
            String centre,
            String right)

Set the page footer

landscape

void landscape()

Set page to print in landscape format (it is portrait by default)

merge

void merge(int col1,
           int row1,
           int col2,
           int row2)

Merge the given cells