跳过导航链接
A B C D E F G H I J L M N O P Q R S T U V W X Y 

A

A2 - 类 中的静态变量jxl.format.PaperSize
A2 420mm � 594mm
A3 - 类 中的静态变量jxl.format.PaperSize
A3 297mm x 420mm
A3_EXTRA - 类 中的静态变量jxl.format.PaperSize
A3 Extra 322mm � 445mm
A3_EXTRA_TRANSVERSE - 类 中的静态变量jxl.format.PaperSize
A3 Extra Transverse 322mm � 445mm
A3_ROTATED - 类 中的静态变量jxl.format.PaperSize
A3 Rotated 420mm � 297mm
A3_TRANSVERSE - 类 中的静态变量jxl.format.PaperSize
A3 Transverse 297mm � 420mm
A4 - 类 中的静态变量jxl.format.PaperSize
A4 210mm x 297mm
A4_EXTRA - 类 中的静态变量jxl.format.PaperSize
A4 Extra 235mm � 322mm
A4_PLUS - 类 中的静态变量jxl.format.PaperSize
A4 Plus 210mm � 330mm
A4_ROTATED - 类 中的静态变量jxl.format.PaperSize
A4 Rotated 297mm � 210mm
A4_SMALL - 类 中的静态变量jxl.format.PaperSize
A4 Small 210mm x 297 mm
A4_TRANSVERSE - 类 中的静态变量jxl.format.PaperSize
A4 Transverse 210mm � 297mm
A5 - 类 中的静态变量jxl.format.PaperSize
A5 148mm x 210mm
A5_EXTRA - 类 中的静态变量jxl.format.PaperSize
A5 Extra 174mm � 235mm
A5_ROTATED - 类 中的静态变量jxl.format.PaperSize
A5 Rotated 210mm � 148mm
A5_TRANSVERSE - 类 中的静态变量jxl.format.PaperSize
A5 Transverse 148mm � 210mm
A6 - 类 中的静态变量jxl.format.PaperSize
A6 105mm � 148mm
A6_ROTATED - 类 中的静态变量jxl.format.PaperSize
A6 Rotated 148mm � 105mm
ACCOUNTING_FLOAT - 类 中的静态变量jxl.write.NumberFormats
Formatting for an integer which is presented in accounting format (ie. deficits appear in parentheses) Equivalent to a DecimalFormat of "$#,##0;($#,##0)"
ACCOUNTING_INTEGER - 类 中的静态变量jxl.write.NumberFormats
Formatting for an integer which is presented in accounting format (ie. deficits appear in parentheses) Equivalent to a DecimalFormat of "$#,##0;($#,##0)"
ACCOUNTING_RED_FLOAT - 类 中的静态变量jxl.write.NumberFormats
As ACCOUNTING_FLOAT except that deficits appear coloured red
ACCOUNTING_RED_INTEGER - 类 中的静态变量jxl.write.NumberFormats
As ACCOUNTING_INTEGER except that deficits appear coloured red
addCell(WritableCell) - 接口 中的方法jxl.write.WritableSheet
Adds a cell to this sheet The RowsExceededException may be caught if client code wishes to explicitly trap the case where too many rows have been written to the current sheet.
addColumnPageBreak(int) - 接口 中的方法jxl.write.WritableSheet
Forces a page break at the specified column
addHyperlink(WritableHyperlink) - 接口 中的方法jxl.write.WritableSheet
Adds the specified hyperlink.
addImage(WritableImage) - 接口 中的方法jxl.write.WritableSheet
Adds an image to the sheet
addNameArea(String, WritableSheet, int, int, int, int) - 类 中的方法jxl.write.WritableWorkbook
Add new named area to this workbook with the given information.
addRowPageBreak(int) - 接口 中的方法jxl.write.WritableSheet
Forces a page break at the specified row
Alignment - jxl.format中的类
Enumeration class which contains the various alignments for data within a cell
Alignment - jxl.write中的类
已过时。
Repackaged as jxl.Alignment. This version is retained for backwards compatibility
ALL - 类 中的静态变量jxl.format.Border
 
append(String) - 类 中的方法jxl.HeaderFooter.Contents
Appends the text to the string buffer
appendDate() - 类 中的方法jxl.HeaderFooter.Contents
Appends the current date
appendPageNumber() - 类 中的方法jxl.HeaderFooter.Contents
Appends the page number
appendTime() - 类 中的方法jxl.HeaderFooter.Contents
Appends the current time
appendTotalPages() - 类 中的方法jxl.HeaderFooter.Contents
Appends the total number of pages
appendWorkbookName() - 类 中的方法jxl.HeaderFooter.Contents
Appends the workbook name
appendWorkSheetName() - 类 中的方法jxl.HeaderFooter.Contents
Appends the worksheet name
applySharedDataValidation(WritableCell, int, int) - 接口 中的方法jxl.write.WritableSheet
Extend the data validation contained in the specified cell across and downwards.
AQUA - 类 中的静态变量jxl.format.Colour
 
ARIAL - 类 中的静态变量jxl.write.Font
已过时。 
ARIAL - 类 中的静态变量jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as ARIAL fonts
ARIAL_10_PT - 类 中的静态变量jxl.write.WritableWorkbook
The default font for Cell formats
AUTOMATIC - 类 中的静态变量jxl.format.Colour
 

B

B4 - 类 中的静态变量jxl.format.PaperSize
B4 (JIS) 257mm x 364mm
B4_ISO - 类 中的静态变量jxl.format.PaperSize
B4 (ISO) 250mm � 353mm
B4_ISO_2 - 类 中的静态变量jxl.format.PaperSize
B4 (ISO) 250mm � 353mm
B4_ROTATED - 类 中的静态变量jxl.format.PaperSize
B4 (JIS) Rotated 364mm � 257mm
B5 - 类 中的静态变量jxl.format.PaperSize
B5 (JIS) 182mm x 257mm
B5_EXTRA - 类 中的静态变量jxl.format.PaperSize
B5 (ISO) Extra 201mm � 276mm
B5_ISO - 类 中的静态变量jxl.format.PaperSize
B5 (ISO) 176mm � 250mm
B5_ROTATED - 类 中的静态变量jxl.format.PaperSize
B5 (JIS) Rotated 257mm � 182mm
B5_TRANSVERSE - 类 中的静态变量jxl.format.PaperSize
B5 (JIS) Transverse 182mm � 257mm
B6 - 类 中的静态变量jxl.format.PaperSize
B6 (JIS) 128mm � 182mm
B6_ISO - 类 中的静态变量jxl.format.PaperSize
B6 (ISO) 125mm � 176mm
B6_ROTATED - 类 中的静态变量jxl.format.PaperSize
B6 (JIS) Rotated 182mm � 128mm
BETWEEN - 类 中的静态变量jxl.write.WritableCellFeatures
 
