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

Quick Search    Search Deep

jxl.write.biff.* (110)

jxl.write: Javadoc index of package jxl.write.


Package Samples:

jxl.write.biff

Classes:

DateTime: 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. If this is not desired (eg. if the date entered represents an interval eg. 9.83s for the 100m world record, then use the overloaded constructor which indicate that the date passed in was created under the GMT timezone. It is important that when the date was created, an instruction like Calendar.setTimeZone(TimeZone.getTimeZone("GMT")) was made prior to that
WritableCellFormat: A user specified cell format, which may be reused across many cells. The constructors takes parameters, such as font details and the numerical date formats, which specify to Excel how cells with this format should be displayed. Once a CellFormat has been added to a Cell which has been added to a sheet, then the CellFormat becomes immutable (to prevent unforeseen effects on other cells which share the same format). Attempts to call the various set... functions on a WritableCellFormat after this time will result in a runtime exception.
NumberFormat: 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. The string format used to create a number format adheres to the standard java specification, and JExcelAPI makes the necessary modifications so that it is rendered in Excel as the nearest possible equivalent. Once created, this may be used within a CellFormat object, which in turn is a parameter passed to the constructor of the Number cell
DateFormat: 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. The string format used to create a DateFormat adheres to the standard java specification, and JExcelApi makes the necessary modifications so that it is rendered as its nearest equivalent in Excel. Once created, this may be used within a CellFormat object, which in turn is a parameter passed to the constructor of the DateTime cell
CompoundFile: Writes out a compound file Header block is -1 Excel data is e..n (where e is the head extension blocks, normally 0 and n is at least 8) Summary information (8 blocks) Document summary (8 blocks) BBD is block p..q (where p=e+n+16 and q-p+1 is the number of BBD blocks) Property storage block is q+b...r (normally 1 block) (where b is the number of BBD blocks)
WritableImage: 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
CellValue: Abstract class which stores the common data used for cells, such as row, column and formatting information. Any record which directly represents the contents of a cell, such as labels and numbers, are derived from this class data store
SheetWriter: Contains the functionality necessary for writing out a sheet. Originally this was incorporated in WritableSheetImpl, but was moved out into a dedicated class in order to reduce the over bloated nature of that class
File: A file of excel data to be written out. All the excel data is held in memory, and when the close method is called a CompoundFile object is used to write the Biff oriented excel data in the CompoundFile format
ExtendedSSTRecord: Indicates an extension to the Shared String Table. Currently this contains blank records Thanks to Guenther for contributing a proper implementation of the EXTSST record, replacing my previous dummy version
Styles: A structure containing the styles used by this workbook. This is used to enforce thread safety by tying the default styles to a workbook instance rather than by initializing them statically
ReadFormulaRecord: A formula record. This is invoked when copying a formula from a read only spreadsheet This method implements the FormulaData interface to allow the copying of writable sheets
WritableFonts: A 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
WritableFormattingRecords: Handles the Format and XF record indexing. The writable subclass instantiates the predetermined list of XF records and formats present in every Excel Workbook
Blank: A blank cell. Despite not having any contents, it may contain formatting information. Such cells are typically used when creating templates
MergedCells: Contains all the merged cells, and the necessary logic for checking for intersections and for handling very large amounts of merging
WritableFontRecord: A writable Font record. This class intercepts any set accessor calls and throws and exception if the Font is already initialized
WritableSheet: Interface for a worksheet that may be modified. The most important modification for a sheet is to have cells added to it
WritableSheetImpl: A writable sheet. This class contains implementation of all the writable sheet methods which may be invoke by the API
SupbookRecord: Stores the supporting workbook information. For files written by JExcelApi this will only reference internal sheets
DSFRecord: Stores a flag which indicates whether the file is a double stream file. For files written by JExcelAPI, this FALSE
PasswordRecord: A password record. Thanks to Michael Matthews for sending me the code to actually store the password for the sheet
RefreshAllRecord: Record which indicates whether or not data ranges and pivot tables should be refreshed when the workbook is loaded
DBCellRecord: Indexes the first row record of the block and each individual cell. This is invoked by the sheets write process
UsesElfsRecord: Stores the flag which indicates whether the version of excel can understand natural language input for formulae

Home | Contact Us | Privacy Policy | Terms of Service