Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep
Overview  Package  Class  Use  Deprecated   Index 
Home >> All >> org >> apache >> cocoon >> poi >> hssf >> [ usermodel overview ]  PREV  NEXT
A B C D E F G H I L M O P R S T U V W Y

A

ALIGN_CENTER - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
center horizontal alignment
ALIGN_CENTER_SELECTION - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
center-selection? horizontal alignment
ALIGN_FILL - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
fill? horizontal alignment
ALIGN_GENERAL - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
general (normal) horizontal alignment
ALIGN_JUSTIFY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
justified horizontal alignment
ALIGN_LEFT - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
left-justified horizontal alignment
ALIGN_RIGHT - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
right-justified horizontal alignment
AQUA - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
AUTOMATIC - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
addCell(HSSFCell, boolean) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
used internally to add a cell.
addCellsFromRow(HSSFRow) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
used internally to add cells from a high level row to the low level model
addRow(HSSFRow, boolean) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
add a row to the sheet

B

BLUE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
BLUE_GREY - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
BOLDWEIGHT_BOLD - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
Bold boldness (bold)
BOLDWEIGHT_NORMAL - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
Normal boldness (not bold)
BORDER_DASHED - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
dash border
BORDER_DASH_DOT - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
dash-dot border
BORDER_DASH_DOT_DOT - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
dash-dot-dot border
BORDER_DOTTED - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
dot border
BORDER_DOUBLE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
double-line border
BORDER_HAIR - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
hair-line border
BORDER_MEDIUM - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
Medium border
BORDER_MEDIUM_DASHED - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
Medium dashed border
BORDER_MEDIUM_DASH_DOT - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
medium dash-dot border
BORDER_MEDIUM_DASH_DOT_DOT - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
medium dash-dot-dot border
BORDER_NONE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
No border
BORDER_SLANTED_DASH_DOT - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
slanted dash-dot border
BORDER_THICK - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
Thick border
BORDER_THIN - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
Thin border
BRIGHT_GREEN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
BROWN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
book - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
book - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
reference to containing low level Workbook
book - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
 

C

CELL_TYPE_BLANK - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
Blank Cell type (3)
CELL_TYPE_FORMULA - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
Formula Cell type (2)
CELL_TYPE_NUMERIC - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
Numeric Cell type (0)
CELL_TYPE_STRING - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
String Cell type (1)
COLOR_NORMAL - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
normal type of black color
COLOR_RED - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
Dark Red color
cellNum - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
cellStyle - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
cellType - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
cellValue - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
cells - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
 
