- Features - Class in jxl.demo
-
Goes through each cell in the workbook, and if the cell has any features
associated with, it prints out the cell contents and the features
- Features(Workbook, OutputStream, String) - Constructor for class jxl.demo.Features
-
Constructor
- FILL - Static variable in class jxl.format.Alignment
-
Data in cells with this alignment will fill the cell
- findByName(String) - Method in class jxl.Workbook
-
Gets the named range from this workbook.
- findByName(String) - Method in class jxl.write.WritableWorkbook
-
Gets the named range from this workbook.
- findCell(String) - Method in interface jxl.Sheet
-
Gets the cell whose contents match the string passed in.
- findCell(String, int, int, int, int, boolean) - Method in interface jxl.Sheet
-
Gets the cell whose contents match the string passed in.
- findCell(Pattern, int, int, int, int, boolean) - Method in interface jxl.Sheet
-
Gets the cell whose contents match the regular expressionstring passed in.
- findCellByName(String) - Method in class jxl.Workbook
-
Gets the named cell from this workbook.
- findCellByName(String) - Method in class jxl.write.WritableWorkbook
-
Gets the named cell from this workbook.
- findLabelCell(String) - Method in interface jxl.Sheet
-
Gets the cell whose contents match the string passed in.
- FLOAT - Static variable in class jxl.write.NumberFormats
-
Formatting for a float.
- FOLIO - Static variable in class jxl.format.PaperSize
-
Folio 8.5" x 13"
- Font - Interface in jxl.format
-
Interface which exposes the user font display information to the user
- Font - Class in jxl.write
-
Deprecated.
Renamed to writable font
- Font(WritableFont.FontName) - Constructor for class jxl.write.Font
-
Deprecated.
Use jxl.write.WritableFont
- Font(WritableFont.FontName, int) - Constructor for class jxl.write.Font
-
Deprecated.
use jxl.write.WritableFont
- Font(WritableFont.FontName, int, WritableFont.BoldStyle) - Constructor for class jxl.write.Font
-
Deprecated.
use jxl.write.WritableFont
- Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean) - Constructor for class jxl.write.Font
-
Deprecated.
use jxl.write.WritableFont
- Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle) - Constructor for class jxl.write.Font
-
Deprecated.
use jxl.write.WritableFont
- Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour) - Constructor for class jxl.write.Font
-
Deprecated.
use jxl.write.WritableFont
- Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour, ScriptStyle) - Constructor for class jxl.write.Font
-
Deprecated.
use jxl.write.WritableFont
- Format - Interface in jxl.format
-
Exposes the cell formatting information
- FORMAT1 - Static variable in class jxl.write.DateFormats
-
The default format.
- FORMAT1 - Static variable in class jxl.write.NumberFormats
-
Equivalent to a DecimalFormat "#,##0;(#,##0)"
- FORMAT10 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "mm:ss"
- FORMAT10 - Static variable in class jxl.write.NumberFormats
-
Equivalent to DecimalFormat "##0.0E0"
- FORMAT11 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "H:mm:ss"
- FORMAT12 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "mm:ss.S"
- FORMAT2 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "d-MMM-yy"
- FORMAT2 - Static variable in class jxl.write.NumberFormats
-
Equivalent to FORMAT1 except deficits are coloured red
- FORMAT3 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "d-MMM"
- FORMAT3 - Static variable in class jxl.write.NumberFormats
-
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
- FORMAT4 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "MMM-yy"
- FORMAT4 - Static variable in class jxl.write.NumberFormats
-
Equivalent to FORMAT3 except deficits are coloured red
- FORMAT5 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "h:mm a"
- FORMAT5 - Static variable in class jxl.write.NumberFormats
-
Equivalent to DecimalFormat "#,##0;(#,##0)"
- FORMAT6 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "h:mm:ss a"
- FORMAT6 - Static variable in class jxl.write.NumberFormats
-
Equivalent to FORMAT5 except deficits are coloured red
- FORMAT7 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "H:mm"
- FORMAT7 - Static variable in class jxl.write.NumberFormats
-
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
- FORMAT8 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "H:mm:ss"
- FORMAT8 - Static variable in class jxl.write.NumberFormats
-
Equivalent to FORMAT7 except deficits are coloured red
- FORMAT9 - Static variable in class jxl.write.DateFormats
-
Equivalent to a date format of "M/d/yy H:mm"
- FORMAT9 - Static variable in class jxl.write.NumberFormats
-
Equivalent to FORMAT7
- Formula - Class in jxl.write
-
A cell, created by user applications, which contains a numerical value
- Formula(int, int, String) - Constructor for class jxl.write.Formula
-
Constructs the formula
- Formula(int, int, String, CellFormat) - Constructor for class jxl.write.Formula
-
Constructs a formula
- FORMULA_ERROR - Static variable in class jxl.CellType
-
- FormulaCell - Interface in jxl
-
Interface for formulas which allow clients to read the Excel formula
- Formulas - Class in jxl.demo
-
Goes through each cell in the workbook, and if the contents of that
cell is a formula, it prints out the last calculated value and
the formula string
- Formulas(Workbook, OutputStream, String) - Constructor for class jxl.demo.Formulas
-
Constructor
- FRACTION_HALVES - Static variable in class jxl.write.NumberFormat
-
Constant format string for fractions as halves
- FRACTION_HUNDREDTHS - Static variable in class jxl.write.NumberFormat
-
Constant format string for fractions as hundredths
- FRACTION_ONE_DIGIT - Static variable in class jxl.write.NumberFormats
-
Formatting for one digit fractions
- FRACTION_QUARTERS - Static variable in class jxl.write.NumberFormat
-
Constant format string for fractions as quarter
- FRACTION_SIXTEENTHS - Static variable in class jxl.write.NumberFormat
-
Constant format string for fractions as sixteenths
- FRACTION_TENTHS - Static variable in class jxl.write.NumberFormat
-
Constant format string for fractions as tenths
- FRACTION_THREE_DIGITS - Static variable in class jxl.write.NumberFormat
-
Constant format string for three digit fractions
- FRACTION_TWO_DIGITS - Static variable in class jxl.write.NumberFormats
-
Formatting for two digit fractions
- FRACTIONS_EIGHTHS - Static variable in class jxl.write.NumberFormat
-
Constant format string for fractions as eighths
- GENERAL - Static variable in class jxl.format.Alignment
-
The standard alignment
- GERMAN_FANFOLD - Static variable in class jxl.format.PaperSize
-
German Std.
- GERMAN_LEGAL_FANFOLD - Static variable in class jxl.format.PaperSize
-
German Legal Fanfold 8.5" × 13"
- getAlignment(int) - Static method in class jxl.format.Alignment
-
Gets the alignment from the value
- getAlignment() - Method in interface jxl.format.CellFormat
-
Gets the horizontal cell alignment
- getAlignment(int) - Static method in class jxl.format.VerticalAlignment
-
Gets the alignment from the value
- getAllColours() - Static method in class jxl.format.Colour
-
Returns all available colours - used when generating the default palette
- getArrayGrowSize() - Method in class jxl.WorkbookSettings
-
Accessor for the array grow size property
- getAutoFilterDisabled() - Method in class jxl.WorkbookSettings
-
Accessor for the autofilter disabled feature
- getAutomaticFormulaCalculation() - Method in class jxl.SheetSettings
-
Retrieves the automatic formula calculation flag
- getBackgroundColour() - Method in interface jxl.format.CellFormat
-
Gets the background colour used by this cell
- getBlue() - Method in class jxl.format.RGB
-
Accessor for the blue component
- getBoldWeight() - Method in interface jxl.format.Font
-
Gets the bold weight for this font
- getBorder(Border) - Method in interface jxl.format.CellFormat
-
Gets the line style for the given cell border
If a border type of ALL or NONE is specified, then a line style of
NONE is returned
- getBorderColour(Border) - Method in interface jxl.format.CellFormat
-
Gets the colour for the given cell border
If a border type of ALL or NONE is specified, then a line style of
NONE is returned
If the specified cell does not have an associated line style, then
the colour the line would be is still returned
- getBorderLine(Border) - Method in interface jxl.format.CellFormat
-
Gets the line style for the given cell border
If a border type of ALL or NONE is specified, then a line style of
NONE is returned
- getBottomMargin() - Method in class jxl.SheetSettings
-
Accessor for the bottom margin
- getBottomRight() - Method in interface jxl.Range
-
Gets the cell at the bottom right of this range
- getCell(int, int) - Method in interface jxl.Sheet
-
Returns the cell specified at this row and at this column.
- getCell(String) - Method in interface jxl.Sheet
-
Returns the cell for the specified location eg.
- getCell(String) - Method in class jxl.Workbook
-
Returns the cell for the specified location eg.
- getCellFeatures() - Method in interface jxl.Cell
-
Gets any special cell features, such as comments (notes) or cell
validation present for this cell
- getCellFormat() - Method in interface jxl.Cell
-
Gets the cell format which applies to this cell
Note that for cell with a cell type of EMPTY, which has no formatting
information, this method will return null.
- getCellReference(int, int, StringBuffer) - Static method in class jxl.CellReferenceHelper
-
Appends the cell reference for the column and row passed in to the string
buffer
- getCellReference(int, boolean, int, boolean, StringBuffer) - Static method in class jxl.CellReferenceHelper
-
Overloaded method which prepends $ for absolute reference
- getCellReference(int, int) - Static method in class jxl.CellReferenceHelper
-
Gets the cell reference for the specified column and row
- getCellReference(int, int, int, Workbook, StringBuffer) - Static method in class jxl.CellReferenceHelper
-
Gets the fully qualified cell reference given the column, row
external sheet reference etc
- getCellReference(int, int, int, WritableWorkbook, StringBuffer) - Static method in class jxl.CellReferenceHelper
-
Gets the fully qualified cell reference given the column, row
external sheet reference etc
- getCellReference(int, int, boolean, int, boolean, Workbook, StringBuffer) - Static method in class jxl.CellReferenceHelper
-
Gets the fully qualified cell reference given the column, row
external sheet reference etc
- getCellReference(int, int, int, Workbook) - Static method in class jxl.CellReferenceHelper
-
Gets the fully qualified cell reference given the column, row
external sheet reference etc
- getCellReference(int, int, int, WritableWorkbook) - Static method in class jxl.CellReferenceHelper
-
Gets the fully qualified cell reference given the column, row
external sheet reference etc
- getCellReference(Cell) - Static method in class jxl.CellReferenceHelper
-
Gets the cell reference for the cell
- getCellReference(Cell, StringBuffer) - Static method in class jxl.CellReferenceHelper
-
Gets the cell reference for the cell
- getCellValidationDisabled() - Method in class jxl.WorkbookSettings
-
Accessor for the ignore cell validation
- getCentre() - Method in class jxl.HeaderFooter
-
Accessor for the contents which in the centre of the page
- getCharacterSet() - Method in class jxl.WorkbookSettings
-
Accessor for the character set.
- getColour() - Method in interface jxl.format.Font
-
Gets the colour for this font
- getColumn() - Method in interface jxl.Cell
-
Returns the column number of this cell
- getColumn(String) - Static method in class jxl.CellReferenceHelper
-
Gets the columnn number of the string cell reference
- getColumn() - Method in interface jxl.Hyperlink
-
Returns the column number of this cell
- getColumn() - Method in interface jxl.Image
-
Accessor for the image position
- getColumn(int) - Method in interface jxl.Sheet
-
Gets all the cells on the specified column
- getColumn() - Method in class jxl.write.WritableImage
-
Accessor for the image position
- getColumnFormat(int) - Method in interface jxl.Sheet
-
Deprecated.
Use getColumnView and the CellView bean instead
- getColumnPageBreaks() - Method in interface jxl.Sheet
-
Accessor for the page breaks on this sheet
- getColumnReference(int) - Static method in class jxl.CellReferenceHelper
-
Gets the column letter corresponding to the 0-based column number
- getColumns() - Method in interface jxl.Sheet
-
Returns the number of columns in this sheet
- getColumnView(int) - Method in interface jxl.Sheet
-
Gets the column width for the specified column
- getColumnWidth(int) - Method in interface jxl.Sheet
-
Deprecated.
Use getColumnView instead
- getComment() - Method in class jxl.CellFeatures
-
Accessor for the cell comment
- getContents() - Method in interface jxl.Cell
-
Quick and dirty function to return the contents of this cell as a string.
- getCopies() - Method in class jxl.SheetSettings
-
Accessor for the number of copies to print
- getDataValidationList() - Method in class jxl.CellFeatures
-
Gets the data validation list
- getDate() - Method in interface jxl.DateCell
-
Gets the date contained in this cell
- getDateFormat() - Method in interface jxl.DateCell
-
Gets the DateFormat used to format the cell.
- getDefaultBlue() - Method in class jxl.format.Colour
-
Deprecated.
use getDefaultRGB instead
- getDefaultColumnWidth() - Method in class jxl.SheetSettings
-
Accessor for the default column width
- getDefaultGreen() - Method in class jxl.format.Colour
-
Deprecated.
use getDefaultRGB instead
- getDefaultHeightMargin() - Method in class jxl.SheetSettings
-
Gets the default margin height
- getDefaultRed() - Method in class jxl.format.Colour
-
Deprecated.
use getDefaultRGB instead
- getDefaultRGB() - Method in class jxl.format.Colour
-
Returns the default RGB of the colour
- getDefaultRowHeight() - Method in class jxl.SheetSettings
-
Accessor for the default row height
- getDefaultWidthMargin() - Method in class jxl.SheetSettings
-
Gets the default margin width
- getDescription() - Method in class jxl.format.Alignment
-
Gets the string description of this alignment
- getDescription() - Method in class jxl.format.BoldStyle
-
Gets the string description of the bold style
- getDescription() - Method in class jxl.format.Border
-
Gets the description
- getDescription() - Method in class jxl.format.BorderLineStyle
-
Gets the textual description
- getDescription() - Method in class jxl.format.Colour
-
Gets the string description for display purposes
- getDescription() - Method in class jxl.format.Orientation
-
Gets the textual description
- getDescription() - Method in class jxl.format.Pattern
-
Gets the textual description
- getDescription() - Method in class jxl.format.ScriptStyle
-
Gets the string description for display purposes
- getDescription() - Method in class jxl.format.UnderlineStyle
-
Gets the string description for display purposes
- getDescription() - Method in class jxl.format.VerticalAlignment
-
Gets the textual description
- getDimension() - Method in class jxl.CellView
-
Deprecated.
use getSize() instead
- getDisplayZeroValues() - Method in class jxl.SheetSettings
-
Accessor for the displayZeroValues property
- getDrawing(int) - Method in interface jxl.Sheet
-
Accessor for the image
- getDrawingsDisabled() - Method in class jxl.WorkbookSettings
-
Gets the drawings disabled flag
- getEncoding() - Method in class jxl.WorkbookSettings
-
Accessor for the character encoding
- getErrorCode() - Method in interface jxl.ErrorCell
-
Gets the error code for this cell.
- getExcel9File() - Method in class jxl.WorkbookSettings
-
Has this file been written by excel 2000?
- getExcelDisplayLanguage() - Method in class jxl.WorkbookSettings
-
Returns the two character ISO 3166 mnemonic used by excel for user
language displayto display
- getExcelRegionalSettings() - Method in class jxl.WorkbookSettings
-
Returns the two character ISO 3166 mnemonic used by excel for
its regional settings
- getFile() - Method in interface jxl.Hyperlink
-
Returns the local file eferenced by this Hyperlink
- getFirstSheetIndex() - Method in interface jxl.Range
-
Gets the index of the first sheet in the range
- getFitHeight() - Method in class jxl.SheetSettings
-
Accessor for the fit height
- getFitToPages() - Method in class jxl.SheetSettings
-
Accessor for the fit width print flag
- getFitWidth() - Method in class jxl.SheetSettings
-
Accessor for the fit width
- getFont() - Method in interface jxl.format.CellFormat
-
Gets the font information used by this format
- getFooter() - Method in class jxl.SheetSettings
-
Accessor for the footer
- getFooterMargin() - Method in class jxl.SheetSettings
-
Accessor for the footer margin
- getFormat() - Method in class jxl.CellView
-
Accessor for the cell format for this group.
- getFormat() - Method in interface jxl.format.CellFormat
-
Gets the format used by this format
- getFormatString() - Method in interface jxl.format.Format
-
Accesses the excel format string which is applied to the cell
Note that this is the string that excel uses, and not the java
equivalent
- getFormula() - Method in interface jxl.FormulaCell
-
Gets the formula as a string
- getFormulaAdjust() - Method in class jxl.WorkbookSettings
-
Accessor for the formula adjust disabled
- getFunctionNames() - Method in class jxl.WorkbookSettings
-
Gets the function names.
- getGCDisabled() - Method in class jxl.WorkbookSettings
-
Accessor for the disabling of garbage collection
- getGreen() - Method in class jxl.format.RGB
-
Accessor for the green component
- getHeader() - Method in class jxl.SheetSettings
-
Accessor for the header
- getHeaderMargin() - Method in class jxl.SheetSettings
-
Accessor for the header margin
- getHeight() - Method in interface jxl.Image
-
Accessor for the image dimensions
- getHeight(LengthUnit) - Method in interface jxl.Image
-
Get the height of this image as rendered within Excel
- getHeight() - Method in class jxl.write.WritableImage
-
Accessor for the image dimensions
- getHideobj() - Method in class jxl.WorkbookSettings
-
The HIDEOBJ record stores options selected in the Options dialog,View tab
Possible values are:
HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS
- getHorizontalFreeze() - Method in class jxl.SheetSettings
-
Gets the row at which the pane is frozen horizontally
- getHorizontalPrintResolution() - Method in class jxl.SheetSettings
-
Accessor for the horizontal print resolution
- getHorizontalResolution(LengthUnit) - Method in interface jxl.Image
-
Gets the horizontal resolution of the image, if that information
is available.
- getHyperlinks() - Method in interface jxl.Sheet
-
Gets the hyperlinks on this sheet
- getIgnoreBlanks() - Method in class jxl.WorkbookSettings
-
Accessor for the ignore blanks flag
- getImage(int) - Method in interface jxl.write.WritableSheet
-
Accessor for the image
- getImageAnchor() - Method in class jxl.write.WritableImage
-
Accessor for the anchor properties
- getImageData() - Method in interface jxl.Image
-
Accessor for the image data
- getImageData() - Method in class jxl.write.WritableImage
-
Accessor for the image data
- getImageFile() - Method in interface jxl.Image
-
Accessor for the image file
- getImageFile() - Method in class jxl.write.WritableImage
-
Accessor for the image file
- getImageHeight() - Method in interface jxl.Image
-
Gets the height of the image.
- getImageWidth() - Method in interface jxl.Image
-
Gets the width of the image.
- getIndentation() - Method in interface jxl.format.CellFormat
-
Gets the indentation of the cell text
- getInitialFileSize() - Method in class jxl.WorkbookSettings
-
Accessor for the initial file size property
- getInternalColour(int) - Static method in class jxl.format.Colour
-
Gets the internal colour from the value
- getLastColumn() - Method in interface jxl.Hyperlink
-
Returns the column number of the bottom right cell
- getLastRow() - Method in interface jxl.Hyperlink
-
Returns the row number of the bottom right cell
- getLastSheetIndex() - Method in interface jxl.Range
-
Gets the index of the last sheet in the range
- getLeft() - Method in class jxl.HeaderFooter
-
Accessor for the contents which appear on the left hand side of the page
- getLeftMargin() - Method in class jxl.SheetSettings
-
Accessor for the left margin
- getLocale() - Method in class jxl.WorkbookSettings
-
Returns the locale used by JExcelAPI to read the spreadsheet
- getMergedCellCheckingDisabled() - Method in class jxl.WorkbookSettings
-
Accessor to retrieve the merged cell checking flag
- getMergedCells() - Method in interface jxl.Sheet
-
Gets the cells which have been merged on this sheet
- getName() - Method in interface jxl.format.Font
-
Gets the name of this font
- getName() - Method in interface jxl.Sheet
-
Gets the name of this sheet
- getNamesDisabled() - Method in class jxl.WorkbookSettings
-
Accessor for the disabling of interpretation of named ranges
- getNormalMagnification() - Method in class jxl.SheetSettings
-
Accessor for the nomral view magnificaton factor.
- getNumberFormat() - Method in interface jxl.NumberCell
-
Gets the NumberFormat used to format this cell.
- getNumberOfImages() - Method in interface jxl.Sheet
-
Accessor for the number of images on the sheet
- getNumberOfImages() - Method in interface jxl.write.WritableSheet
-
Accessor for the number of images on the sheet
- getNumberOfSheets() - Method in class jxl.Workbook
-
Returns the number of sheets in this workbook
- getNumberOfSheets() - Method in class jxl.write.WritableWorkbook
-
Returns the number of sheets in this workbook
- getOrientation() - Method in interface jxl.format.CellFormat
-
Gets the orientation
- getOrientation(int) - Static method in class jxl.format.Orientation
-
Gets the alignment from the value
- getOrientation() - Method in class jxl.SheetSettings
-
Accessor for the orientation
- getPageBreakPreviewMagnification() - Method in class jxl.SheetSettings
-
Accessor for the page break preview mangificaton factor.
- getPageBreakPreviewMode() - Method in class jxl.SheetSettings
-
Accessor for the pageBreakPreview mode
- getPageOrder() - Method in class jxl.SheetSettings
-
Accessor for the order
- getPageStart() - Method in class jxl.SheetSettings
-
Accessor for the page start
- getPaperSize(int) - Static method in class jxl.format.PaperSize
-
Gets the paper size for a specific value
- getPaperSize() - Method in class jxl.SheetSettings
-
Accessor for the paper size
- getPassword() - Method in class jxl.SheetSettings
-
Accessor for the password
- getPasswordHash() - Method in class jxl.SheetSettings
-
Accessor for the password hash - used only when copying sheets
- getPattern() - Method in interface jxl.format.CellFormat
-
Gets the pattern used by this cell format
- getPattern(int) - Static method in class jxl.format.Pattern
-
Gets the pattern from the value
- getPointSize() - Method in interface jxl.format.Font
-
Gets the point size for this font, if the font hasn't been initialized
- getPrintArea() - Method in class jxl.SheetSettings
-
Accessor for the print area
- getPrintGridLines() - Method in class jxl.SheetSettings
-
Accessor for the printGridLines property
- getPrintHeaders() - Method in class jxl.SheetSettings
-
Accessor for the printHeaders property
- getPrintTitlesCol() - Method in class jxl.SheetSettings
-
Accessor for the print column titles
- getPrintTitlesRow() - Method in class jxl.SheetSettings
-
Accessor for the print row titles
- getPropertySetsDisabled() - Method in class jxl.WorkbookSettings
-
Accessor to retrieve the property sets disabled flag
- getRange() - Method in interface jxl.Hyperlink
-
Gets the range of cells which activate this hyperlink
The get sheet index methods will all return -1, because the
cells will all be present on the same sheet
- getRangeNames() - Method in class jxl.Workbook
-
Gets the named ranges
- getRangeNames() - Method in class jxl.write.WritableWorkbook
-
Gets the named ranges
- getRationalizationDisabled() - Method in class jxl.WorkbookSettings
-
Accessor to retrieve the rationalization flag
- getRecalculateFormulasBeforeSave() - Method in class jxl.SheetSettings
-
Retrieves the recalculate formulas before save flag
- getRed() - Method in class jxl.format.RGB
-
Accessor for the red component
- getRefreshAll() - Method in class jxl.WorkbookSettings
-
When true then Refresh All should be done on all external data ranges and
PivotTables when loading the workbook (the default is =0)
- getRight() - Method in class jxl.HeaderFooter
-
Accessor for the contents which appear on the right hand side of the page
- getRightMargin() - Method in class jxl.SheetSettings
-
Accessor for the right margin
- getRow() - Method in interface jxl.Cell
-
Returns the row number of this cell
- getRow(String) - Static method in class jxl.CellReferenceHelper
-
Gets the row number of the cell reference
- getRow() - Method in interface jxl.Hyperlink
-
Returns the row number of this cell
- getRow() - Method in interface jxl.Image
-
Accessor for the image position
- getRow(int) - Method in interface jxl.Sheet
-
Gets all the cells on the specified row
- getRow() - Method in class jxl.write.WritableImage
-
Accessor for the image position
- getRowHeight(int) - Method in interface jxl.Sheet
-
Deprecated.
use getRowView instead
- getRowPageBreaks() - Method in interface jxl.Sheet
-
Accessor for the page breaks on this sheet
- getRows() - Method in interface jxl.Sheet
-
Returns the number of rows in this sheet
- getRowView(int) - Method in interface jxl.Sheet
-
Gets the row height for the specified column
- getScaleFactor() - Method in class jxl.SheetSettings
-
Accessor for the scale factor
- getScriptStyle() - Method in interface jxl.format.Font
-
Gets the script style
- getSettings() - Method in interface jxl.Sheet
-
Gets the settings used on a particular sheet
- getSharedDataValidationRange() - Method in class jxl.CellFeatures
-
Gets the range of cells to which the data validation applies.
- getSheet(String) - Static method in class jxl.CellReferenceHelper
-
Gets the sheet name from the cell reference string
- getSheet(int) - Method in class jxl.Workbook
-
Gets the specified sheet within this workbook
As described in the accompanying technical notes, each call
to getSheet forces a reread of the sheet (for memory reasons).
- getSheet(String) - Method in class jxl.Workbook
-
Gets the sheet with the specified name from within this workbook.
- getSheet(int) - Method in class jxl.write.WritableWorkbook
-
Gets the specified sheet within this workbook
- getSheet(String) - Method in class jxl.write.WritableWorkbook
-
Gets the sheet with the specified name from within this workbook
- getSheetNames() - Method in class jxl.Workbook
-
Gets the sheet names
- getSheetNames() - Method in class jxl.write.WritableWorkbook
-
Gets the sheet names
- getSheets() - Method in class jxl.Workbook
-
Gets the sheets within this workbook.
- getSheets() - Method in class jxl.write.WritableWorkbook
-
Gets the sheets within this workbook.
- getShowGridLines() - Method in class jxl.SheetSettings
-
Accessor for the showGridLines property
- getSize() - Method in class jxl.CellView
-
Gets the width of the column in characters multiplied by 256, or the
height of the row in 1/20ths of a point
- getString() - Method in interface jxl.LabelCell
-
Gets the label for this cell.
- getStyle(int) - Static method in class jxl.format.BorderLineStyle
-
Gets the alignment from the value
- getStyle(int) - Static method in class jxl.format.ScriptStyle
-
Gets the ScriptStyle from the value
- getStyle(int) - Static method in class jxl.format.UnderlineStyle
-
Gets the UnderlineStyle from the value
- getTemplate() - Method in class jxl.WorkbookSettings
-
Workbook Is a Template
- getTemporaryFileDuringWriteDirectory() - Method in class jxl.WorkbookSettings
-
Used in conjunction with the UseTemporaryFileDuringWrite setting to
set the target directory for the temporary files.
- getTopLeft() - Method in interface jxl.Range
-
Gets the cell at the top left of this range
- getTopMargin() - Method in class jxl.SheetSettings
-
Accessor for the top margin
- getType() - Method in interface jxl.Cell
-
Returns the content type of this cell
- getUnderlineStyle() - Method in interface jxl.format.Font
-
Gets the underline style for this font
- getURL() - Method in interface jxl.Hyperlink
-
Gets the URL referenced by this Hyperlink
- getUseTemporaryFileDuringWrite() - Method in class jxl.WorkbookSettings
-
Accessor for the temporary file during write.
- getValue() - Method in interface jxl.BooleanCell
-
Gets the boolean value stored in this cell.
- getValue() - Method in class jxl.format.Alignment
-
Gets the value of this alignment.
- getValue() - Method in class jxl.format.BoldStyle
-
Gets the value of the bold weight.
- getValue() - Method in class jxl.format.BorderLineStyle
-
Gets the value for this line style
- getValue() - Method in class jxl.format.Colour
-
Gets the value of this colour.
- getValue() - Method in class jxl.format.Orientation
-
Accessor for the binary value
- getValue() - Method in class jxl.format.PaperSize
-
Accessor for the internal binary value association with this paper size
- getValue() - Method in class jxl.format.Pattern
-
Gets the value of this pattern.
- getValue() - Method in class jxl.format.ScriptStyle
-
Gets the value of this style.
- getValue() - Method in class jxl.format.UnderlineStyle
-
Gets the value of this style.
- getValue() - Method in class jxl.format.VerticalAlignment
-
Accessor for the binary value
- getValue() - Method in interface jxl.NumberCell
-
Gets the double contents for this cell.
- getVersion() - Static method in class jxl.Workbook
-
Accessor for the software version
- getVerticalAlignment() - Method in interface jxl.format.CellFormat
-
Gets the vertical cell alignment
- getVerticalFreeze() - Method in class jxl.SheetSettings
-
Gets the column at which the pane is frozen vertically
- getVerticalPrintResolution() - Method in class jxl.SheetSettings
-
Accessor for the vertical print resolution
- getVerticalResolution(LengthUnit) - Method in interface jxl.Image
-
Gets the vertical resolution of the image, if that information
is available.
- getWidth() - Method in interface jxl.Image
-
Accessor for the image dimensions
- getWidth(LengthUnit) - Method in interface jxl.Image
-
Get the width of this image as rendered within Excel
- getWidth() - Method in class jxl.write.WritableImage
-
Accessor for the image dimensions
- getWindowProtected() - Method in class jxl.WorkbookSettings
-
- getWorkbook(File) - Static method in class jxl.Workbook
-
A factory method which takes in an excel file and reads in the contents.
- getWorkbook(File, WorkbookSettings) - Static method in class jxl.Workbook
-
A factory method which takes in an excel file and reads in the contents.
- getWorkbook(InputStream) - Static method in class jxl.Workbook
-
A factory method which takes in an excel file and reads in the contents.
- getWorkbook(InputStream, WorkbookSettings) - Static method in class jxl.Workbook
-
A factory method which takes in an excel file and reads in the contents.
- getWrap() - Method in interface jxl.format.CellFormat
-
Gets whether or not the contents of this cell are wrapped
- getWritableCell(int, int) - Method in interface jxl.write.WritableSheet
-
Gets the writable cell from this sheet.
- getWritableCell(String) - Method in interface jxl.write.WritableSheet
-
Returns the cell for the specified location eg.
- getWritableCell(String) - Method in class jxl.write.WritableWorkbook
-
Returns the cell for the specified location eg.
- getWritableCellFeatures() - Method in interface jxl.write.WritableCell
-
Accessor for the cell features
- getWritableHyperlinks() - Method in interface jxl.write.WritableSheet
-
Gets the writable hyperlinks from this sheet.
- getWriteAccess() - Method in class jxl.WorkbookSettings
-
- getZoomFactor() - Method in class jxl.SheetSettings
-
Accessor for the zoom factor.
- GMT - Static variable in class jxl.write.DateTime
-
Instance variable for dummy variable overload
- GOLD - Static variable in class jxl.format.Colour
-
- GRAY_25 - Static variable in class jxl.format.Colour
-
- GRAY_25 - Static variable in class jxl.format.Pattern
-
- GRAY_50 - Static variable in class jxl.format.Colour
-
- GRAY_50 - Static variable in class jxl.format.Pattern
-
- GRAY_75 - Static variable in class jxl.format.Pattern
-
- GRAY_80 - Static variable in class jxl.format.Colour
-
- GREATER_EQUAL - Static variable in class jxl.write.WritableCellFeatures
-
- GREATER_THAN - Static variable in class jxl.write.WritableCellFeatures
-
- GREEN - Static variable in class jxl.format.Colour
-
- GREY_25_PERCENT - Static variable in class jxl.format.Colour
-
- GREY_40_PERCENT - Static variable in class jxl.format.Colour
-
- GREY_50_PERCENT - Static variable in class jxl.format.Colour
-
- GREY_80_PERCENT - Static variable in class jxl.format.Colour
-
- ScriptStyle - Class in jxl.format
-
Enumeration class which contains the various script styles available
within the standard Excel ScriptStyle palette
- SEA_GREEN - Static variable in class jxl.format.Colour
-
- setAlignment(Alignment) - Method in class jxl.write.WritableCellFormat
-
Sets the horizontal alignment for this format
- setArrayGrowSize(int) - Method in class jxl.WorkbookSettings
-
Sets the amount of memory by which to increase the amount of
memory allocated to storing the workbook data.
- setAutoFilterDisabled(boolean) - Method in class jxl.WorkbookSettings
-
Sets the autofilter disabled
- setAutomaticFormulaCalculation(boolean) - Method in class jxl.SheetSettings
-
Sets the automatic formula calculation flag
- setAutosize(boolean) - Method in class jxl.CellView
-
Sets the autosize flag.
- setBackground(Colour) - Method in class jxl.write.WritableCellFormat
-
Sets the background colour for this cell format
- setBackground(Colour, Pattern) - Method in class jxl.write.WritableCellFormat
-
Sets the background colour and pattern for this cell format
- setBoldStyle(WritableFont.BoldStyle) - Method in class jxl.write.WritableFont
-
Sets the bold style for this font, if the font hasn't been initialized
- setBorder(Border, BorderLineStyle) - Method in class jxl.write.WritableCellFormat
-
Sets the specified border for this format
- setBorder(Border, BorderLineStyle, Colour) - Method in class jxl.write.WritableCellFormat
-
Sets the specified border for this format
- setBottomMargin(double) - Method in class jxl.SheetSettings
-
Sets the bottom margin
- setCellFeatures(WritableCellFeatures) - Method in interface jxl.write.WritableCell
-
Sets the cell features
- setCellFormat(CellFormat) - Method in interface jxl.write.WritableCell
-
Sets the cell format for this cell
- setCellValidationDisabled(boolean) - Method in class jxl.WorkbookSettings
-
Sets the ignore cell validation flag
- setCharacterSet(int) - Method in class jxl.WorkbookSettings
-
Sets the character set.
- setColour(Colour) - Method in class jxl.write.WritableFont
-
Sets the colour for this font, if the font hasn't been
initialized
- setColourRGB(Colour, int, int, int) - Method in class jxl.write.WritableWorkbook
-
Sets the RGB value for the specified colour for this workbook
- setColumn(double) - Method in class jxl.write.WritableImage
-
Accessor for the image position
- setColumnGroup(int, int, boolean) - Method in interface jxl.write.WritableSheet
-
Sets a column grouping
- setColumnView(int, int) - Method in interface jxl.write.WritableSheet
-
Sets the width of the column on this sheet, in characters.
- setColumnView(int, int, CellFormat) - Method in interface jxl.write.WritableSheet
-
Deprecated.
Use the CellView bean instead
- setColumnView(int, CellView) - Method in interface jxl.write.WritableSheet
-
Sets the view for this column
- setComment(String) - Method in class jxl.write.WritableCellFeatures
-
Sets the cell comment
- setComment(String, double, double) - Method in class jxl.write.WritableCellFeatures
-
Sets the cell comment and sets the size of the text box (in cells)
in which the comment is displayed
- setCopies(int) - Method in class jxl.SheetSettings
-
Sets the number of copies
- setDataValidationList(Collection) - Method in class jxl.write.WritableCellFeatures
-
The list of items to validate for this cell.
- setDataValidationRange(int, int, int, int) - Method in class jxl.write.WritableCellFeatures
-
The list of items to validate for this cell in the form of a cell range.
- setDataValidationRange(String) - Method in class jxl.write.WritableCellFeatures
-
Sets the data validation based upon a named range.
- setDate(Date) - Method in class jxl.write.DateTime
-
Sets the date for this cell
- setDate(Date, DateRecord.GMTDate) - Method in class jxl.write.DateTime
-
Sets the date for this cell, performing the necessary timezone adjustments
- setDefaultColumnWidth(int) - Method in class jxl.SheetSettings
-
Sets the default column width
- setDefaultRowHeight(int) - Method in class jxl.SheetSettings
-
Sets the default row height
- setDescription(String) - Method in class jxl.write.WritableHyperlink
-
Sets the description to appear in the hyperlink cell
- setDimension(int) - Method in class jxl.CellView
-
Deprecated.
use the setSize method instead
- setDisplayZeroValues(boolean) - Method in class jxl.SheetSettings
-
Sets the displayZeroValues property
- setDrawingsDisabled(boolean) - Method in class jxl.WorkbookSettings
-
Disables the handling of drawings
- setEncoding(String) - Method in class jxl.WorkbookSettings
-
Sets the encoding for this workbook
- setExcel9File(boolean) - Method in class jxl.WorkbookSettings
-
- setExcelDisplayLanguage(String) - Method in class jxl.WorkbookSettings
-
Sets the language in which the generated file will display
- setExcelRegionalSettings(String) - Method in class jxl.WorkbookSettings
-
Sets the regional settings for the generated excel file
- setFile(File) - Method in class jxl.write.WritableHyperlink
-
Sets the file activated by this hyperlink
- setFitHeight(int) - Method in class jxl.SheetSettings
-
Sets the number of pages vertically that this sheet will be printed into
- setFitToPages(boolean) - Method in class jxl.SheetSettings
-
Accessor for the fit to pages flag
- setFitWidth(int) - Method in class jxl.SheetSettings
-
Sets the number of pages widthwise which this sheet should be
printed into
- setFontName(String) - Method in class jxl.HeaderFooter.Contents
-
Sets the font of text subsequently appended to this
object..
- setFontSize(int) - Method in class jxl.HeaderFooter.Contents
-
Sets the font size of text subsequently appended to this
object.
- setFooter(HeaderFooter) - Method in class jxl.SheetSettings
-
Sets the footer
- setFooter(String, String, String) - Method in interface jxl.write.WritableSheet
-
Deprecated.
use the SheetSettings bean
- setFooterMargin(double) - Method in class jxl.SheetSettings
-
Sets the margin for any page footer
- setFormat(CellFormat) - Method in class jxl.CellView
-
Sets the cell format for this group of cells
- setFormulaAdjust(boolean) - Method in class jxl.WorkbookSettings
-
Setter for the formula adjust disabled property
- setGCDisabled(boolean) - Method in class jxl.WorkbookSettings
-
Sets the garbage collection disabled
- setHeader(HeaderFooter) - Method in class jxl.SheetSettings
-
Sets the header
- setHeader(String, String, String) - Method in interface jxl.write.WritableSheet
-
Deprecated.
use the SheetSettings bean
- setHeaderMargin(double) - Method in class jxl.SheetSettings
-
Sets the margin for any page headers
- setHeight(double) - Method in class jxl.write.WritableImage
-
Accessor for the image dimensions
Note that the actual size of the rendered image will depend on the
height of the rows it spans
- setHidden(boolean) - Method in class jxl.CellView
-
Sets the hidden status of this row/column
- setHidden(boolean) - Method in class jxl.SheetSettings
-
Sets the hidden status of this worksheet
- setHidden(boolean) - Method in interface jxl.write.WritableSheet
-
Deprecated.
use the SheetSettings bean instead
- setHideobj(int) - Method in class jxl.WorkbookSettings
-
The HIDEOBJ record stores options selected in the Options dialog,View tab
Possible values are:
HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS
- setHorizontalCentre(boolean) - Method in class jxl.SheetSettings
-
Sets the horizontal centre
- setHorizontalFreeze(int) - Method in class jxl.SheetSettings
-
Sets the row at which the pane is frozen horizontally
- setHorizontalPrintResolution(int) - Method in class jxl.SheetSettings
-
Sets the horizontal print resolution
- setIgnoreBlanks(boolean) - Method in class jxl.WorkbookSettings
-
Sets the ignore blanks flag
- setImageAnchor(Drawing.ImageAnchorProperties) - Method in class jxl.write.WritableImage
-
Accessor for the anchor properties
- setIndentation(int) - Method in class jxl.write.WritableCellFormat
-
Sets the indentation of the cell text
- setInitialFileSize(int) - Method in class jxl.WorkbookSettings
-
Sets the initial amount of memory allocated to store the workbook data
when reading a worksheet.
- setItalic(boolean) - Method in class jxl.write.WritableFont
-
Sets the italic indicator for this font, if the font hasn't been
initialized
- setLeftMargin(double) - Method in class jxl.SheetSettings
-
Sets the left margin
- setLocale(Locale) - Method in class jxl.WorkbookSettings
-
Sets the locale used by JExcelApi to generate the spreadsheet.
- setLocation(String, WritableSheet, int, int, int, int) - Method in class jxl.write.WritableHyperlink
-
Sets the location of the cells to be linked to within this workbook
- setLocked(boolean) - Method in class jxl.write.WritableCellFormat
-
Sets whether or not this XF record locks the cell.
- setMergedCellChecking(boolean) - Method in class jxl.WorkbookSettings
-
Accessor to set the merged cell checking
- setName(String) - Method in interface jxl.write.WritableSheet
-
Sets the name of this sheet
- setNamesDisabled(boolean) - Method in class jxl.WorkbookSettings
-
Disables the handling of names
- setNormalMagnification(int) - Method in class jxl.SheetSettings
-
Accessor for the normal magnificaton factor.
- setNumberValidation(double, BaseCellFeatures.ValidationCondition) - Method in class jxl.write.WritableCellFeatures
-
Sets the numeric value against which to validate
- setNumberValidation(double, double, BaseCellFeatures.ValidationCondition) - Method in class jxl.write.WritableCellFeatures
-
Sets the numeric range against which to validate the data
- setOrientation(PageOrientation) - Method in class jxl.SheetSettings
-
Sets the paper orientation for printing this sheet
- setOrientation(Orientation) - Method in class jxl.write.WritableCellFormat
-
Sets the text orientation for this format
- setOutputFile(File) - Method in class jxl.write.WritableWorkbook
-
Sets a new output file.
- setPageBreakPreviewMagnification(int) - Method in class jxl.SheetSettings
-
Accessor for the page break preview magnificaton factor.
- setPageBreakPreviewMode(boolean) - Method in class jxl.SheetSettings
-
Sets the pageBreakPreviewMode property
- setPageOrder(PageOrder) - Method in class jxl.SheetSettings
-
Sets the page order for printing this sheet
- setPageSetup(PageOrientation) - Method in interface jxl.write.WritableSheet
-
Sets the page setup details
- setPageSetup(PageOrientation, double, double) - Method in interface jxl.write.WritableSheet
-
Sets the page setup details
- setPageSetup(PageOrientation, PaperSize, double, double) - Method in interface jxl.write.WritableSheet
-
Sets the page setup details
- setPageStart(int) - Method in class jxl.SheetSettings
-
Sets the page number at which to commence printing
- setPaperSize(PaperSize) - Method in class jxl.SheetSettings
-
Sets the paper size to be used when printing this sheet
- setPassword(String) - Method in class jxl.SheetSettings
-
Sets the password for this sheet
- setPasswordHash(int) - Method in class jxl.SheetSettings
-
Accessor for the password hash - used only when copying sheets
- setPointSize(int) - Method in class jxl.write.WritableFont
-
Sets the point size for this font, if the font hasn't been initialized
- setPrintArea(int, int, int, int) - Method in class jxl.SheetSettings
-
Sets the print area for this sheet
- setPrintGridLines(boolean) - Method in class jxl.SheetSettings
-
Sets the printGridLines property
- setPrintHeaders(boolean) - Method in class jxl.SheetSettings
-
Sets the printHeaders property
- setPrintTitles(int, int, int, int) - Method in class jxl.SheetSettings
-
Sets both of the print titles for this sheet
- setPrintTitlesCol(int, int) - Method in class jxl.SheetSettings
-
Sets the print column titles for this sheet
- setPrintTitlesRow(int, int) - Method in class jxl.SheetSettings
-
Sets the print row titles for this sheet
- setPropertySets(boolean) - Method in class jxl.WorkbookSettings
-
Sets whether or not to enable any property sets (such as macros)
to be copied along with the workbook
Leaving this feature enabled will result in the JXL process using
more memory
- setProtected(boolean) - Method in class jxl.SheetSettings
-
Sets the protected (ie.
- setProtected(boolean) - Method in interface jxl.write.WritableSheet
-
Deprecated.
use the SheetSettings bean instead
- setProtected(boolean) - Method in class jxl.write.WritableWorkbook
-
Indicates whether or not this workbook is protected
- setRationalization(boolean) - Method in class jxl.WorkbookSettings
-
Sets whether or not to rationalize the cell formats before
writing out the sheet.
- setRecalculateFormulasBeforeSave(boolean) - Method in class jxl.SheetSettings
-
Sets the recalculate formulas when the sheet is saved flag
- setRefreshAll(boolean) - Method in class jxl.WorkbookSettings
-
When true then Refresh All should be done on all external data ranges and
PivotTables when loading the workbook (the default is =0)
- setRightMargin(double) - Method in class jxl.SheetSettings
-
Sets the right margin
- setRow(double) - Method in class jxl.write.WritableImage
-
Accessor for the image position
- setRowGroup(int, int, boolean) - Method in interface jxl.write.WritableSheet
-
Sets a row grouping
- setRowView(int, int) - Method in interface jxl.write.WritableSheet
-
Sets the height of the specified row, as well as its collapse status
- setRowView(int, boolean) - Method in interface jxl.write.WritableSheet
-
Sets the properties of the specified row
- setRowView(int, int, boolean) - Method in interface jxl.write.WritableSheet
-
Sets the height of the specified row, as well as its collapse status
- setRowView(int, CellView) - Method in interface jxl.write.WritableSheet
-
Sets the view for this column
- setScaleFactor(int) - Method in class jxl.SheetSettings
-
Sets the scale factor for this sheet to be used when printing.
- setScriptStyle(ScriptStyle) - Method in class jxl.write.WritableFont
-
Sets the script style (eg.
- setSelected() - Method in class jxl.SheetSettings
-
Deprecated.
use overloaded version which takes a boolean
- setSelected(boolean) - Method in class jxl.SheetSettings
-
Sets this sheet to be when it is opened in excel
- setShowGridLines(boolean) - Method in class jxl.SheetSettings
-
Sets the showGridLines property
- setShrinkToFit(boolean) - Method in class jxl.write.WritableCellFormat
-
Sets the shrink to fit flag
- setSize(int) - Method in class jxl.CellView
-
Sets the dimension for this view
- setString(String) - Method in class jxl.write.Label
-
Sets the string contents of this cell
- setStruckout(boolean) - Method in class jxl.write.WritableFont
-
Sets Accessor for the strike-out flag
- setSuppressWarnings(boolean) - Method in class jxl.WorkbookSettings
-
Accessor to set the suppress warnings flag.
- setTemplate(boolean) - Method in class jxl.WorkbookSettings
-
Workbook Is a Template
- setTemporaryFileDuringWriteDirectory(File) - Method in class jxl.WorkbookSettings
-
Used in conjunction with the UseTemporaryFileDuringWrite setting to
set the target directory for the temporary files.
- setTopMargin(double) - Method in class jxl.SheetSettings
-
Sets the top margin
- setUnderlineStyle(UnderlineStyle) - Method in class jxl.write.WritableFont
-
Sets the underline style for this font, if the font hasn't been
initialized
- setURL(URL) - Method in class jxl.write.WritableHyperlink
-
Sets the URL of this hyperlink
- setUseTemporaryFileDuringWrite(boolean) - Method in class jxl.WorkbookSettings
-
Sets whether a temporary file is used during the generation of
the workbook.
- setValue(boolean) - Method in class jxl.write.Boolean
-
Sets the boolean value for this cell
- setValue(double) - Method in class jxl.write.Number
-
Sets the numerical value for this cell
- setVerticalAlignment(VerticalAlignment) - Method in class jxl.write.WritableCellFormat
-
Sets the vertical alignment for this format
- setVerticalCentre(boolean) - Method in class jxl.SheetSettings
-
Sets the vertical centre
- setVerticalFreeze(int) - Method in class jxl.SheetSettings
-
Sets the row at which the pane is frozen vertically
- setVerticalPrintResolution(int) - Method in class jxl.SheetSettings
-
Sets the vertical print reslution
- setWidth(double) - Method in class jxl.write.WritableImage
-
Accessor for the image dimensions
Note that the actual size of the rendered image will depend on the
width of the columns it spans
- setWindowProtected(boolean) - Method in class jxl.WorkbookSettings
-
- setWrap(boolean) - Method in class jxl.write.WritableCellFormat
-
Sets the wrap indicator for this format.
- setWriteAccess(String) - Method in class jxl.WorkbookSettings
-
- setZoomFactor(int) - Method in class jxl.SheetSettings
-
Sets the zoom factor.
- Sheet - Interface in jxl
-
Represents a sheet within a workbook.
- SheetSettings - Class in jxl
-
This is a bean which client applications may use to get/set various
properties which are associated with a particular worksheet, such
as headers and footers, page orientation etc.
- SheetSettings(Sheet) - Constructor for class jxl.SheetSettings
-
Default constructor
- SheetSettings(SheetSettings, Sheet) - Constructor for class jxl.SheetSettings
-
Copy constructor.
- SINGLE - Static variable in class jxl.format.UnderlineStyle
-
- SINGLE - Static variable in class jxl.write.Font
-
Deprecated.
- SINGLE_ACCOUNTING - Static variable in class jxl.format.UnderlineStyle
-
- SINGLE_ACCOUNTING - Static variable in class jxl.write.Font
-
Deprecated.
- SIZE_10x11 - Static variable in class jxl.format.PaperSize
-
10×11 10" × 11"
- SIZE_10x14 - Static variable in class jxl.format.PaperSize
-
10" x 14"
- SIZE_10x17 - Static variable in class jxl.format.PaperSize
-
11" x 17"
- SIZE_15x11 - Static variable in class jxl.format.PaperSize
-
15×11 15" × 11"
- SIZE_9x11 - Static variable in class jxl.format.PaperSize
-
9×11 9" × 11"
- SKY_BLUE - Static variable in class jxl.format.Colour
-
- SLANTED_DASH_DOT - Static variable in class jxl.format.BorderLineStyle
-
- SOLID - Static variable in class jxl.format.Pattern
-
- STACKED - Static variable in class jxl.format.Orientation
-
Cells with this specified orientation will have their text stacked
downwards, but not rotated
- STATEMENT - Static variable in class jxl.format.PaperSize
-
Statement 5.5" x 8.5"
- STRING_FORMULA - Static variable in class jxl.CellType
-
- StringFormulaCell - Interface in jxl
-
A mixin interface for numerical formulas, which combines the interfaces
for formulas and for strings
- SUBSCRIPT - Static variable in class jxl.format.ScriptStyle
-
- SUBSCRIPT - Static variable in class jxl.write.Font
-
Deprecated.
- SUPER_A_A4 - Static variable in class jxl.format.PaperSize
-
Super A/A4 227mm × 356mm
- SUPER_B_A3 - Static variable in class jxl.format.PaperSize
-
Super B/A3 305mm × 487mm
- SUPERSCRIPT - Static variable in class jxl.format.ScriptStyle
-
- SUPERSCRIPT - Static variable in class jxl.write.Font
-
Deprecated.