BLACK - 类 中的静态变量jxl.format.Colour
 
Blank - jxl.write中的类
A blank cell.
Blank(int, int) - 类 的构造器jxl.write.Blank
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates
Blank(int, int, CellFormat) - 类 的构造器jxl.write.Blank
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates in the manner specified by the CellFormat parameter
Blank(Cell) - 类 的构造器jxl.write.Blank
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
BLUE - 类 中的静态变量jxl.format.Colour
 
BLUE2 - 类 中的静态变量jxl.format.Colour
 
BLUE_GREY - 类 中的静态变量jxl.format.Colour
 
BOLD - 类 中的静态变量jxl.format.BoldStyle
Emboldened style
BOLD - 类 中的静态变量jxl.write.Font
已过时。 
BOLD - 类 中的静态变量jxl.write.WritableFont
Indicates that this font should be presented in a BOLD style
BoldStyle - jxl.format中的类
Enumeration class containing the various bold styles for data
BoldStyle - jxl.write中的类
Enumeration class containing the various bold styles for data
BOOLEAN - 类 中的静态变量jxl.CellType
 
Boolean - jxl.write中的类
A cell, created by user applications, which contains a boolean (or in some cases an error) value
Boolean(int, int, boolean) - 类 的构造器jxl.write.Boolean
Constructs a boolean value, which, when added to a spreadsheet, will display the specified value at the column/row position indicated.
Boolean(int, int, boolean, CellFormat) - 类 的构造器jxl.write.Boolean
Constructs a boolean, which, when added to a spreadsheet, will display the specified value at the column/row position with the specified CellFormat.
Boolean(BooleanCell) - 类 的构造器jxl.write.Boolean
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
BOOLEAN_FORMULA - 类 中的静态变量jxl.CellType
 
BooleanCell - jxl中的接口
This type represents the Microsoft concept of a Boolean.
BooleanFormulaCell - jxl中的接口
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
Border - jxl.format中的类
The location of a border
Border - jxl.write中的类
已过时。
repackaged as jxl.format.Border
BorderLineStyle - jxl.format中的类
The border line style
BorderLineStyle - jxl.write中的类
已过时。
Repackaged as jxl.format.BorderLineStyle
BOTTOM - 类 中的静态变量jxl.format.Border
 
BOTTOM - 类 中的静态变量jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned at the bottom
BRIGHT_GREEN - 类 中的静态变量jxl.format.Colour
 
BROWN - 类 中的静态变量jxl.format.Colour
 

C

C - 类 中的静态变量jxl.format.PaperSize
C 17" x 22"
Cell - jxl中的接口
Represents an individual Cell within a Sheet.
CellFeatures - jxl中的类
Container for any additional cell features
CellFeatures() - 类 的构造器jxl.CellFeatures
Constructor
CellFormat - jxl中的接口
已过时。
Repackaged as jxl.format.CellFormat
CellFormat - jxl.format中的接口
Interface for cell formats
CellReferenceHelper - jxl中的类
Exposes some cell reference helper methods to the public interface.
CellType - jxl中的类
An enumeration type listing the available content types for a cell
CellView - jxl中的类
This is a bean which client applications may use to get/set various properties for a row or column on a spreadsheet
CellView() - 类 的构造器jxl.CellView
Default constructor
CellView(CellView) - 类 的构造器jxl.CellView
Copy constructor
CENTRE - 类 中的静态变量jxl.format.Alignment
Data in cells with this alignment will be centred
CENTRE - 类 中的静态变量jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned centrally
clear() - 类 中的方法jxl.HeaderFooter
Clears the contents of the header/footer
clear() - 类 中的方法jxl.HeaderFooter.Contents
Clears the contents of this portion
close() - 类 中的方法jxl.Workbook
Closes this workbook, and frees makes any memory allocated available for garbage collection
close() - 类 中的方法jxl.write.WritableWorkbook
Closes this workbook, and makes any memory allocated available for garbage collection.
Colour - jxl.format中的类
Enumeration class which contains the various colours available within the standard Excel colour palette
Colour - jxl.write中的类
已过时。
This has been repackaged as jxl.format.Colour
COMPLEX_FORMAT - 类 中的静态变量jxl.write.NumberFormat
Pass in to the constructor to bypass the format validation
copy(Workbook) - 类 中的方法jxl.write.WritableWorkbook
已过时。
Copying now occurs implicitly as part of the overloaded factory method Workbook.createWorkbood
copySheet(int, String, int) - 类 中的方法jxl.write.WritableWorkbook
Copy sheet within the same workbook.
copySheet(String, String, int) - 类 中的方法jxl.write.WritableWorkbook
Copies the specified sheet and places it at the index specified by the parameter
copyTo(int, int) - 类 中的方法jxl.write.Blank
Implementation of the deep copy function
copyTo(int, int) - 类 中的方法jxl.write.Boolean
Implementation of the deep copy function
copyTo(int, int) - 类 中的方法jxl.write.DateTime
Implementation of the deep copy function
copyTo(int, int) - 类 中的方法jxl.write.Formula
Implementation of the deep copy function
copyTo(int, int) - 类 中的方法jxl.write.Label
Implementation of the deep copy function
copyTo(int, int) - 类 中的方法jxl.write.Number
Implementation of the deep copy function
copyTo(int, int) - 接口 中的方法jxl.write.WritableCell
A deep copy.
CORAL - 类 中的静态变量jxl.format.Colour
 
