Library:JExcelAPI
Version:2.6
Compatibility:JDK 1.4
Classes in library JExcelAPI.
NamePackageDescription
Alignmentjxl.writeEnumeration class which contains the various alignments for data within a cell
Alignmentjxl.formatEnumeration class which contains the various alignments for data within a cell
AssertcommonSimple assertion mechanism for use during development
BaseCellFeaturesjxl.biffContainer for any additional cell features
BaseCellFeatures.ValidationConditionjxl.biffNo description provided.
BaseCompoundFilejxl.biffContains the common data for a compound file
BaseCompoundFile.PropertyStoragejxl.biffInner class to represent the property storage sets.
BaseSharedFormulaRecordjxl.read.biffA base class for shared formula records
BiffRecordReaderjxl.read.biffServes up Record objects from a biff file.
Blankjxl.writeA blank cell.
BlankCelljxl.read.biffA blank cell.
BlankRecordjxl.write.biffA blank record, which is used to contain formatting information
BOFRecordjxl.read.biffA Beginning Of File record, found at the commencement of all substreams within a biff8 file
BoldStylejxl.writeEnumeration class containing the various bold styles for data
BoldStylejxl.formatEnumeration class containing the various bold styles for data
Booleanjxl.writeA cell, created by user applications, which contains a boolean (or in some cases an error) value
BooleanRecordjxl.write.biffA boolean cell's last calculated value
Borderjxl.writeNo description provided.
Borderjxl.formatThe location of a border
BorderLineStylejxl.writeNo description provided.
BorderLineStylejxl.formatThe border line style
Buttonjxl.biff.drawingContains the various biff records used to copy a Button (from the Form toolbox) between workbook
ButtonPropertySetRecordjxl.read.biffData associated with a button property set
ByteArrayjxl.biffA growable array of bytes
CellFeaturesjxlContainer for any additional cell features
CellReferenceHelperjxlExposes some cell reference helper methods to the public interface.
CellReferenceHelperjxl.biffA helper to transform between excel cell references and sheet:column:row notation Because this function will be called when generating a string representation of a formula, the cell reference will merely be appened to the string buffer instead of returning a full blooded string, for performance reasons
CellTypejxlAn enumeration type listing the available content types for a cell
CellValuejxl.write.biffAbstract class which stores the common data used for cells, such as row, column and formatting information.
CellValuejxl.read.biffAbstract class for all records which actually contain cell values
CellViewjxlThis is a bean which client applications may use to get/set various properties for a row or column on a spreadsheet
CellXFRecordjxl.write.biffA cell XF Record
Chartjxl.biff.drawingContains the various biff records used to insert a chart into a worksheet
Colourjxl.writeEnumeration class which contains the various colours available within the standard Excel colour palette
Colourjxl.formatEnumeration class which contains the various colours available within the standard Excel colour palette
ColumnInfoRecordjxl.read.biffContains the display info data which affects the entire columns
ComboBoxjxl.biff.drawingContains the various biff records used to copy a ComboBox (from the Form toolbox) between workbook
Commentjxl.biff.drawingContains the various biff records used to insert a cell note into a worksheet
CompoundFilejxl.read.biffReads in and defrags an OLE compound compound file (Made public only for the PropertySets demo)
ContinueRecordjxl.biffA continue record - only used explicitly in special circumstances, as the general continuation record is handled directly by the records
CountryCodejxl.biffEnumeration type for the excel country codes
CountryRecordjxl.read.biffContains the cell dimensions of this worksheet
CSVjxl.demoSimple 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
DataValidationjxl.biffClass which encapsulates a data validation (typically in the form of a dropdown list box)
DataValidityListRecordjxl.biffRecord containing the list of data validation settings for a given sheet
DataValiditySettingsRecordjxl.biffData validity settings
DateFormatjxl.writeA custom user defined number format which may be instantiated within user applications in order to present date and time values in the appropriate format.
DateFormatRecordjxl.write.biffA class which contains a date format
DateFormatsjxl.writeStatic class which contains Excels predefined Date formats
DateRecordjxl.write.biffA date stored in the database
DateRecord.GMTDatejxl.write.biffClass definition for a dummy variable
DateTimejxl.writeA 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.
Demojxl.demoThe 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
DoubleHelperjxl.biffClass to help handle doubles
Drawingjxl.biff.drawingContains the various biff records used to insert a drawing into a worksheet
Drawing2jxl.biff.drawingContains the various biff records used to insert a drawing into a worksheet.
DrawingDatajxl.biff.drawingClass used to concatenate all the data for the various drawing objects into one continuous stream
DrawingGroupjxl.biff.drawingThis class contains the Excel picture data in Escher format for the entire workbook
DValParserjxl.biffClass which parses the binary data associated with Data Validity (DVal) setting
DVParserjxl.biffClass which parses the binary data associated with Data Validity (DV) setting
DVParser.Conditionjxl.biffNo description provided.
DVParser.DVTypejxl.biffNo description provided.
DVParser.ErrorStylejxl.biffNo description provided.
EmptyCelljxl.biffAn empty cell.
EncodedURLHelperjxl.biffHelper to get the Microsoft encoded URL from the given string
Escherjxl.demoDisplays the escher data
EscherDisplayjxl.biff.drawingClass used to display a complete hierarchically organized Escher stream The whole thing is dumped to System.out This class is only used as a debugging tool
EscherDrawingGroupjxl.demoDisplays the escher data
ExternalNameRecordjxl.read.biffA row record
ExternalSheetRecordjxl.read.biffAn Externsheet record, containing the details of externally references workbooks
Featuresjxl.demoGoes through each cell in the workbook, and if the cell has any features associated with, it prints out the cell contents and the features
Filejxl.write.biffA file of excel data to be written out.
Filejxl.read.biffFile containing the data from the binary stream
Fontjxl.writeA class which is instantiated when the user application wishes to specify the font for a particular cell
FontRecordjxl.biffA record containing the necessary data for the font information
Fontsjxl.biffA container for the list of fonts used in this workbook
FooterRecordjxl.read.biffA workbook page footer record
FormatRecordjxl.biffA non-built in format record
FormattingRecordsjxl.biffThe list of XF records and formatting records for the workbook
Formulajxl.writeA cell, created by user applications, which contains a numerical value
FormulaErrorCodejxl.biff.formulaEnumeration for formula error codes
FormulaParserjxl.biff.formulaParses the formula passed in (either as parsed strings or as a string) into a tree of operators and operands
FormulaRecordjxl.write.biffA formula record.
Formulasjxl.demoGoes 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
FunctionNamesjxl.biff.formulaA class which contains the function names for the current workbook.
HeaderFooterjxlClass which represents an Excel header or footer.
HeaderFooterjxl.biffClass which represents an Excel header or footer.
HeaderFooter.ContentsjxlThe contents - a simple wrapper around a string buffer
HeaderFooter.Contentsjxl.biffThe contents - a simple wrapper around a string buffer
HeaderRecordjxl.read.biffA workbook page header record
HyperlinkRecordjxl.write.biffA number record.
HyperlinkRecordjxl.read.biffA number record.
IndexMappingjxl.biffThis class is a wrapper for a list of mappings between indices.
IntegerHelperjxl.biffConverts excel byte representations into integers
Labeljxl.writeA cell containing text which may be created by user applications
LabelRecordjxl.write.biffA label record, used for writing out string
LoggercommonAbstract wrapper class for the logging interface of choice.
LoggerNamecommon.logStatic structure containing the class name of the logger.
MergedCellsRecordjxl.write.biffA number record.
MergedCellsRecordjxl.read.biffA merged cells record for a given sheet
MsoDrawingGroupRecordjxl.biff.drawingA record which merely holds the MSODRAWINGGROUP data.
MsoDrawingRecordjxl.biff.drawingA record which merely holds the MSODRAWING data.
NameRecordjxl.read.biffHolds an excel name record, and the details of the cells/ranges it refers to
NameRecord.NameRangejxl.read.biffA nested class to hold range information
NoteRecordjxl.biff.drawingA Note (TXO) record which contains the information for comments
Numberjxl.writeA cell, created by user applications, which contains a numerical value
NumberFormatjxl.writeA custom user defined number format, which may be instantiated within user applications in order to present numerical values to the appropriate level of accuracy.
NumberFormatRecordjxl.write.biffA class which contains a number format
NumberFormatRecord.NonValidatingFormatjxl.write.biffNo description provided.
NumberFormatsjxl.writeStatic class which contains the available list of built in Number formats
NumberRecordjxl.write.biffThe record which contains numerical values.
ObjRecordjxl.biff.drawingA record which merely holds the OBJ data.
Orientationjxl.formatEnumeration type which describes the orientation of data within a cell
Originjxl.biff.drawingEnumeration type for the origin of a drawing object
PageOrientationjxl.formatEnumeration type which describes the page orientation
PaletteRecordjxl.biffA record representing the RGB colour palette
PaletteRecordjxl.read.biffA password record
PaperSizejxl.formatEnumeration type which contains the available excel paper sizes and their codes
Patternjxl.writeEnumeration class which contains the various patterns available within the standard Excel pattern palette
Patternjxl.formatEnumeration class which contains the various patterns available within the standard Excel pattern palette
PLSRecordjxl.read.biffThe environment specific print record
RangeImpljxl.biffImplementation class for the Range interface.
ReadWritejxl.demoDemo class which uses the api to read in a spreadsheet and generate a clone of that spreadsheet which contains the same data.
Recordjxl.read.biffA container for the raw record data within a biff file
RecordDatajxl.biffThe record data within a record
RGBjxl.formatA structure which contains the RGB values for a particular colour
RowRecordjxl.read.biffA row record
ScriptStylejxl.formatEnumeration class which contains the various script styles available within the standard Excel ScriptStyle palette
SetupRecordjxl.read.biffContains the page set up for a sheet
SharedDateFormulaRecordjxl.read.biffA number formula record, manufactured out of the Shared Formula "optimization"
SharedErrorFormulaRecordjxl.read.biffA number formula record, manufactured out of the Shared Formula "optimization"
SharedNumberFormulaRecordjxl.read.biffA number formula record, manufactured out of the Shared Formula "optimization"
SharedStringFormulaRecordjxl.read.biffA string formula record, manufactured out of the Shared Formula "optimization"
SheetDrawingWriterjxl.biff.drawingHandles the writing out of the different charts and images on a sheet.
SheetImpljxl.read.biffRepresents a sheet within a workbook.
SheetRangeImpljxl.biffImplementation class for the Range interface.
SheetSettingsjxlThis 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.
SimpleLoggercommon.logThe default logger.
SortRecordjxl.read.biffA storage area for the last Sort dialog box area
StringHelperjxl.biffHelper function to convert Java string objects to and from the byte representations
StyleXFRecordjxl.write.biffA style XF Record
SupbookRecordjxl.read.biffA record containing the references to the various sheets (internal and external) referenced by formulas in this workbook
TextObjectRecordjxl.biff.drawingA TextObject (TXO) record which contains the information for comments
Typejxl.biffAn enumeration class which contains the biff types
UnderlineStylejxl.formatEnumeration class which contains the various underline styles available within the standard Excel UnderlineStyle palette
VerticalAlignmentjxl.writeEnumeration type which describes the vertical alignment of data within a cell
VerticalAlignmentjxl.formatEnumeration type which describes the vertical alignment of data within a cell
WorkbookjxlRepresents a Workbook.
WorkbookParserjxl.read.biffParses the biff file passed in, and builds up an internal representation of the spreadsheet
WorkbookSettingsjxlThis is a bean which client applications may use to set various advanced workbook properties.
WorkspaceInformationRecordjxl.biffA record detailing whether the sheet is protected
WritableCellFeaturesjxl.writeContainer for any additional cell features
WritableCellFormatjxl.writeA user specified cell format, which may be reused across many cells.
WritableFontjxl.writeA class which is instantiated when the user application wishes to specify the font for a particular cell
WritableFont.FontNamejxl.writeStatic inner class used for classifying the font names
WritableFontRecordjxl.write.biffA writable Font record.
WritableFontsjxl.write.biffA container for the list of fonts used in this workbook The writable subclass instantiates the predetermined list of fonts available to users of the writable API
WritableFormattingRecordsjxl.write.biffHandles the Format and XF record indexing.
WritableHyperlinkjxl.writeA writable hyperlink.
WritableImagejxl.writeAllows 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
WritableRecordDatajxl.biffExtension of the standard RecordData which is used to support those records which, once read, may also be written
WritableWorkbookjxl.writeA writable workbook
WritableWorkbookImpljxl.write.biffA writable workbook
Writejxl.demoDemo class which writes a spreadsheet.
XFRecordjxl.biffHolds an extended formatting record
XMLjxl.demoSimple 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
Search