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