COURIER - 类 中的静态变量jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as COURIER fonts
createFont(String) - 类 中的静态方法jxl.write.WritableFont
Factory method which creates the specified font name.
createSheet(String, int) - 类 中的方法jxl.write.WritableWorkbook
Creates, and returns a worksheet at the specified position with the specified name If the index specified is less than or equal to zero, the new sheet is created at the beginning of the workbook.
createWorkbook(File) - 类 中的静态方法jxl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, WorkbookSettings) - 类 中的静态方法jxl.Workbook
Creates a writable workbook with the given file name
createWorkbook(File, Workbook) - 类 中的静态方法jxl.Workbook
Creates a writable workbook with the given filename as a copy of the workbook passed in.
createWorkbook(File, Workbook, WorkbookSettings) - 类 中的静态方法jxl.Workbook
Creates a writable workbook with the given filename as a copy of the workbook passed in.
createWorkbook(OutputStream, Workbook) - 类 中的静态方法jxl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
createWorkbook(OutputStream, Workbook, WorkbookSettings) - 类 中的静态方法jxl.Workbook
Creates a writable workbook as a copy of the workbook passed in.
createWorkbook(OutputStream) - 类 中的静态方法jxl.Workbook
Creates a writable workbook.
createWorkbook(OutputStream, WorkbookSettings) - 类 中的静态方法jxl.Workbook
Creates a writable workbook.
CSV - jxl.demo中的类
Simple demo class which uses the api to present the contents of an excel 97 spreadsheet as comma separated values, using a workbook and output stream of your choice
CSV(Workbook, OutputStream, String, boolean) - 类 的构造器jxl.demo.CSV
Constructor
CURRENCY_DOLLAR - 类 中的静态变量jxl.write.NumberFormat
Constant format string for the US Dollar sign
CURRENCY_EURO_PREFIX - 类 中的静态变量jxl.write.NumberFormat
Constant format string for the Euro currency symbol where it precedes the format
CURRENCY_EURO_SUFFIX - 类 中的静态变量jxl.write.NumberFormat
Constant format string for the Euro currency symbol where it precedes the format
CURRENCY_JAPANESE_YEN - 类 中的静态变量jxl.write.NumberFormat
Constant format string for the Japanese Yen sign
CURRENCY_POUND - 类 中的静态变量jxl.write.NumberFormat
Constant format string for the UK pound sign

D

D - 类 中的静态变量jxl.format.PaperSize
D 22" x 34"
DARK_BLUE - 类 中的静态变量jxl.format.Colour
 
DARK_BLUE2 - 类 中的静态变量jxl.format.Colour
 
DARK_GREEN - 类 中的静态变量jxl.format.Colour
 
DARK_PURPLE - 类 中的静态变量jxl.format.Colour
 
DARK_RED - 类 中的静态变量jxl.format.Colour
 
DARK_RED2 - 类 中的静态变量jxl.format.Colour
 
DARK_TEAL - 类 中的静态变量jxl.format.Colour
 
DARK_YELLOW - 类 中的静态变量jxl.format.Colour
 
DASH_DOT - 类 中的静态变量jxl.format.BorderLineStyle
 
DASH_DOT_DOT - 类 中的静态变量jxl.format.BorderLineStyle
 
DASHED - 类 中的静态变量jxl.format.BorderLineStyle
 
DATE - 类 中的静态变量jxl.CellType
 
DATE_FORMULA - 类 中的静态变量jxl.CellType
 
DateCell - jxl中的接口
A date cell
DateFormat - jxl.write中的类
A custom user defined number format which may be instantiated within user applications in order to present date and time values in the appropriate format.
DateFormat(String) - 类 的构造器jxl.write.DateFormat
Constructor.
DateFormats - jxl.write中的类
Static class which contains Excels predefined Date formats
DateFormats() - 类 的构造器jxl.write.DateFormats
 
DateFormulaCell - jxl中的接口
A mixin interface for date formulas, which combines the interfaces for formulas and for dates
DateTime - jxl.write中的类
A Date which may be created on the fly by a user application and added to a spreadsheet NOTE: By default, all dates will have local timezone information added to their UTC value.
DateTime(int, int, Date) - 类 的构造器jxl.write.DateTime
Constructor.
DateTime(int, int, Date, DateRecord.GMTDate) - 类 的构造器jxl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account.
DateTime(int, int, Date, CellFormat) - 类 的构造器jxl.write.DateTime
Constructor which takes the format for this cell
DateTime(int, int, Date, CellFormat, DateRecord.GMTDate) - 类 的构造器jxl.write.DateTime
Constructor, which adjusts the specified date to take timezone considerations into account
DateTime(int, int, Date, CellFormat, boolean) - 类 的构造器jxl.write.DateTime
Constructor which takes the format for the cell and an indicator as to whether this cell is a full date time or purely just a time eg. if the spreadsheet is to contain the world record for 100m, then the value would be 9.83s, which would be indicated as just a time
DateTime(DateCell) - 类 的构造器jxl.write.DateTime
A constructor called by the worksheet when creating a writable version of a spreadsheet that has been read in
DEFAULT - 类 中的静态变量jxl.write.DateFormats
The default format.
DEFAULT - 类 中的静态变量jxl.write.NumberFormats
The default format.
DEFAULT_BACKGROUND - 类 中的静态变量jxl.format.Colour
 
DEFAULT_BACKGROUND1 - 类 中的静态变量jxl.format.Colour
 
DEFAULT_DEFAULT_ROW_HEIGHT - 类 中的静态变量jxl.SheetSettings
The default value for the default row height
DEFAULT_POINT_SIZE - 类 中的静态变量jxl.write.WritableFont
The default point size for all Fonts
Demo - jxl.demo中的类
The main demo class which interprets the command line switches in order to determine how to call the demo programs The demo program uses stdout as its default output stream
Demo() - 类 的构造器jxl.demo.Demo
 
depUsed() - 类 中的方法jxl.CellView
Accessor for the depUsed attribute
DOTTED - 类 中的静态变量jxl.format.BorderLineStyle
 
DOUBLE - 类 中的静态变量jxl.format.BorderLineStyle
 
DOUBLE - 类 中的静态变量jxl.format.UnderlineStyle
 
DOUBLE - 类 中的静态变量jxl.write.Font
已过时。 
DOUBLE_ACCOUNTING - 类 中的静态变量jxl.format.UnderlineStyle
 
DOUBLE_ACCOUNTING - 类 中的静态变量jxl.write.Font
已过时。 
DOUBLE_JAPANESE_POSTCARD - 类 中的静态变量jxl.format.PaperSize
Dbl.
DOUBLE_JAPANESE_POSTCARD_ROTATED - 类 中的静态变量jxl.format.PaperSize
Dbl.
DOWN_THEN_RIGHT - 类 中的静态变量jxl.format.PageOrder
Top to Down then Right.

E

