|
|||||||||
| Home >> All >> org >> apache >> poi >> hssf >> [ model overview ] | PREV NEXT | ||||||||
A
- Abort(String) - Method in class org.apache.poi.hssf.model.FormulaParser
- Report Error and Halt
- AbstractShape - class org.apache.poi.hssf.model.AbstractShape.
- An abstract shape is the lowlevel model for a shape.
- AbstractShape() - Constructor for class org.apache.poi.hssf.model.AbstractShape
- Add() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate an Add
- Arguments() - Method in class org.apache.poi.hssf.model.FormulaParser
- get arguments to a function
- add(int, Record) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- addArgumentPointer() - Method in class org.apache.poi.hssf.model.FormulaParser
- Adds a pointer to the last token to the latest function argument list.
- addDBCellRecords() - Method in class org.apache.poi.hssf.model.Sheet
- Not currently used method to calculate and add dbcell records
- addDbCellToIndex(int, IndexRecord) - Method in class org.apache.poi.hssf.model.Sheet
- not currently used
- addMergedRegion(int, short, int, short) - Method in class org.apache.poi.hssf.model.Sheet
- addName(NameRecord) - Method in class org.apache.poi.hssf.model.Workbook
- creates new name
- addRow(RowRecord) - Method in class org.apache.poi.hssf.model.Sheet
- Adds a row record to the sheet
- addSSTString(String, boolean) - Method in class org.apache.poi.hssf.model.Workbook
- Adds a string to the SST table and returns its index (if its a duplicate just returns its index and update the counts)
- addSSTString(String) - Method in class org.apache.poi.hssf.model.Workbook
- Adds a string to the SST table and returns its index (if its a duplicate just returns its index and update the counts) ASSUMES compressed unicode (meaning 8bit)
- addSheetIndexToExternSheet(short) - Method in class org.apache.poi.hssf.model.Workbook
- addStandardOptions(HSSFShape, EscherOptRecord) - Method in class org.apache.poi.hssf.model.AbstractShape
- Add standard properties to the opt record.
- addValueRecord(int, CellValueRecordInterface) - Method in class org.apache.poi.hssf.model.Sheet
- Adds a value record to the sheet's contained binary records (i.e.
- aggregateDrawingRecords(DrawingManager) - Method in class org.apache.poi.hssf.model.Sheet
- allocateShapeId(short) - Method in class org.apache.poi.hssf.model.DrawingManager
- Allocates new shape id for the new drawing group id.
B
- BottomMargin - Static variable in class org.apache.poi.hssf.model.Sheet
- backuppos - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
- book - Variable in class org.apache.poi.hssf.model.FormulaParser
- boundsheets - Variable in class org.apache.poi.hssf.model.Workbook
- holds the "boundsheet" records (aka bundlesheet) so that they can have their reference to their "BOF" marker
- bspos - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
C
- CODEPAGE - Static variable in class org.apache.poi.hssf.model.Workbook
- constant used to set the "codepage" wherever "codepage" is set in records (which is duplciated in more than one record)
- CR - Static variable in class org.apache.poi.hssf.model.FormulaParser
- Concat() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate a Concatination
- ConvertAnchor - class org.apache.poi.hssf.model.ConvertAnchor.
- $Id: ConvertAnchor.java,v 1.1.2.2 2004/02/22 11:54:46 glens Exp $
- ConvertAnchor() - Constructor for class org.apache.poi.hssf.model.ConvertAnchor
- cells - Variable in class org.apache.poi.hssf.model.Sheet
- checkCells() - Method in class org.apache.poi.hssf.model.Sheet
- checkDimsLoc(Record, int) - Method in class org.apache.poi.hssf.model.Sheet
- in the event the record is a dimensions record, resets both the loc index and dimsloc index
- checkExternSheet(int) - Method in class org.apache.poi.hssf.model.Workbook
- returns the extern sheet number for specific sheet number , if this sheet doesn't exist in extern sheet , add it
- checkRows() - Method in class org.apache.poi.hssf.model.Sheet
- checkSheets(int) - Method in class org.apache.poi.hssf.model.Workbook
- if we're trying to address one more sheet than we have, go ahead and add it! if we're trying to address >1 more than we have throw an exception!
- children - Variable in class org.apache.poi.hssf.model.Node
- cloneSheet() - Method in class org.apache.poi.hssf.model.Sheet
- Clones the low level records of this sheet and returns the new sheet instance.
- colBreaks - Variable in class org.apache.poi.hssf.model.Sheet
- columns - Variable in class org.apache.poi.hssf.model.Sheet
- containsLabels - Variable in class org.apache.poi.hssf.model.Sheet
- convertLabelRecords(Workbook) - Method in class org.apache.poi.hssf.model.Sheet
- This is basically a kludge to deal with the now obsolete Label records.
- createAnchor(HSSFAnchor) - Method in class org.apache.poi.hssf.model.AbstractShape
- Creates an escher anchor record from a HSSFAnchor.
- createAnchor(HSSFAnchor) - Static method in class org.apache.poi.hssf.model.ConvertAnchor
- createBOF() - Method in class org.apache.poi.hssf.model.Sheet
- creates the BOF record
- createBOF() - Method in class org.apache.poi.hssf.model.Workbook
- creates the BOF record
- createBackup() - Method in class org.apache.poi.hssf.model.Workbook
- creates the Backup record with backup set to 0.
- createBlank(int, short) - Method in class org.apache.poi.hssf.model.Sheet
- create a BLANK record (does not add it to the records contained in this sheet)
- createBookBool() - Method in class org.apache.poi.hssf.model.Workbook
- creates the BookBool record with saveLinkValues set to 0.
- createBoundSheet(int) - Method in class org.apache.poi.hssf.model.Workbook
- create a "bound sheet" or "bundlesheet" (depending who you ask) record Always sets the sheet's bof to 0.
- createBuiltInName(byte, int) - Method in class org.apache.poi.hssf.model.Workbook
- Generates a NameRecord to represent a built-in region
- createCalcCount() - Method in class org.apache.poi.hssf.model.Sheet
- creates the CalcCount record and sets it to 0x64 (default number of iterations)
- createCalcMode() - Method in class org.apache.poi.hssf.model.Sheet
- creates the CalcMode record and sets it to 1 (automatic formula caculation)
- createCellXF() - Method in class org.apache.poi.hssf.model.Workbook
- creates a new Cell-type Extneded Format Record and adds it to the end of ExtendedFormatRecords collection
- createCodepage() - Method in class org.apache.poi.hssf.model.Workbook
- creates the Codepage record containing the constant stored in CODEPAGE
- createColInfo() - Method in class org.apache.poi.hssf.model.Sheet
- creates the ColumnInfo Record and sets it to a default column/width
- createCountry() - Method in class org.apache.poi.hssf.model.Workbook
- Creates the Country record with the default country set to 1 and current country set to 7 in case of russian locale ("ru_RU") and 1 otherwise
- createDBCell(int, IntList, IndexRecord) - Method in class org.apache.poi.hssf.model.Sheet
- not currently used
- createDSF() - Method in class org.apache.poi.hssf.model.Workbook
- creates the DSF record containing a 0 since HSSF can't even create Dual Stream Files
- createDateWindow1904() - Method in class org.apache.poi.hssf.model.Workbook
- creates the DateWindow1904 record with windowing set to 0.
- createDefaultColWidth() - Method in class org.apache.poi.hssf.model.Sheet
- creates the DefaultColWidth Record and sets it to 8
- createDefaultRowHeight() - Method in class org.apache.poi.hssf.model.Sheet
- creates the DefaultRowHeight Record and sets its options to 0 and rowheight to 0xff
- createDelta() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Delta record and sets it to 0.0010 (default accuracy)
- createDgRecord() - Method in class org.apache.poi.hssf.model.DrawingManager
- createDimensions() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Dimensions Record and sets it to bogus values (you should set this yourself or let the high level API do it for you)
- createDrawingGroup() - Method in class org.apache.poi.hssf.model.Workbook
- Creates a drawing group record.
- createEOF() - Method in class org.apache.poi.hssf.model.Sheet
- creates the EOF record
- createEOF() - Method in class org.apache.poi.hssf.model.Workbook
- creates the EOF record
- createExtendedFormat(int) - Method in class org.apache.poi.hssf.model.Workbook
- Creates an ExtendedFormatRecord object
- createExtendedFormat() - Method in class org.apache.poi.hssf.model.Workbook
- creates an default cell type ExtendedFormatRecord object.
- createExtendedSST() - Method in class org.apache.poi.hssf.model.Workbook
- Creates the ExtendedSST record with numstrings per bucket set to 0x8.
- createExternSheet() - Method in class org.apache.poi.hssf.model.Workbook
- creates a new extern sheet record
- createFnGroupCount() - Method in class org.apache.poi.hssf.model.Workbook
- creates the FnGroupCount record containing the Magic number constant of 14.
- createFont() - Method in class org.apache.poi.hssf.model.Workbook
- creates a Font record with the following magic values:
- createFooter() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Footer Record and sets it to nothing/0 length
- createFormat(int) - Method in class org.apache.poi.hssf.model.Workbook
- Creates a FormatRecord object
- createFormat(String) - Method in class org.apache.poi.hssf.model.Workbook
- Creates a FormatRecord, inserts it, and returns the index code.
- createFormula(int, short, String) - Method in class org.apache.poi.hssf.model.Sheet
- Attempts to parse the formula into PTGs and create a formula record DOES NOT WORK YET
- createFreezePane(int, int, int, int) - Method in class org.apache.poi.hssf.model.Sheet
- Creates a split (freezepane).
- createGridset() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Gridset record and sets it to true (user has mucked with the gridlines)
- createGuts() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Guts record and sets leftrow/topcol guttter and rowlevelmax/collevelmax to 0
- createHCenter() - Method in class org.apache.poi.hssf.model.Sheet
- creates the HCenter Record and sets it to false (don't horizontally center)
- createHeader() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Header Record and sets it to nothing/0 length
- createHideObj() - Method in class org.apache.poi.hssf.model.Workbook
- creates the HideObj record with hide object set to 0.
- createIndex() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Index record - not currently used
- createInterfaceEnd() - Method in class org.apache.poi.hssf.model.Workbook
- creates the InterfaceEnd record
- createInterfaceHdr() - Method in class org.apache.poi.hssf.model.Workbook
- creates the InterfaceHdr record
- createIteration() - Method in class org.apache.poi.hssf.model.Sheet
- creates the Iteration record and sets it to false (don't iteratively calculate formulas)
- createLabelSST(int, short, int) - Method in class org.apache.poi.hssf.model.Sheet
- Create a LABELSST Record (does not add it to the records contained in this sheet)
- createMMS() - Method in class org.apache.poi.hssf.model.Workbook
- creates an MMS record
- createMergedCells() - Method in class org.apache.poi.hssf.model.Sheet
- createName() - Method in class org.apache.poi.hssf.model.Workbook
- creates new name
- createNewFont() - Method in class org.apache.poi.hssf.model.Workbook
- creates a new font record and adds it to the "font table".
- createNumber(int, short, double) - Method in class org.apache.poi.hssf.model.Sheet
- Create a NUMBER Record (does not add it to the records contained in this sheet)
- createObjRecord(HSSFShape, int) - Method in class org.apache.poi.hssf.model.LineShape
- Creates the low level OBJ record for this shape.
- createObjRecord(HSSFShape, int) - Method in class org.apache.poi.hssf.model.PolygonShape
- Creates the low level OBJ record for this shape.
- createObjRecord(HSSFShape, int) - Method in class org.apache.poi.hssf.model.SimpleFilledShape
- Creates the low level OBJ record for this shape.
- createObjRecord(HSSFTextbox, int) - Method in class org.apache.poi.hssf.model.TextboxShape
- Creates the low level OBJ record for this shape.
- createPalette() - Method in class org.apache.poi.hssf.model.Workbook
- Creates a palette record initialized to the default palette
- createPassword() - Method in class org.apache.poi.hssf.model.Workbook
- creates the Password record with password set to 0.
- createPasswordRev4() - Method in class org.apache.poi.hssf.model.Workbook
- creates the PasswordRev4 record with password set to 0.
- createPrecision() - Method in class org.apache.poi.hssf.model.Workbook
- creates the Precision record with precision set to true.
- createPrintGridlines() - Method in class org.apache.poi.hssf.model.Sheet
- creates the PrintGridlines record and sets it to false (that makes for ugly sheets).
- createPrintHeaders() - Method in class org.apache.poi.hssf.model.Sheet
- creates the PrintHeaders record and sets it to false (we don't create headers yet so why print them)
- createPrintSetup() - Method in class org.apache.poi.hssf.model.Sheet
- creates the PrintSetup Record and sets it to defaults and marks it invalid
- createProtect() - Method in class org.apache.poi.hssf.model.Sheet
- creates a Protect record with protect set to false.
- createProtect() - Method in class org.apache.poi.hssf.model.Workbook
- creates the Protect record with protect set to false.
- createProtectionRev4() - Method in class org.apache.poi.hssf.model.Workbook
- creates the ProtectionRev4 record with protect set to false.
- createRefMode() - Method in class org.apache.poi.hssf.model.Sheet
- creates the RefMode record and sets it to A1 Mode (default reference mode)
- createRefreshAll() - Method in class org.apache.poi.hssf.model.Workbook
- creates the RefreshAll record with refreshAll set to true.
- createRow(int) - Method in class org.apache.poi.hssf.model.Sheet
- Create a row record.
- createSST() - Method in class org.apache.poi.hssf.model.Workbook
- Creates the SST record with no strings and the unique/num string set to 0
- createSaveRecalc() - Method in class org.apache.poi.hssf.model.Sheet
- creates the SaveRecalc record and sets it to true (recalculate before saving)
- createSelection() - Method in class org.apache.poi.hssf.model.Sheet
- Creates the Selection record and sets it to nothing selected
- createShape(HSSFShape, int) - Static method in class org.apache.poi.hssf.model.AbstractShape
- Create a new shape object used to create the escher records.
- createSheet(List, int, int) - Static method in class org.apache.poi.hssf.model.Sheet
- read support (offset used as starting point for search) for low level API.
- createSheet(List, int) - Static method in class org.apache.poi.hssf.model.Sheet
- read support (offset = 0) Same as createSheet(Record[] recs, int, int) only the record offset is assumed to be 0.
- createSheet() - Static method in class org.apache.poi.hssf.model.Sheet
- Creates a sheet with all the usual records minus values and the "index" record (not required).
- createSpContainer(HSSFSimpleShape, int) - Method in class org.apache.poi.hssf.model.LineShape
- Creates the lowerlevel escher records for this shape.
- createSpContainer(HSSFPolygon, int) - Method in class org.apache.poi.hssf.model.PolygonShape
- Generates the shape records for this shape.
- createSpContainer(HSSFSimpleShape, int) - Method in class org.apache.poi.hssf.model.SimpleFilledShape
- Generates the shape records for this shape.
- createSpContainer(HSSFTextbox, int) - Method in class org.apache.poi.hssf.model.TextboxShape
- Generates the escher shape records for this shape.
- createSplitPane(int, int, int, int, int) - Method in class org.apache.poi.hssf.model.Sheet
- Creates a split pane.
- createStyle(int) - Method in class org.apache.poi.hssf.model.Workbook
- Creates a StyleRecord object
- createTabId() - Method in class org.apache.poi.hssf.model.Workbook
- creates the TabId record containing an array of 0,1,2.
- createTextObjectRecord(HSSFTextbox, int) - Method in class org.apache.poi.hssf.model.TextboxShape
- Textboxes also have an extra TXO record associated with them that most other shapes dont have.
- createTree() - Method in class org.apache.poi.hssf.model.FormulaParser
- Create a tree representation of the RPN token array used to run the class(RVA) change algo
- createUseSelFS() - Method in class org.apache.poi.hssf.model.Workbook
- Creates the UseSelFS object with the use natural language flag set to 0 (false)
- createVCenter() - Method in class org.apache.poi.hssf.model.Sheet
- creates the VCenter Record and sets it to false (don't horizontally center)
- createWSBool() - Method in class org.apache.poi.hssf.model.Sheet
- creates the WSBoolRecord and sets its values to defaults
- createWindowOne() - Method in class org.apache.poi.hssf.model.Workbook
- creates the WindowOne record with the following magic values:
- createWindowProtect() - Method in class org.apache.poi.hssf.model.Workbook
- creates the WindowProtect record with protect set to false.
- createWindowTwo() - Method in class org.apache.poi.hssf.model.Sheet
- creates the WindowTwo Record and sets it to:
- createWorkbook(List) - Static method in class org.apache.poi.hssf.model.Workbook
- read support for low level API.
- createWorkbook() - Static method in class org.apache.poi.hssf.model.Workbook
- Creates an empty workbook object with three blank sheets and all the empty fields.
- createWriteAccess() - Method in class org.apache.poi.hssf.model.Workbook
- creates the WriteAccess record containing the logged in user's name
D
- DEBUG - Static variable in class org.apache.poi.hssf.model.Workbook
- Divide() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate a Divide
- DrawingManager - class org.apache.poi.hssf.model.DrawingManager.
- Provides utilities to manage drawing groups.
- DrawingManager(EscherDggRecord) - Constructor for class org.apache.poi.hssf.model.DrawingManager
- defaultcolwidth - Variable in class org.apache.poi.hssf.model.Sheet
- defaultrowheight - Variable in class org.apache.poi.hssf.model.Sheet
- dgMap - Variable in class org.apache.poi.hssf.model.DrawingManager
- dgg - Variable in class org.apache.poi.hssf.model.DrawingManager
- dims - Variable in class org.apache.poi.hssf.model.Sheet
- dimsloc - Variable in class org.apache.poi.hssf.model.Sheet
- drawingGroupExists(short) - Method in class org.apache.poi.hssf.model.DrawingManager
- drawingManager - Variable in class org.apache.poi.hssf.model.Workbook
E
- Emit(String) - Method in class org.apache.poi.hssf.model.FormulaParser
- Output a String with Tab
- EmitLn(String) - Method in class org.apache.poi.hssf.model.FormulaParser
- Output a String with Tab and CRLF
- Equal() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate a test for Equality
- Error(String) - Method in class org.apache.poi.hssf.model.FormulaParser
- Report an Error
- Expected(String) - Method in class org.apache.poi.hssf.model.FormulaParser
- Report What Was Expected
- Expression() - Method in class org.apache.poi.hssf.model.FormulaParser
- Parse and Translate an Expression
- eofLoc - Variable in class org.apache.poi.hssf.model.Sheet
- escherTextbox - Variable in class org.apache.poi.hssf.model.TextboxShape
- externSheet - Variable in class org.apache.poi.hssf.model.Workbook
- Holds the Extern Sheet with references to bound sheets
- externsheetPos - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
F
- FORMULA_TYPE_ARRAY - Static variable in class org.apache.poi.hssf.model.FormulaParser
- FORMULA_TYPE_CELL - Static variable in class org.apache.poi.hssf.model.FormulaParser
- FORMULA_TYPE_CONDFOMRAT - Static variable in class org.apache.poi.hssf.model.FormulaParser
- FORMULA_TYPE_NAMEDRANGE - Static variable in class org.apache.poi.hssf.model.FormulaParser
- FORMULA_TYPE_SHARED - Static variable in class org.apache.poi.hssf.model.FormulaParser
- Factor() - Method in class org.apache.poi.hssf.model.FormulaParser
- Parse and Translate a Math Factor
- FormulaParser - class org.apache.poi.hssf.model.FormulaParser.
- This class parses a formula string into a List of tokens in RPN order.
- FormulaParser(String, Workbook) - Constructor for class org.apache.poi.hssf.model.FormulaParser
- create the parser with the string that is to be parsed later call the parse() method to return ptg list in rpn order then call the getRPNPtg() to retrive the parse results This class is recommended only for single threaded use
- findFirstRecordBySid(short) - Method in class org.apache.poi.hssf.model.Sheet
- Returns the first occurance of a record matching a particular sid.
- findFirstRecordBySid(short) - Method in class org.apache.poi.hssf.model.Workbook
- Returns the first occurance of a record matching a particular sid.
- findFirstRecordLocBySid(short) - Method in class org.apache.poi.hssf.model.Sheet
- Finds the first occurance of a record matching a particular sid and returns it's position.
- findFirstRecordLocBySid(short) - Method in class org.apache.poi.hssf.model.Workbook
- Returns the index of a record matching a particular sid.
- findFreeSPIDBlock() - Method in class org.apache.poi.hssf.model.DrawingManager
- findNewDrawingGroupId() - Method in class org.apache.poi.hssf.model.DrawingManager
- findNextRecordBySid(short, int) - Method in class org.apache.poi.hssf.model.Workbook
- Returns the next occurance of a record matching a particular sid.
- findSheetNameFromExternSheet(short) - Method in class org.apache.poi.hssf.model.Workbook
- finds the sheet name by his extern sheet index
- fixTabIdRecord() - Method in class org.apache.poi.hssf.model.Workbook
- make the tabid record look like the current situation.
- fontpos - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
- footer - Variable in class org.apache.poi.hssf.model.Sheet
- formats - Variable in class org.apache.poi.hssf.model.Workbook
- formulaLength - Variable in class org.apache.poi.hssf.model.FormulaParser
- formulaString - Variable in class org.apache.poi.hssf.model.FormulaParser
- function(String) - Method in class org.apache.poi.hssf.model.FormulaParser
- functionTokens - Variable in class org.apache.poi.hssf.model.FormulaParser
- Using an unsynchronized linkedlist to implement a stack since we're not multi-threaded.
G
- GetChar() - Method in class org.apache.poi.hssf.model.FormulaParser
- Read New Character From Input Stream
- GetName() - Method in class org.apache.poi.hssf.model.FormulaParser
- Get an Identifier
- GetNameAsIs() - Method in class org.apache.poi.hssf.model.FormulaParser
- Get an Identifier AS IS, without stripping white spaces or converting to uppercase; used for literals
- GetNum() - Method in class org.apache.poi.hssf.model.FormulaParser
- Get a Number
- GreaterEqual() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and translate Greater than or Equal
- GreaterThan() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate a Greater Than
- get(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getActiveCellCol() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the active column
- getActiveCellRow() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the active row
- getBackupRecord() - Method in class org.apache.poi.hssf.model.Workbook
- Returns the position of the backup record.
- getBackuppos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getBspos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getChild(int) - Method in class org.apache.poi.hssf.model.Node
- getColumnBreaks() - Method in class org.apache.poi.hssf.model.Sheet
- Returns all the column page breaks
- getColumnWidth(short) - Method in class org.apache.poi.hssf.model.Sheet
- get the width of a given column in units of 1/20th of a point width (twips?)
- getCustomPalette() - Method in class org.apache.poi.hssf.model.Workbook
- Returns the custom palette in use for this workbook; if a custom palette record does not exist, then it is created.
- getDefaultColumnWidth() - Method in class org.apache.poi.hssf.model.Sheet
- get the default column width for the sheet (if the columns do not define their own width)
- getDefaultRowHeight() - Method in class org.apache.poi.hssf.model.Sheet
- get the default row height for the sheet (if the rows do not define their own height)
- getDgg() - Method in class org.apache.poi.hssf.model.DrawingManager
- getDimsLoc() - Method in class org.apache.poi.hssf.model.Sheet
- get the location of the DimensionsRecord (which is the last record before the value section)
- getDrawingManager() - Method in class org.apache.poi.hssf.model.Workbook
- getEofLoc() - Method in class org.apache.poi.hssf.model.Sheet
- getEscherTextbox() - Method in class org.apache.poi.hssf.model.TextboxShape
- getExFormatAt(int) - Method in class org.apache.poi.hssf.model.Workbook
- gets the ExtendedFormatRecord at the given 0-based index
- getExternsheetPos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- Returns the externsheetPos.
- getFontRecordAt(int) - Method in class org.apache.poi.hssf.model.Workbook
- gets the font record at the given index in the font table.
- getFontpos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getFooter() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the FooterRecord.
- getFormat(String, boolean) - Method in class org.apache.poi.hssf.model.Workbook
- Returns a format index that matches the passed in format.
- getFormats() - Method in class org.apache.poi.hssf.model.Workbook
- Returns the list of FormatRecords in the workbook.
- getFunction(String, byte) - Method in class org.apache.poi.hssf.model.FormulaParser
- Generates the variable function ptg for the formula.
- getGridsetRecord() - Method in class org.apache.poi.hssf.model.Sheet
- Gets the gridset record for this sheet.
- getHeader() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the HeaderRecord.
- getLoc() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the location pointer to the first record to look for when adding rows/values
- getMargin(short) - Method in class org.apache.poi.hssf.model.Sheet
- Gets the size of the margin in inches.
- getMargins() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the array of margins.
- getMergedRegionAt(int) - Method in class org.apache.poi.hssf.model.Sheet
- getNameRecord(int) - Method in class org.apache.poi.hssf.model.Workbook
- gets the name record
- getNamepos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- Returns the namepos.
- getNextRow() - Method in class org.apache.poi.hssf.model.Sheet
- get the NEXT RowRecord (from LOC).
- getNextValueRecord() - Method in class org.apache.poi.hssf.model.Sheet
- get the NEXT value record (from LOC).
- getNumChildren() - Method in class org.apache.poi.hssf.model.Node
- getNumColumnBreaks() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the number of column page breaks
- getNumExFormats() - Method in class org.apache.poi.hssf.model.Workbook
- get the number of ExtendedFormat records contained in this workbook.
- getNumMergedRegions() - Method in class org.apache.poi.hssf.model.Sheet
- getNumNames() - Method in class org.apache.poi.hssf.model.Workbook
- gets the total number of names
- getNumRecords() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the number of low level binary records in this sheet.
- getNumRecords() - Method in class org.apache.poi.hssf.model.Workbook
- getNumRowBreaks() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the number of row page breaks
- getNumSheets() - Method in class org.apache.poi.hssf.model.Workbook
- returns the number of boundsheet objects contained in this workbook.
- getNumberOfFontRecords() - Method in class org.apache.poi.hssf.model.Workbook
- gets the number of font records
- getObjRecord() - Method in class org.apache.poi.hssf.model.AbstractShape
- getObjRecord() - Method in class org.apache.poi.hssf.model.LineShape
- getObjRecord() - Method in class org.apache.poi.hssf.model.PolygonShape
- getObjRecord() - Method in class org.apache.poi.hssf.model.SimpleFilledShape
- getObjRecord() - Method in class org.apache.poi.hssf.model.TextboxShape
- getPalettepos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getPreOffset() - Method in class org.apache.poi.hssf.model.Sheet
- get the preoffset when using DBCELL records (currently unused) - this is the position of this sheet within the whole file.
- getPrintGridlines() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the PrintGridlinesRecord.
- getPrintSetup() - Method in class org.apache.poi.hssf.model.Sheet
- Returns the PrintSetupRecord.
- getProtect() - Method in class org.apache.poi.hssf.model.Sheet
- getProtpos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getPtgSize(int) - Method in class org.apache.poi.hssf.model.FormulaParser
- Adds the size of all the ptgs after the provided index (inclusive).
- getPtgSize(int, int) - Method in class org.apache.poi.hssf.model.FormulaParser
- getRPNPtg() - Method in class org.apache.poi.hssf.model.FormulaParser
- API call to retrive the array of Ptgs created as a result of the parsing
- getRPNPtg(int) - Method in class org.apache.poi.hssf.model.FormulaParser
- getRecords() - Method in class org.apache.poi.hssf.model.Sheet
- getRecords() - Method in class org.apache.poi.hssf.model.Workbook
- getRecords() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getRow(int) - Method in class org.apache.poi.hssf.model.Sheet
- get the NEXT (from LOC) RowRecord where rownumber matches the given rownum.
- getRowBreaks() - Method in class org.apache.poi.hssf.model.Sheet
- Returns all the row page breaks
- getSSTString(int) - Method in class org.apache.poi.hssf.model.Workbook
- given an index into the SST table, this function returns the corresponding String value
- getSelection() - Method in class org.apache.poi.hssf.model.Sheet
- getSheetIndex(String) - Method in class org.apache.poi.hssf.model.Workbook
- get the sheet's index
- getSheetIndexFromExternSheetIndex(int) - Method in class org.apache.poi.hssf.model.Workbook
- Finds the sheet index for a particular external sheet number.
- getSheetName(int) - Method in class org.apache.poi.hssf.model.Workbook
- gets the name for a given sheet.
- getSheetReferences() - Method in class org.apache.poi.hssf.model.Workbook
- getSize() - Method in class org.apache.poi.hssf.model.Sheet
- getSize() - Method in class org.apache.poi.hssf.model.Workbook
- getSpContainer() - Method in class org.apache.poi.hssf.model.AbstractShape
- getSpContainer() - Method in class org.apache.poi.hssf.model.LineShape
- getSpContainer() - Method in class org.apache.poi.hssf.model.PolygonShape
- getSpContainer() - Method in class org.apache.poi.hssf.model.SimpleFilledShape
- getSpContainer() - Method in class org.apache.poi.hssf.model.TextboxShape
- getSpecificBuiltinRecord(byte, int) - Method in class org.apache.poi.hssf.model.Workbook
- Retrieves the Builtin NameRecord that matches the name and index There shouldn't be too many names to make the sequential search too slow
- getSupbookpos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- Returns the supbookpos.
- getTabpos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- getTextObjectRecord() - Method in class org.apache.poi.hssf.model.TextboxShape
- getValue() - Method in class org.apache.poi.hssf.model.Node
- getXfpos() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- gridset - Variable in class org.apache.poi.hssf.model.Sheet
- groupColumnRange(short, short, boolean) - Method in class org.apache.poi.hssf.model.Sheet
- Creates an outline group for the specified columns.
- groupRowRange(int, int, boolean) - Method in class org.apache.poi.hssf.model.Sheet
H
I
- Ident() - Method in class org.apache.poi.hssf.model.FormulaParser
- Parse and Translate a String Identifier
- IsAddop(char) - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize an Addop
- IsAlNum(char) - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize an Alphanumeric
- IsAlpha(char) - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize an Alpha Character
- IsDigit(char) - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize a Decimal Digit
- IsSpecialChar(char) - Method in class org.apache.poi.hssf.model.FormulaParser
- Determines special characters;primarily in use for definition of string literals
- IsWhite(char) - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize White Space
- inFunction - Variable in class org.apache.poi.hssf.model.FormulaParser
- init() - Method in class org.apache.poi.hssf.model.FormulaParser
- Initialize
- insertSST() - Method in class org.apache.poi.hssf.model.Workbook
- use this function to add a Shared String Table to an existing sheet (say generated by a different java api) without an sst....
- isColumnBroken(short) - Method in class org.apache.poi.hssf.model.Sheet
- Queries if the specified column has a page break
- isDisplayFormulas() - Method in class org.apache.poi.hssf.model.Sheet
- Returns if formulas are displayed.
- isDisplayGridlines() - Method in class org.apache.poi.hssf.model.Sheet
- Returns if gridlines are displayed.
- isDisplayRowColHeadings() - Method in class org.apache.poi.hssf.model.Sheet
- Returns if RowColHeadings are displayed.
- isGridsPrinted() - Method in class org.apache.poi.hssf.model.Sheet
- get whether gridlines are printed.
- isRowBroken(int) - Method in class org.apache.poi.hssf.model.Sheet
- Queries if the specified row has a page break
- isUsing1904DateWindowing() - Method in class org.apache.poi.hssf.model.Workbook
- Whether date windowing is based on 1/2/1904 or 1/1/1900.
- iterator() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
L
- LeftMargin - Static variable in class org.apache.poi.hssf.model.Sheet
- LessEqual() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and translate Less than or Equal
- LessThan() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate a Less Than
- LineShape - class org.apache.poi.hssf.model.LineShape.
- Represents a line shape and creates all the line specific low level records.
- LineShape(HSSFSimpleShape, int) - Constructor for class org.apache.poi.hssf.model.LineShape
- Creates the line shape from the highlevel user shape.
- loc - Variable in class org.apache.poi.hssf.model.Sheet
- log - Static variable in class org.apache.poi.hssf.model.Sheet
- log - Static variable in class org.apache.poi.hssf.model.Workbook
- look - Variable in class org.apache.poi.hssf.model.FormulaParser
M
- Match(char) - Method in class org.apache.poi.hssf.model.FormulaParser
- Match a Specific Input Character
- Model - interface org.apache.poi.hssf.model.Model.
- enclosing_type describe the purpose here
- Multiply() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate a Multiply
- main(String[]) - Static method in class org.apache.poi.hssf.model.TestFormulaParser
- margins - Variable in class org.apache.poi.hssf.model.Sheet
- maxformatid - Variable in class org.apache.poi.hssf.model.Workbook
- merged - Variable in class org.apache.poi.hssf.model.Sheet
- mergedRecords - Variable in class org.apache.poi.hssf.model.Sheet
N
- Node - class org.apache.poi.hssf.model.Node.
- Private helper class, used to create a tree representation of the formula
- Node(Ptg) - Constructor for class org.apache.poi.hssf.model.Node
- NotEqual() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and not Equal
- namepos - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
- names - Variable in class org.apache.poi.hssf.model.Workbook
- numChild - Variable in class org.apache.poi.hssf.model.Node
- numMergedRegions - Variable in class org.apache.poi.hssf.model.Sheet
- numParen - Variable in class org.apache.poi.hssf.model.FormulaParser
- numfonts - Variable in class org.apache.poi.hssf.model.Workbook
- numxfs - Variable in class org.apache.poi.hssf.model.Workbook
O
- OBJECT_TYPE_MICROSOFT_OFFICE_DRAWING - Static variable in class org.apache.poi.hssf.model.PolygonShape
- objRecord - Variable in class org.apache.poi.hssf.model.LineShape
- objRecord - Variable in class org.apache.poi.hssf.model.PolygonShape
- objRecord - Variable in class org.apache.poi.hssf.model.SimpleFilledShape
- objRecord - Variable in class org.apache.poi.hssf.model.TextboxShape
- objTypeToShapeType(int) - Method in class org.apache.poi.hssf.model.SimpleFilledShape
- org.apache.poi.hssf.model - package org.apache.poi.hssf.model
P
- PANE_LOWER_LEFT - Static variable in class org.apache.poi.hssf.model.Sheet
- PANE_LOWER_RIGHT - Static variable in class org.apache.poi.hssf.model.Sheet
- PANE_UPPER_LEFT - Static variable in class org.apache.poi.hssf.model.Sheet
- PANE_UPPER_RIGHT - Static variable in class org.apache.poi.hssf.model.Sheet
- PolygonShape - class org.apache.poi.hssf.model.PolygonShape.
- PolygonShape(HSSFPolygon, int) - Constructor for class org.apache.poi.hssf.model.PolygonShape
- Creates the low evel records for an polygon.
- Power() - Method in class org.apache.poi.hssf.model.FormulaParser
- palettepos - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
- parse() - Method in class org.apache.poi.hssf.model.FormulaParser
- API call to execute the parsing of the formula
- pointer - Variable in class org.apache.poi.hssf.model.FormulaParser
- preSerialize() - Method in class org.apache.poi.hssf.model.Sheet
- Perform any work necessary before the sheet is about to be serialized.
- preoffset - Variable in class org.apache.poi.hssf.model.Sheet
- printGridlines - Variable in class org.apache.poi.hssf.model.Sheet
- printSetup - Variable in class org.apache.poi.hssf.model.Sheet
- protect - Variable in class org.apache.poi.hssf.model.Sheet
- protpos - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
R
- RightMargin - Static variable in class org.apache.poi.hssf.model.Sheet
- recalcRowGutter() - Method in class org.apache.poi.hssf.model.Sheet
- records - Variable in class org.apache.poi.hssf.model.Sheet
- records - Variable in class org.apache.poi.hssf.model.Workbook
- this contains the Worksheet record objects
- records - Variable in class org.apache.poi.hssf.model.WorkbookRecordList
- remove(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- removeBuiltinRecord(byte, int) - Method in class org.apache.poi.hssf.model.Workbook
- Removes the specified Builtin NameRecord that matches the name and index
- removeColumnBreak(short) - Method in class org.apache.poi.hssf.model.Sheet
- Removes a page break at the indicated column
- removeMergedRegion(int) - Method in class org.apache.poi.hssf.model.Sheet
- removeName(int) - Method in class org.apache.poi.hssf.model.Workbook
- removes the name
- removeRow(RowRecord) - Method in class org.apache.poi.hssf.model.Sheet
- Removes a row record This method is not loc sensitive, it resets loc to = dimsloc so no worries.
- removeRowBreak(int) - Method in class org.apache.poi.hssf.model.Sheet
- Removes a page break at the indicated row
- removeSheet(int) - Method in class org.apache.poi.hssf.model.Workbook
- removeValueRecord(int, CellValueRecordInterface) - Method in class org.apache.poi.hssf.model.Sheet
- remove a value record from the records array.
- replaceValueRecord(CellValueRecordInterface) - Method in class org.apache.poi.hssf.model.Sheet
- replace a value record from the records array.
- result - Variable in class org.apache.poi.hssf.model.FormulaParser
- rowBreaks - Variable in class org.apache.poi.hssf.model.Sheet
- rowRecIterator - Variable in class org.apache.poi.hssf.model.Sheet
- rows - Variable in class org.apache.poi.hssf.model.Sheet
S
- Sheet - class org.apache.poi.hssf.model.Sheet.
- Low level model implementation of a Sheet (one workbook contains many sheets) This file contains the low level binary records starting at the sheets BOF and ending with the sheets EOF.
- Sheet() - Constructor for class org.apache.poi.hssf.model.Sheet
- Creates new Sheet with no intialization --useless at this point
- SheetTest - class org.apache.poi.hssf.model.SheetTest.
- SheetTest(String) - Constructor for class org.apache.poi.hssf.model.SheetTest
- Constructor for SheetTest.
- SimpleFilledShape - class org.apache.poi.hssf.model.SimpleFilledShape.
- SimpleFilledShape(HSSFSimpleShape, int) - Constructor for class org.apache.poi.hssf.model.SimpleFilledShape
- Creates the low evel records for an oval.
- SkipWhite() - Method in class org.apache.poi.hssf.model.FormulaParser
- Skip Over Leading White Space
- StringLiteral() - Method in class org.apache.poi.hssf.model.FormulaParser
- Subtract() - Method in class org.apache.poi.hssf.model.FormulaParser
- Recognize and Translate a Subtract
- selection - Variable in class org.apache.poi.hssf.model.Sheet
- serialize() - Method in class org.apache.poi.hssf.model.Sheet
- Serializes all records in the sheet into one big byte array.
- serialize(int, byte[]) - Method in class org.apache.poi.hssf.model.Sheet
- Serializes all records in the sheet into one big byte array.
- serialize(int, byte[]) - Method in class org.apache.poi.hssf.model.Workbook
- Serializes all records int the worksheet section into a big byte array.
- setActiveCellCol(short) - Method in class org.apache.poi.hssf.model.Sheet
- Sets the active column
- setActiveCellRow(int) - Method in class org.apache.poi.hssf.model.Sheet
- Sets the active row
- setBackuppos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- setBspos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- setChildren(Node[]) - Method in class org.apache.poi.hssf.model.Node
- setClass(Node, byte) - Method in class org.apache.poi.hssf.model.FormulaParser
- setColumn(short, Short, Integer, Boolean, Boolean) - Method in class org.apache.poi.hssf.model.Sheet
- setColumnBreak(short, short, short) - Method in class org.apache.poi.hssf.model.Sheet
- Sets a page break at the indicated column
- setColumnGroupCollapsed(short, boolean) - Method in class org.apache.poi.hssf.model.Sheet
- setColumnWidth(short, short) - Method in class org.apache.poi.hssf.model.Sheet
- set the width for a given column in 1/20th of a character width units
- setDefaultColumnWidth(short) - Method in class org.apache.poi.hssf.model.Sheet
- set the default column width for the sheet (if the columns do not define their own width)
- setDefaultRowHeight(short) - Method in class org.apache.poi.hssf.model.Sheet
- set the default row height for the sheet (if the rows do not define their own height)
- setDimensions(int, short, int, short) - Method in class org.apache.poi.hssf.model.Sheet
- Per an earlier reported bug in working with Andy Khan's excel read library.
- setDisplayFormulas(boolean) - Method in class org.apache.poi.hssf.model.Sheet
- Sets whether the formulas are shown in a viewer.
- setDisplayGridlines(boolean) - Method in class org.apache.poi.hssf.model.Sheet
- Sets whether the gridlines are shown in a viewer.
- setDisplayRowColHeadings(boolean) - Method in class org.apache.poi.hssf.model.Sheet
- Sets whether the RowColHeadings are shown in a viewer.
- setExternsheetPos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- Sets the externsheetPos.
- setFontpos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
- setFooter(FooterRecord) - Method in class org.apache.poi.hssf.model.