createCell(short, int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
Use this to create new cells within the row and return it.
createCellFromRecord(CellValueRecordInterface) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
create a high level HSSFCell object from an existing low level record.
createCellStyle() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
create a new Cell style and add it to the workbook's style table
createFont() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
create a new Font and add it to the workbook's font table
createRow(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Create a new row within the sheet and return the high level representation
createRowFromRecord(RowRecord) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Used internally to create a high level Row object from a low level row object.
createSheet() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation.
createSheet(String) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation.

D

DARK_BLUE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
DARK_GREEN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
DARK_RED - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
DARK_TEAL - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
DARK_YELLOW - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
DO_NOT_REPLACE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
determineType(CellValueRecordInterface) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
used internally -- given a cell value record, figure out its type

E

EMPLOYEE_INFORMATION - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
ENCODING_COMPRESSED_UNICODE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
ENCODING_UTF_16 - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
encoding - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 

F

FIRST_NAME_KEY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
FIRST_NAME_VALUE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
FONT_ARIAL - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
Arial font
findFirstRow(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
used internally to refresh the "first row" when the first row is removed.
findLastRow(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
used internally to refresh the "last row" when the last row is removed.
firstcell - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
 
firstrow - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
 
font - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
 
fontindex - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
 
format - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
 
formats - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat
 

G

GOLD - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
GREEN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
GREY_25_PERCENT - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
GREY_40_PERCENT - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
GREY_50_PERCENT - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
GREY_80_PERCENT - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
getAlignment() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the type of horizontal alignment for the cell
getBoldweight() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get the boldness to use
getBorderBottom() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the type of border to use for the bottom border of the cell
getBorderLeft() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the type of border to use for the left border of the cell
getBorderRight() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the type of border to use for the right border of the cell
getBorderTop() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the type of border to use for the top border of the cell
getBottomBorderColor() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the color to use for the left border
getBytes() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
Method getBytes - get the bytes of just the HSSF portions of the XLS file.
getCell(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
get the hssfcell representing a given column (logical cell) 0-based.
getCellNum() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
get the cell's number within the row
getCellStyle() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
get the style for the cell.
getCellStyleAt(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
get the cell style object at the given index
getCellType() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
get the cells type (numeric, formula or string)
getCellValueRecord() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
Should only be used by HSSFSheet and friends.
getCells() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
gets a list of cells in the row.
getColor() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get the color for the font
getColumnWidth(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
get the width (in units of 1/256th of a character width )
getDataFormat() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the index of the built in format
getDefaultColumnWidth() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
get the default column width for the sheet (if the columns do not define their own width) in characters
getDefaultRowHeight() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
get the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)
getDefaultRowHeightInPoints() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
get the default row height for the sheet (if the rows do not define their own height) in points.
getEncoding() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
used for internationalization, currently 0 for compressed unicode or 1 for 16-bit
getFillBackgroundColor() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the background fill color
getFillForegroundColor() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the foreground fill color
getFillPattern() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the fill pattern (??) - set to 1 to fill with foreground color
getFirstCellNum() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
get the number of the first cell contained in this row.
getFirstRowNum() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
gets the first row on the sheet
getFontAt(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
get the font at the given index number
getFontHeight() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get the font height in unit's of 1/20th of a point.
getFontHeightInPoints() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get the font height
getFontName() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get the name for the font (i.e.
getFormat(String) - Static method in class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat
get the format index that matches the given format string
getFormat(short) - Static method in class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat
get the format string that matches the given format index
getFormats() - Static method in class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat
 
getHeight() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
get the row's height or ff (-1) for undefined/default-height in twips (1/20th of a point)
getHeightInPoints() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
get the row's height or ff (-1) for undefined/default-height in points (20*getHeight())
getHidden() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get whether the cell's using this style are to be hidden
getIndention() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the number of spaces to indent the text in the cell
getIndex() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the index within the HSSFWorkbook (sequence within the collection of ExtnededFormat objects)
getIndex() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get the index within the HSSFWorkbook (sequence within the collection of Font objects)
getItalic() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get whether to use italics or not
getLastCellNum() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
get the number of the last cell contained in this row.
getLastRowNum() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
gets the last row on the sheet
getLeftBorderColor() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the color to use for the left border
getLocked() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get whether the cell's using this style are to be locked
getNumCellStyles() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
get the number of styles the workbook contains
getNumberOfBuiltinFormats() - Static method in class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat
get the number of builtin and reserved formats
getNumberOfFonts() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
get the number of fonts in the font table
getNumberOfSheets() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
get the number of spreadsheets in the workbook (this will be three after serialization)
getNumericCellValue() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
get the value of the cell as a number.
getPhysicalCellAt(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
gets the phsyically defined cell at location (num) NOT its column number.
getPhysicalNumberOfCells() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
gets the number of defined cells (NOT number of cells in the actual row!).
getPhysicalNumberOfRows() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Returns the number of phsyically defined rows (NOT the number of rows in the sheet)
getPhysicalRowAt(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Returns the row physically defined at (rownum).
getRightBorderColor() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the color to use for the left border
getRotation() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the degree of rotation for the text in the cell
getRow(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Returns the logical row (not physical) 0-based.
getRowNum() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
get row number this row represents
getRowRecord() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
get the lowlevel RowRecord represented by this object - should only be called by other parts of the high level API
getRows() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
get a List of the rows in this sheet.
getSheet() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
used internally in the API to get the low level Sheet record represented by this Object.
getSheet(String) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
Get sheet with the given name
getSheetAt(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
Get the HSSFSheet object at the given index.
getSheetIndex(String) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
get the sheet's index
getSheetName(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
get the sheet name
getStrikeout() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get whether to use a strikeout horizontal line through the text or not
getStringCellValue() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
get the value of the cell as a string - for numeric cells we throw an exception.
getTopBorderColor() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the color to use for the top border
getTypeOffset() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get normal,super or subscript.
getUnderline() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
get type of text underlining to use
getVerticalAlignment() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get the type of vertical alignment for the cell
getWrapText() - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
get whether the text should be wrapped

H

HSSFCell - class org.apache.cocoon.poi.hssf.usermodel.HSSFCell.
High level representation of a cell in a row of a spreadsheet.
HSSFCell(Workbook, Sheet, short, short, int) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
Creates new Cell - Should only be called by HSSFRow.
HSSFCell(Workbook, Sheet, short, CellValueRecordInterface) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
Creates an HSSFCell from a CellValueRecordInterface.
HSSFCell() - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
private constructor to prevent blank construction
HSSFCellStyle - class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle.
High level representation of the style of a cell in a sheet of a workbook.
HSSFCellStyle(short, ExtendedFormatRecord) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
Creates new HSSFCellStyle why would you want to do this??
HSSFColorConstants - interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants.
contains constants representing colors in the file.
HSSFDataFormat - class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat.
Utility to identify builin formats.
HSSFDataFormat() - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat
 
HSSFFont - class org.apache.cocoon.poi.hssf.usermodel.HSSFFont.
Represents a Font used in a workbook.
HSSFFont(short, FontRecord) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
Creates a new instance of HSSFFont
HSSFRow - class org.apache.cocoon.poi.hssf.usermodel.HSSFRow.
High level representation of a row of a spreadsheet.
HSSFRow() - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
 
HSSFRow(Workbook, Sheet, short) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
Creates new HSSFRow from scratch.
HSSFRow(Workbook, Sheet, RowRecord) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
Creates an HSSFRow from a low level RowRecord object.
HSSFSheet - class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet.
High level representation of a worksheet.
HSSFSheet(Workbook) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Creates new HSSFSheet - called by HSSFWorkbook to create a sheet from scratch.
HSSFSheet(Workbook, Sheet) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Creates an HSSFSheet representing the given Sheet object.
HSSFSheet() - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
private default constructor prevents bogus initializationless construction
HSSFWorkbook - class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook.
High level representation of a workbook.
HSSFWorkbook() - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
Creates new HSSFWorkbook from scratch (start here!)
HSSFWorkbook(Filesystem) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
given a POI Filesystem object, read in its Workbook and populate the high and low level models.
HSSFWorkbook(InputStream) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
Companion to HSSFWorkbook(Filesystem), this constructs the POI filesystem around your inputstream.

I

INDIGO - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
INITIAL_CAPACITY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
 
INITIAL_CAPACITY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Used for compile-time optimization.
INITIAL_CAPACITY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
used for compile-time performance/memory optimization.
index - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
 
index - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
 

L

LAST_NAME_KEY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
LAST_NAME_VALUE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
LAVENDER - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
LIGHT_BLUE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
LIGHT_GREEN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
LIGHT_ORANGE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
LIGHT_TURQUOISE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
LIGHT_YELLOW - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
LIME - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
lastcell - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
 
lastrow - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
 
log - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
 

M

main(String[]) - Static method in class org.apache.cocoon.poi.hssf.usermodel.TestCellStyle
 
main(String[]) - Static method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 

O

OLIVE_GREEN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
ORANGE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
org.apache.cocoon.poi.hssf.usermodel - package org.apache.cocoon.poi.hssf.usermodel
 

P

PALE_BLUE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
PINK - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
PLUM - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
populateFormats() - Static method in class org.apache.cocoon.poi.hssf.usermodel.HSSFDataFormat
 

R

RED - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
REPLACED - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
REPLACE_ME - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
ROSE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
record - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
removeCell(HSSFCell) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
remove the HSSFCell from this row.
removeRow(HSSFRow) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
Remove a row from this sheet.
removeSheetAt(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
removes sheet at the given index
row - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
row - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
reference to low level representation
rowNum - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
 
rows - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
rows collection

S

SEA_GREEN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
SKY_BLUE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
SSN_KEY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
SSN_VALUE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
 
SS_NONE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
no type offsetting (not super or subscript)
SS_SUB - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
subscript
SS_SUPER - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
superscript
setAlignment(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the type of horizontal alignment for the cell
setBoldweight(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set the boldness to use
setBorderBottom(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the type of border to use for the bottom border of the cell
setBorderLeft(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the type of border to use for the left border of the cell
setBorderRight(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the type of border to use for the right border of the cell
setBorderTop(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the type of border to use for the top border of the cell
setBottomBorderColor(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the color to use for the bottom border
setCellNum(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
set the cell's number within the row (0 based)
setCellStyle(HSSFCellStyle) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
set the style for the cell.
setCellType(int) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
set the cells type (numeric, formula or string) -- DONT USE FORMULAS IN THIS RELEASE WE'LL THROW YOU A RUNTIME EXCEPTION IF YOU DO
setCellValue(double) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
set a numeric value for the cell
setCellValue(String) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
set a string value for the cell.
setColor(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set the color for the font
setColumnWidth(short, short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
set the width (in units of 1/256th of a character width)
setDataFormat(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the data format (only builtin formats are supported)
setDefaultColumnWidth(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
set the default column width for the sheet (if the columns do not define their own width) in characters
setDefaultRowHeight(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
set the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)
setDefaultRowHeightInPoints(float) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
set the default row height for the sheet (if the rows do not define their own height) in points
setEncoding(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
set the encoding to either 8 or 16 bit.
setFillBackgroundColor(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the background fill color
setFillForegroundColor(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the foreground fill color
setFillPattern(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
setting to one fills the cell with the foreground color...
setFont(HSSFFont) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the font for this style
setFontHeight(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set the font height in unit's of 1/20th of a point.
setFontHeightInPoints(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set the font height
setFontName(String) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set the name for the font (i.e.
setHeight(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
set the row's height or set to ff (-1) for undefined/default-height.
setHeightInPoints(float) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
set the row's height in points.
setHidden(boolean) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the cell's using this style to be hidden
setIndention(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the number of spaces to indent the text in the cell
setItalic(boolean) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set whether to use italics or not
setLeftBorderColor(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the color to use for the left border
setLocked(boolean) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the cell's using this style to be locked
setPropertiesFromSheet(Sheet) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
used internally to set the properties given a Sheet object
setPropertiesFromWorkbook(Workbook) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
used internally to set the workbook properties.
setRightBorderColor(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the color to use for the right border
setRotation(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the degree of rotation for the text in the cell
setRowNum(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
set the row number of this row.
setSheetName(int, String) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
set the sheet name.
setStrikeout(boolean) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set whether to use a strikeout horizontal line through the text or not
setTopBorderColor(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the color to use for the top border
setTypeOffset(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set normal,super or subscript.
setUnderline(byte) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
set type of text underlining to use
setVerticalAlignment(short) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set the type of vertical alignment for the cell
setWrapText(boolean) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
set whether the text should be wrapped
sheet - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 
sheet - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFRow
reference to containing Sheet
sheet - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFSheet
reference to the low level Sheet object
sheets - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
this holds the HSSFSheet objects attached to this workbook
stringValue - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCell
 

T

TAN - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
TEAL - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
TURQUOISE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
TestCellStyle - class org.apache.cocoon.poi.hssf.usermodel.TestCellStyle.
Class to test cell styling functionality
TestCellStyle(String) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.TestCellStyle
Creates a new instance of TestCellStyle
TestWorkbook - class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook.
Class to test Workbook functionality
TestWorkbook(String) - Constructor for class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
Constructor TestWorkbook
testModifyEmployee() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Modify Employee Sheet
testModifySimple() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Modify Sheet Simple
testModifySimpleWithSkip() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Modify Sheet Simple With Skipped cells
testModifySimpleWithStyling() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Modify Sheet With Styling
testReadEmployeeSimple() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Read Employee Simple
testReadSheetWithRK() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Read Sheet with an RK number
testReadSimple() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Read Simple
testWriteModifySheetSimple() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Write/Modify Sheet Simple
testWriteSheetFont() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestCellStyle
TEST NAME: Test Write Sheet Font
testWriteSheetSimple() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestWorkbook
TEST NAME: Test Write Sheet Simple
testWriteSheetStyle() - Method in class org.apache.cocoon.poi.hssf.usermodel.TestCellStyle
TEST NAME: Test Write Sheet Style

U

U_DOUBLE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
double underlined
U_DOUBLE_ACCOUNTING - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
accounting style double underline
U_NONE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
not underlined
U_SINGLE - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
single (normal) underline
U_SINGLE_ACCOUNTING - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFFont
accounting style single underline

V

VERTICAL_BOTTOM - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
bottom-aligned vertical alignment
VERTICAL_CENTER - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
center-aligned vertical alignment
VERTICAL_JUSTIFY - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
vertically justified vertical alignment
VERTICAL_TOP - Static variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFCellStyle
top-aligned vertical alignment
VIOLET - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 

W

WHITE - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
workbook - Variable in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
this is the reference to the low level Workbook object
write(OutputStream) - Method in class org.apache.cocoon.poi.hssf.usermodel.HSSFWorkbook
Method write - write out this workbook to an Outputstream.

Y

YELLOW - Static variable in interface org.apache.cocoon.poi.hssf.usermodel.HSSFColorConstants
 
A B C D E F G H I L M O P R S T U V W Y
Overview  Package  Class  Use  Deprecated   Index 
Home >> All >> org >> apache >> cocoon >> poi >> hssf >> [ usermodel overview ]  PREV  NEXT