E - 类 中的静态变量jxl.format.PaperSize
E 34" x 44"
EMPTY - 类 中的静态变量jxl.CellType
An empty cell can still contain formatting information and comments
empty() - 类 中的方法jxl.HeaderFooter.Contents
Queries if the contents are empty
ENVELOPE_10 - 类 中的静态变量jxl.format.PaperSize
Envelope #10 4 1/8" x 9.5"
ENVELOPE_11 - 类 中的静态变量jxl.format.PaperSize
Envelope #11 4.5" x 10 3/8"
ENVELOPE_12 - 类 中的静态变量jxl.format.PaperSize
Envelope #12 4.75" x 11"
ENVELOPE_14 - 类 中的静态变量jxl.format.PaperSize
Envelope #14 5" x 11.5"
ENVELOPE_6_75 - 类 中的静态变量jxl.format.PaperSize
6.75 Envelope 3 5/8" � 6.5"
ENVELOPE_9 - 类 中的静态变量jxl.format.PaperSize
Envelope #9 3 7/8" x 8 7/8"
ENVELOPE_C3 - 类 中的静态变量jxl.format.PaperSize
Envelope C3 324mm � 458mm
ENVELOPE_C4 - 类 中的静态变量jxl.format.PaperSize
Envelope C4 229mm � 324mm
ENVELOPE_C5 - 类 中的静态变量jxl.format.PaperSize
Envelope C5 162mm � 229mm
ENVELOPE_C6 - 类 中的静态变量jxl.format.PaperSize
Envelope C6 114mm � 162mm
ENVELOPE_C6_C5 - 类 中的静态变量jxl.format.PaperSize
Envelope C6/C5 114mm � 229mm
ENVELOPE_DL - 类 中的静态变量jxl.format.PaperSize
Envelope DL 110mm � 220mm
ENVELOPE_INVITE - 类 中的静态变量jxl.format.PaperSize
Envelope Invite 220mm � 220mm
ENVELOPE_ITALY - 类 中的静态变量jxl.format.PaperSize
Envelope Italy 110mm � 230mm
ENVELOPE_MONARCH - 类 中的静态变量jxl.format.PaperSize
Envelope Monarch 3 7/8" � 7.5"
EQUAL - 类 中的静态变量jxl.write.WritableCellFeatures
 
ERROR - 类 中的静态变量jxl.CellType
 
ErrorCell - jxl中的接口
This type represents a cell which contains an error.
ErrorFormulaCell - jxl中的接口
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers
Escher - jxl.demo中的类
Displays the escher data
Escher(Workbook, OutputStream, String) - 类 的构造器jxl.demo.Escher
Constructor
EscherDrawingGroup - jxl.demo中的类
Displays the escher data
EscherDrawingGroup(Workbook, OutputStream, String) - 类 的构造器jxl.demo.EscherDrawingGroup
Constructor
EXECUTIVE - 类 中的静态变量jxl.format.PaperSize
Executive 7.25" x 10.5"
EXPONENTIAL - 类 中的静态变量jxl.write.NumberFormats
Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"

F

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中的类
已过时。
Renamed to writable font
Font(WritableFont.FontName) - 类 的构造器jxl.write.Font
已过时。
Use jxl.write.WritableFont
Font(WritableFont.FontName, int) - 类 的构造器jxl.write.Font
已过时。
use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle) - 类 的构造器jxl.write.Font
已过时。
use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean) - 类 的构造器jxl.write.Font
已过时。
use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle) - 类 的构造器jxl.write.Font
已过时。
use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour) - 类 的构造器jxl.write.Font
已过时。
use jxl.write.WritableFont
Font(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour, ScriptStyle) - 类 的构造器jxl.write.Font
已过时。
use jxl.write.WritableFont
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

G

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
已过时。
Use getColumnView and the CellView bean instead
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
已过时。
Use getColumnView instead
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
已过时。
use getDefaultRGB instead
getDefaultColumnWidth() - 类 中的方法jxl.SheetSettings
Accessor for the default column width
getDefaultGreen() - 类 中的方法jxl.format.Colour
已过时。
use getDefaultRGB instead
getDefaultHeightMargin() - 类 中的方法jxl.SheetSettings
Gets the default margin height
getDefaultRed() - 类 中的方法jxl.format.Colour
已过时。
use getDefaultRGB instead
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
已过时。
use getSize() instead
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
已过时。
use getRowView instead
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
 

H

HAIR - 类 中的静态变量jxl.format.BorderLineStyle
 
hasBorders() - 接口 中的方法jxl.format.CellFormat
Determines if this cell format has any borders at all.
HeaderFooter - jxl中的类
Class which represents an Excel header or footer.
HeaderFooter() - 类 的构造器jxl.HeaderFooter
Default constructor.
HeaderFooter(HeaderFooter) - 类 的构造器jxl.HeaderFooter
Copy constructor
HeaderFooter(String) - 类 的构造器jxl.HeaderFooter
Constructor used when reading workbooks to separate the left, right a central part of the strings into their constituent parts
HeaderFooter.Contents - jxl中的类
The contents - a simple wrapper around a string buffer
HIDDEN_STYLE - 类 中的静态变量jxl.write.WritableWorkbook
A cell format used to hide the cell contents
HIDEOBJ_HIDE_ALL - 类 中的静态变量jxl.WorkbookSettings
The HIDEOBJ record stores options selected in the Options dialog,View tab.
HIDEOBJ_SHOW_ALL - 类 中的静态变量jxl.WorkbookSettings
The HIDEOBJ record stores options selected in the Options dialog,View tab.
HIDEOBJ_SHOW_PLACEHOLDERS - 类 中的静态变量jxl.WorkbookSettings
The HIDEOBJ record stores options selected in the Options dialog,View tab.
HORIZONTAL - 类 中的静态变量jxl.format.Orientation
Cells with this specified orientation will be horizontal
Hyperlink - jxl中的接口
Hyperlink information.
HYPERLINK_FONT - 类 中的静态变量jxl.write.WritableWorkbook
The font used for hyperlinks
HYPERLINK_STYLE - 类 中的静态变量jxl.write.WritableWorkbook
The style used for hyperlinks

I

ICE_BLUE - 类 中的静态变量jxl.format.Colour
 
Image - jxl中的接口
Accessor functions for an image
importSheet(String, int, Sheet) - 类 中的方法jxl.write.WritableWorkbook
Imports a sheet from a different workbook.
INDIGO - 类 中的静态变量jxl.format.Colour
 
insertColumn(int) - 接口 中的方法jxl.write.WritableSheet
Inserts a blank column into this spreadsheet.
insertRow(int) - 接口 中的方法jxl.write.WritableSheet
Inserts a blank row into this spreadsheet.
INTEGER - 类 中的静态变量jxl.write.NumberFormats
Formatting for an integer number.
isAutosize() - 类 中的方法jxl.CellView
Accessor for the autosize flag NOTE: use of the autosize function is very processor intensive, so use with care
isColumnRelative(String) - 类 中的静态方法jxl.CellReferenceHelper
Sees if the column component is relative or not
isFile() - 接口 中的方法jxl.Hyperlink
Determines whether this is a hyperlink to a file
isHidden() - 接口 中的方法jxl.Cell
Indicates whether or not this cell is hidden, by virtue of either the entire row or column being collapsed
isHidden() - 类 中的方法jxl.CellView
Accessor for the hidden nature of this row/column
isHidden() - 接口 中的方法jxl.Sheet
已过时。
in favour of the getSettings() method
isHidden() - 类 中的方法jxl.SheetSettings
Accessor for the hidden nature of this sheet
isHorizontalCentre() - 类 中的方法jxl.SheetSettings
Accessor for the horizontal centre
isItalic() - 接口 中的方法jxl.format.Font
Returns the italic flag
isLocation() - 接口 中的方法jxl.Hyperlink
Determines whether this is a hyperlink to a location in this workbook
isLocked() - 接口 中的方法jxl.format.CellFormat
Accessor for whether a particular cell is locked
isProtected() - 接口 中的方法jxl.Sheet
已过时。
in favour of the getSettings() method
isProtected() - 类 中的方法jxl.SheetSettings
Queries whether this sheet is protected (ie. read only)
isProtected() - 类 中的方法jxl.Workbook
Determines whether the sheet is protected
isRowRelative(String) - 类 中的静态方法jxl.CellReferenceHelper
Sees if the row component is relative or not
isSelected() - 类 中的方法jxl.SheetSettings
Accessor for the selected nature of the sheet
isShrinkToFit() - 接口 中的方法jxl.format.CellFormat
Gets the shrink to fit flag
isStruckout() - 接口 中的方法jxl.format.Font
Returns the strike-out flag
isStruckout() - 类 中的方法jxl.write.WritableFont
Accessor for the strike-out flag
isTime() - 接口 中的方法jxl.DateCell
Indicates whether the date value contained in this cell refers to a date, or merely a time
isURL() - 接口 中的方法jxl.Hyperlink
Determines whether this is a hyperlink to a web resource
isVerticalCentre() - 类 中的方法jxl.SheetSettings
Accessor for the vertical centre
IVORY - 类 中的静态变量jxl.format.Colour
 

J

JAPANESE_POSTCARD - 类 中的静态变量jxl.format.PaperSize
Japanese Postcard 100mm � 148mm
JAPANESE_POSTCARD_ROTATED - 类 中的静态变量jxl.format.PaperSize
Japanese Postcard Rot. 148mm � 100mm
JUSTIFY - 类 中的静态变量jxl.format.Alignment
Data in cells with this alignment will be justified
JUSTIFY - 类 中的静态变量jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data justified
jxl - 程序包 jxl
 
jxl.demo - 程序包 jxl.demo
 
jxl.format - 程序包 jxl.format
 
jxl.write - 程序包 jxl.write
 
JXLException - jxl中的异常错误
Base exception class for JExcelAPI exceptions

L

LABEL - 类 中的静态变量jxl.CellType
 
Label - jxl.write中的类
A cell containing text which may be created by user applications
Label(int, int, String) - 类 的构造器jxl.write.Label
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates and will contain the specified text
Label(int, int, String, CellFormat) - 类 的构造器jxl.write.Label
Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates and will present the specified text in the manner specified by the CellFormat parameter
Label(LabelCell) - 类 的构造器jxl.write.Label
Constructor used internally by the application when making a writable copy of a spreadsheet being read in
LabelCell - jxl中的接口
A label cell
LANDSCAPE - 类 中的静态变量jxl.format.PageOrientation
Landscape orientation
LAVENDER - 类 中的静态变量jxl.format.Colour
 
LEDGER - 类 中的静态变量jxl.format.PaperSize
Leger 17" x 11"
LEFT - 类 中的静态变量jxl.format.Alignment
Data cells with this alignment will appear at the left hand edge of the cell
LEFT - 类 中的静态变量jxl.format.Border
 
LEGAL - 类 中的静态变量jxl.format.PaperSize
US Legal 8.5" x 14"
LEGAL_EXTRA - 类 中的静态变量jxl.format.PaperSize
Legal Extra 9.5" � 15"
LESS_EQUAL - 类 中的静态变量jxl.write.WritableCellFeatures
 
LESS_THAN - 类 中的静态变量jxl.write.WritableCellFeatures
 
LETTER - 类 中的静态变量jxl.format.PaperSize
US Letter 8.5 x 11"
LETTER_EXTRA - 类 中的静态变量jxl.format.PaperSize
Letter Extra 9.5" � 12"
LETTER_EXTRA_TRANSVERSE - 类 中的静态变量jxl.format.PaperSize
Letter Extra Transv. 9.5" � 12"
LETTER_PLUS - 类 中的静态变量jxl.format.PaperSize
Letter Plus 8.5" x 12 11/16"
LETTER_ROTATED - 类 中的静态变量jxl.format.PaperSize
Letter Rotated 11" � 8.5"
LETTER_SMALL - 类 中的静态变量jxl.format.PaperSize
Letter small 8.5" � 11"
LETTER_TRANSVERSE - 类 中的静态变量jxl.format.PaperSize
Letter Transverse 8.5" � 11"
LIGHT_BLUE - 类 中的静态变量jxl.format.Colour
 
LIGHT_GREEN - 类 中的静态变量jxl.format.Colour
 
LIGHT_ORANGE - 类 中的静态变量jxl.format.Colour
 
LIGHT_TURQUOISE - 类 中的静态变量jxl.format.Colour
 
LIGHT_TURQUOISE2 - 类 中的静态变量jxl.format.Colour
 
LIME - 类 中的静态变量jxl.format.Colour
 

M

main(String[]) - 类 中的静态方法jxl.demo.Demo
The main method.
MEDIUM - 类 中的静态变量jxl.format.BorderLineStyle
 
MEDIUM_DASH_DOT - 类 中的静态变量jxl.format.BorderLineStyle
 
MEDIUM_DASH_DOT_DOT - 类 中的静态变量jxl.format.BorderLineStyle
 
MEDIUM_DASHED - 类 中的静态变量jxl.format.BorderLineStyle
 
mergeCells(int, int, int, int) - 接口 中的方法jxl.write.WritableSheet
Merges the specified cells.
MINUS_45 - 类 中的静态变量jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation 45 degrees downwards
MINUS_90 - 类 中的静态变量jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation of 90 degrees downwards
MOVE_AND_SIZE_WITH_CELLS - 类 中的静态变量jxl.write.WritableImage
Image anchor properties which will move and resize an image along with the cells
MOVE_WITH_CELLS - 类 中的静态变量jxl.write.WritableImage
Image anchor properties which will move an image when cells are inserted or deleted
moveSheet(int, int) - 类 中的方法jxl.write.WritableWorkbook
Moves the specified sheet within this workbook to another index position.

N

NO_BOLD - 类 中的静态变量jxl.write.Font
已过时。 
NO_BOLD - 类 中的静态变量jxl.write.WritableFont
Indicates that this font should not be presented as bold
NO_MOVE_OR_SIZE_WITH_CELLS - 类 中的静态变量jxl.write.WritableImage
Image anchor properties which will leave an image unaffected when other cells are inserted, removed or resized
NO_UNDERLINE - 类 中的静态变量jxl.format.UnderlineStyle
 
NO_UNDERLINE - 类 中的静态变量jxl.write.Font
已过时。 
NONE - 类 中的静态变量jxl.format.Border
 
NONE - 类 中的静态变量jxl.format.BorderLineStyle
 
NONE - 类 中的静态变量jxl.format.Pattern
 
NORMAL - 类 中的静态变量jxl.format.BoldStyle
Normal style
NORMAL_SCRIPT - 类 中的静态变量jxl.format.ScriptStyle
 
NORMAL_SCRIPT - 类 中的静态变量jxl.write.Font
已过时。
 
NORMAL_STYLE - 类 中的静态变量jxl.write.WritableWorkbook
The default style for cells
NOT_BETWEEN - 类 中的静态变量jxl.write.WritableCellFeatures
 
NOT_EQUAL - 类 中的静态变量jxl.write.WritableCellFeatures
 
NOTE - 类 中的静态变量jxl.format.PaperSize
NOTE 8.5" x 11"
NUMBER - 类 中的静态变量jxl.CellType
 
Number - jxl.write中的类
A cell, created by user applications, which contains a numerical value
Number(int, int, double) - 类 的构造器jxl.write.Number
Constructs a number, which, when added to a spreadsheet, will display the specified value at the column/row position indicated.
Number(int, int, double, CellFormat) - 类 的构造器jxl.write.Number
Constructs a number, which, when added to a spreadsheet, will display the specified value at the column/row position with the specified CellFormat.
Number(NumberCell) - 类 的构造器jxl.write.Number
Constructor used internally by the application when making a writable copy of a spreadsheet that has been read in
NUMBER_FORMULA - 类 中的静态变量jxl.CellType
 
NumberCell - jxl中的接口
A cell which contains a numerical value
NumberFormat - jxl.write中的类
A custom user defined number format, which may be instantiated within user applications in order to present numerical values to the appropriate level of accuracy.
NumberFormat(String) - 类 的构造器jxl.write.NumberFormat
Constructor, taking in the Java compliant number format
NumberFormat(String, NumberFormatRecord.NonValidatingFormat) - 类 的构造器jxl.write.NumberFormat
Constructor, taking in the non-Java compliant number format.
NumberFormats - jxl.write中的类
Static class which contains the available list of built in Number formats
NumberFormats() - 类 的构造器jxl.write.NumberFormats
 
NumberFormulaCell - jxl中的接口
A mixin interface for numerical formulas, which combines the interfaces for formulas and for numbers

O

OCEAN_BLUE - 类 中的静态变量jxl.format.Colour
 
OLIVE_GREEN - 类 中的静态变量jxl.format.Colour
 
ORANGE - 类 中的静态变量jxl.format.Colour
 
Orientation - jxl.format中的类
Enumeration type which describes the orientation of data within a cell

P

PageOrder - jxl.format中的类
Enumeration type which describes the page orientation
PageOrientation - jxl.format中的类
Enumeration type which describes the page orientation
PALE_BLUE - 类 中的静态变量jxl.format.Colour
 
PALETTE_BLACK - 类 中的静态变量jxl.format.Colour
 
PaperSize - jxl.format中的类
Enumeration type which contains the available excel paper sizes and their codes
Pattern - jxl.format中的类
Enumeration class which contains the various patterns available within the standard Excel pattern palette
Pattern - jxl.write中的类
已过时。
Repackaged as jxl.format.Pattern
PATTERN1 - 类 中的静态变量jxl.format.Pattern
 
PATTERN10 - 类 中的静态变量jxl.format.Pattern
 
PATTERN11 - 类 中的静态变量jxl.format.Pattern
 
PATTERN12 - 类 中的静态变量jxl.format.Pattern
 
PATTERN13 - 类 中的静态变量jxl.format.Pattern
 
PATTERN14 - 类 中的静态变量jxl.format.Pattern
 
PATTERN2 - 类 中的静态变量jxl.format.Pattern
 
PATTERN3 - 类 中的静态变量jxl.format.Pattern
 
PATTERN4 - 类 中的静态变量jxl.format.Pattern
 
PATTERN5 - 类 中的静态变量jxl.format.Pattern
 
PATTERN6 - 类 中的静态变量jxl.format.Pattern
 
PATTERN7 - 类 中的静态变量jxl.format.Pattern
 
PATTERN8 - 类 中的静态变量jxl.format.Pattern
 
PATTERN9 - 类 中的静态变量jxl.format.Pattern
 
PERCENT_FLOAT - 类 中的静态变量jxl.write.NumberFormats
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"
PERCENT_INTEGER - 类 中的静态变量jxl.write.NumberFormats
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"
PERIWINKLE - 类 中的静态变量jxl.format.Colour
 
PINK - 类 中的静态变量jxl.format.Colour
 
PINK2 - 类 中的静态变量jxl.format.Colour
 
PLUM - 类 中的静态变量jxl.format.Colour
 
PLUM2 - 类 中的静态变量jxl.format.Colour
 
PLUS_45 - 类 中的静态变量jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation 45 degrees upwards
PLUS_90 - 类 中的静态变量jxl.format.Orientation
Cells with this specified orientation will have their data presented with a rotation of 90 degrees upwards
PORTRAIT - 类 中的静态变量jxl.format.PageOrientation
Portrait orientation

Q

QUARTO - 类 中的静态变量jxl.format.PaperSize
Quarto 215mm x 275mm

R

Range - jxl中的接口
Represents a 3-D range of cells in a workbook.
ReadWrite - jxl.demo中的类
Demo class which uses the api to read in a spreadsheet and generate a clone of that spreadsheet which contains the same data.
ReadWrite(String, String) - 类 的构造器jxl.demo.ReadWrite
Constructor
readWrite() - 类 中的方法jxl.demo.ReadWrite
Reads in the inputFile and creates a writable copy of it called outputFile
RED - 类 中的静态变量jxl.format.Colour
 
removeColumn(int) - 接口 中的方法jxl.write.WritableSheet
Removes a column from this spreadsheet.
removeComment() - 类 中的方法jxl.write.WritableCellFeatures
Removes the cell comment, if present
removeDataValidation() - 类 中的方法jxl.write.WritableCellFeatures
Removes any data validation, if present
removeHyperlink(WritableHyperlink) - 接口 中的方法jxl.write.WritableSheet
Removes the specified hyperlink.
removeHyperlink(WritableHyperlink, boolean) - 接口 中的方法jxl.write.WritableSheet
Removes the specified hyperlink.
removeImage(WritableImage) - 接口 中的方法jxl.write.WritableSheet
Removes the specified image from the sheet.
removeRangeName(String) - 类 中的方法jxl.write.WritableWorkbook
Removes the specified named range from the workbook.
removeRow(int) - 接口 中的方法jxl.write.WritableSheet
Removes a row from this spreadsheet.
removeSharedDataValidation(WritableCell) - 接口 中的方法jxl.write.WritableSheet
Remove the shared data validation from multiple cells.
removeSheet(int) - 类 中的方法jxl.write.WritableWorkbook
Removes the sheet at the specified index from this workbook
RGB - jxl.format中的类
A structure which contains the RGB values for a particular colour
RGB(int, int, int) - 类 的构造器jxl.format.RGB
Constructor
RIGHT - 类 中的静态变量jxl.format.Alignment
Data in cells with this alignment will be right aligned
RIGHT - 类 中的静态变量jxl.format.Border
 
RIGHT_THEN_DOWN - 类 中的静态变量jxl.format.PageOrder
Left to Right then Down.
ROSE - 类 中的静态变量jxl.format.Colour
 

S

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
已过时。
Use the CellView bean instead
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
已过时。
use the setSize method instead
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
已过时。
use the SheetSettings bean
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
已过时。
use the SheetSettings bean
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
已过时。
use the SheetSettings bean instead
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
已过时。
use the SheetSettings bean instead
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
已过时。
use overloaded version which takes a boolean
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
已过时。
 

T

TABLOID - 类 中的静态变量jxl.format.PaperSize
Tabloid 11" x 17"
TABLOID_EXTRA - 类 中的静态变量jxl.format.PaperSize
Tabloid Extra 11 11/16" � 18"
TAHOMA - 类 中的静态变量jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as TAHOMA fonts
TAN - 类 中的静态变量jxl.format.Colour
 
TEAL - 类 中的静态变量jxl.format.Colour
 
TEAL2 - 类 中的静态变量jxl.format.Colour
 
TEXT - 类 中的静态变量jxl.write.NumberFormats
Forces numbers to be interpreted as text
THICK - 类 中的静态变量jxl.format.BorderLineStyle
 
THIN - 类 中的静态变量jxl.format.BorderLineStyle
 
THOUSANDS_FLOAT - 类 中的静态变量jxl.write.NumberFormats
Formatting for a float that has a thousands separator.
THOUSANDS_INTEGER - 类 中的静态变量jxl.write.NumberFormats
Formatting for an integer that has a thousands separator.
TIMES - 类 中的静态变量jxl.write.Font
已过时。 
TIMES - 类 中的静态变量jxl.write.WritableFont
Objects created with this font name will be rendered within Excel as TIMES fonts
toggleBold() - 类 中的方法jxl.HeaderFooter.Contents
Turns bold printing on or off.
toggleDoubleUnderline() - 类 中的方法jxl.HeaderFooter.Contents
Turns double-underline printing on or off.
toggleItalics() - 类 中的方法jxl.HeaderFooter.Contents
Turns italics printing on or off.
toggleOutline() - 类 中的方法jxl.HeaderFooter.Contents
Turns outline printing on or off (Macintosh only).
toggleShadow() - 类 中的方法jxl.HeaderFooter.Contents
Turns shadow printing on or off (Macintosh only).
toggleStrikethrough() - 类 中的方法jxl.HeaderFooter.Contents
Turns strikethrough printing on or off.
toggleSubScript() - 类 中的方法jxl.HeaderFooter.Contents
Turns subscript printing on or off.
toggleSuperScript() - 类 中的方法jxl.HeaderFooter.Contents
Turns superscript printing on or off.
toggleUnderline() - 类 中的方法jxl.HeaderFooter.Contents
Turns underline printing on or off.
TOP - 类 中的静态变量jxl.format.Border
 
TOP - 类 中的静态变量jxl.format.VerticalAlignment
Cells with this specified vertical alignment will have their data aligned at the top
toString() - 类 中的方法jxl.CellType
Returns a string description of this cell
toString() - 类 中的方法jxl.HeaderFooter
Retrieves a Stringified version of this object
TURQOISE2 - 类 中的静态变量jxl.format.Colour
 
TURQUOISE - 类 中的静态变量jxl.format.Colour
 

U

UNDEFINED - 类 中的静态变量jxl.format.PaperSize
US Letter 8.5 x 11"
UnderlineStyle - jxl.format中的类
Enumeration class which contains the various underline styles available within the standard Excel UnderlineStyle palette
UNKNOWN - 类 中的静态变量jxl.format.Colour
 
unmergeCells(Range) - 接口 中的方法jxl.write.WritableSheet
Unmerges the specified cells.
unsetColumnGroup(int, int) - 接口 中的方法jxl.write.WritableSheet
Unsets a column grouping
unsetRowGroup(int, int) - 接口 中的方法jxl.write.WritableSheet
Unsets a row grouping
US_FANFOLD - 类 中的静态变量jxl.format.PaperSize
US Standard Fanfold 14 7/8" � 11"

V

VERTICAL - 类 中的静态变量jxl.format.Orientation
Cells with this specified orientation have their data presented vertically
VerticalAlignment - jxl.format中的类
Enumeration type which describes the vertical alignment of data within a cell
VerticalAlignment - jxl.write中的类
已过时。
Repackaged as jxl.format.VerticalAlignment
VERY_LIGHT_YELLOW - 类 中的静态变量jxl.format.Colour
 
VIOLET - 类 中的静态变量jxl.format.Colour
 
VIOLET2 - 类 中的静态变量jxl.format.Colour
 

W

WHITE - 类 中的静态变量jxl.format.Colour
 
Workbook - jxl中的类
Represents a Workbook.
WorkbookSettings - jxl中的类
This is a bean which client applications may use to set various advanced workbook properties.
WorkbookSettings() - 类 的构造器jxl.WorkbookSettings
Default constructor
WritableCell - jxl.write中的接口
The interface for all writable cells
WritableCellFeatures - jxl.write中的类
Container for any additional cell features
WritableCellFeatures() - 类 的构造器jxl.write.WritableCellFeatures
Constructor
WritableCellFeatures(CellFeatures) - 类 的构造器jxl.write.WritableCellFeatures
Copy constructor
WritableCellFormat - jxl.write中的类
A user specified cell format, which may be reused across many cells.
WritableCellFormat() - 类 的构造器jxl.write.WritableCellFormat
A default constructor, which uses the default font and format.
WritableCellFormat(WritableFont) - 类 的构造器jxl.write.WritableCellFormat
A CellFormat which specifies the font for cells with this format
WritableCellFormat(DisplayFormat) - 类 的构造器jxl.write.WritableCellFormat
A constructor which specifies a date/number format for Cells which use this format object
WritableCellFormat(WritableFont, DisplayFormat) - 类 的构造器jxl.write.WritableCellFormat
A constructor which specifies the font and date/number format for cells which wish to use this format
WritableCellFormat(CellFormat) - 类 的构造器jxl.write.WritableCellFormat
A public copy constructor which can be used for copy formats between different sheets
WritableFont - jxl.write中的类
A class which is instantiated when the user application wishes to specify the font for a particular cell
WritableFont(WritableFont.FontName) - 类 的构造器jxl.write.WritableFont
Creates a default font, vanilla font of the specified face and with default point size.
WritableFont(Font) - 类 的构造器jxl.write.WritableFont
Publicly available copy constructor
WritableFont(WritableFont.FontName, int) - 类 的构造器jxl.write.WritableFont
Constructs of font of the specified face and of size given by the specified point size
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle) - 类 的构造器jxl.write.WritableFont
Creates a font of the specified face, point size and bold style
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean) - 类 的构造器jxl.write.WritableFont
Creates a font of the specified face, point size, bold weight and italicised option.
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle) - 类 的构造器jxl.write.WritableFont
Creates a font of the specified face, point size, bold weight, italicisation and underline style
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour) - 类 的构造器jxl.write.WritableFont
Creates a font of the specified face, point size, bold style, italicisation, underline style and colour
WritableFont(WritableFont.FontName, int, WritableFont.BoldStyle, boolean, UnderlineStyle, Colour, ScriptStyle) - 类 的构造器jxl.write.WritableFont
Creates a font of the specified face, point size, bold style, italicisation, underline style, colour, and script style (superscript/subscript)
WritableFont.FontName - jxl.write中的类
Static inner class used for classifying the font names
WritableHyperlink - jxl.write中的类
A writable hyperlink.
WritableHyperlink(Hyperlink, WritableSheet) - 类 的构造器jxl.write.WritableHyperlink
Constructor used internally by the worksheet when making a copy of worksheet
WritableHyperlink(int, int, URL) - 类 的构造器jxl.write.WritableHyperlink
Constructs a URL hyperlink in a single cell
WritableHyperlink(int, int, int, int, URL) - 类 的构造器jxl.write.WritableHyperlink
Constructs a url hyperlink to a range of cells
WritableHyperlink(int, int, int, int, URL, String) - 类 的构造器jxl.write.WritableHyperlink
Constructs a url hyperlink to a range of cells
WritableHyperlink(int, int, File) - 类 的构造器jxl.write.WritableHyperlink
Constructs a file hyperlink in a single cell
WritableHyperlink(int, int, File, String) - 类 的构造器jxl.write.WritableHyperlink
Constructs a file hyperlink in a single cell
WritableHyperlink(int, int, int, int, File) - 类 的构造器jxl.write.WritableHyperlink
Constructs a File hyperlink to a range of cells
WritableHyperlink(int, int, int, int, File, String) - 类 的构造器jxl.write.WritableHyperlink
Constructs a File hyperlink to a range of cells
WritableHyperlink(int, int, String, WritableSheet, int, int) - 类 的构造器jxl.write.WritableHyperlink
Constructs a hyperlink to some cells within this workbook
WritableHyperlink(int, int, int, int, String, WritableSheet, int, int, int, int) - 类 的构造器jxl.write.WritableHyperlink
Constructs a hyperlink to some cells within this workbook
WritableImage - jxl.write中的类
Allows an image to be created, or an existing image to be manipulated Note that co-ordinates and dimensions are given in cells, so that if for example the width or height of a cell which the image spans is altered, the image will have a correspondign distortion
WritableImage(double, double, double, double, File) - 类 的构造器jxl.write.WritableImage
Constructor
WritableImage(double, double, double, double, byte[]) - 类 的构造器jxl.write.WritableImage
Constructor
WritableImage(DrawingGroupObject, DrawingGroup) - 类 的构造器jxl.write.WritableImage
Constructor, used when copying sheets
WritableSheet - jxl.write中的接口
Interface for a worksheet that may be modified.
WritableWorkbook - jxl.write中的类
A writable workbook
Write - jxl.demo中的类
Demo class which writes a spreadsheet.
Write(String) - 类 的构造器jxl.demo.Write
Constructor
write() - 类 中的方法jxl.demo.Write
Uses the JExcelAPI to create a spreadsheet
write() - 类 中的方法jxl.write.WritableWorkbook
Writes out the data held in this workbook in Excel format
WriteException - jxl.write中的异常错误
Exception thrown when using the API to generate an Excel file

X

XML - jxl.demo中的类
Simple demo class which uses the api to present the contents of an excel 97 spreadsheet as an XML document, using a workbook and output stream of your choice
XML(Workbook, OutputStream, String, boolean) - 类 的构造器jxl.demo.XML
Constructor

Y

YELLOW - 类 中的静态变量jxl.format.Colour
 
YELLOW2 - 类 中的静态变量jxl.format.Colour
 
A B C D E F G H I J L M N O P Q R S T U V W X Y 
跳过导航链接