Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV LETTER NEXT LETTER | FRAMES NO FRAMES

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _

## V

validate(byte[], byte[]) - Method in class org.apache.poi.hssf.record.crypto.Biff8EncryptionKey
validate(SpreadsheetVersion) - Method in class org.apache.poi.ss.util.CellRangeAddressBase
  Validate the range limits against the supplied version of Excel
validateSecondArg(int, String) - Static method in class org.apache.poi.ss.usermodel.DataValidationConstraint.OperatorType
validateSheetName(String) - Static method in class org.apache.poi.ss.util.WorkbookUtil
  Validates sheet name.
validateSheetState(int) - Static method in class org.apache.poi.ss.util.WorkbookUtil
Value - Class in org.apache.poi.hssf.record.formula.functions
  Implementation for Excel VALUE() function.

  Syntax:
  VALUE(text)
  Converts the text argument to a number.
Value() - Constructor for class org.apache.poi.hssf.record.formula.functions.Value
VALUE - Static variable in class org.apache.poi.ss.usermodel.FormulaError
  Intended to indicate when an incompatible type argument is passed to a function, or an incompatible type operand is used with an operator.
value - Static variable in interface org.apache.poi.util.Internal
VALUE_INVALID - Static variable in class org.apache.poi.hssf.record.formula.ErrPtg
  #VALUE! - Wrong type of operand
VALUE_INVALID - Static variable in class org.apache.poi.hssf.record.formula.eval.ErrorEval
  #VALUE! - Wrong type of operand
ValueEval - Interface in org.apache.poi.hssf.record.formula.eval
valueOf(int) - Static method in class org.apache.poi.hssf.record.constant.ErrorConstant
valueOf(boolean) - Static method in class org.apache.poi.hssf.record.formula.BoolPtg
valueOf(int) - Static method in class org.apache.poi.hssf.record.formula.ErrPtg
valueOf(boolean) - Static method in class org.apache.poi.hssf.record.formula.eval.BoolEval
  Convenience method for the following:
  `(b ? BoolEval.TRUE : BoolEval.FALSE)`
valueOf(int) - Static method in class org.apache.poi.hssf.record.formula.eval.ErrorEval
  Translates an Excel internal error code into the corresponding POI ErrorEval instance
valueOf(boolean) - Static method in class org.apache.poi.ss.usermodel.CellValue
valueOf(int) - Static method in class org.apache.poi.ss.usermodel.FontCharset
valueOf(int) - Static method in class org.apache.poi.ss.usermodel.FontFamily
valueOf(int) - Static method in class org.apache.poi.ss.usermodel.FontScheme
valueOf(int) - Static method in class org.apache.poi.ss.usermodel.FontUnderline
valueOf(byte) - Static method in class org.apache.poi.ss.usermodel.FontUnderline
valueOf(int) - Static method in class org.apache.poi.ss.usermodel.PageOrder
valueOf(int) - Static method in class org.apache.poi.ss.usermodel.PrintCellComments
valueOf(int) - Static method in class org.apache.poi.ss.usermodel.PrintOrientation
valueOf(String) - Static method in class org.apache.poi.ss.util.CellRangeAddress
ValueOperatorPtg - Class in org.apache.poi.hssf.record.formula
  Common superclass of all value operators.
ValueOperatorPtg() - Constructor for class org.apache.poi.hssf.record.formula.ValueOperatorPtg
ValueRangeRecord - Class in org.apache.poi.hssf.record.chart
  The value range record defines the range of the value axis.

ValueRangeRecord() - Constructor for class org.apache.poi.hssf.record.chart.ValueRangeRecord
ValueRangeRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.ValueRangeRecord
ValueRecordsAggregate - Class in org.apache.poi.hssf.record.aggregates
  Aggregate value records together.
ValueRecordsAggregate() - Constructor for class org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate
  Creates a new instance of ValueRecordsAggregate
values() - Static method in class org.apache.poi.ss.usermodel.BorderStyle
values() - Static method in class org.apache.poi.ss.usermodel.FillPatternType
values() - Static method in class org.apache.poi.ss.usermodel.FontFamily
values() - Static method in class org.apache.poi.ss.usermodel.FontScheme
values() - Static method in class org.apache.poi.ss.usermodel.FontUnderline
values() - Static method in class org.apache.poi.ss.usermodel.FormulaError
values() - Static method in class org.apache.poi.ss.usermodel.HorizontalAlignment
values() - Static method in class org.apache.poi.ss.usermodel.PageOrder
values() - Static method in class org.apache.poi.ss.usermodel.PaperSize
values() - Static method in class org.apache.poi.ss.usermodel.PrintCellComments
values() - Static method in class org.apache.poi.ss.usermodel.PrintOrientation
values() - Static method in class org.apache.poi.ss.usermodel.VerticalAlignment
values() - Method in class org.apache.poi.util.BinaryTree
  Returns a collection view of the values contained in this map.
VALUES_DATA_TYPE_DATES - Static variable in class org.apache.poi.hssf.record.chart.SeriesRecord
VALUES_DATA_TYPE_NUMERIC - Static variable in class org.apache.poi.hssf.record.chart.SeriesRecord
VALUES_DATA_TYPE_SEQUENCE - Static variable in class org.apache.poi.hssf.record.chart.SeriesRecord
VALUES_DATA_TYPE_TEXT - Static variable in class org.apache.poi.hssf.record.chart.SeriesRecord
valuesByValue() - Method in class org.apache.poi.util.BinaryTree
  Returns a collection view of the values contained in this map.
Variant - Class in org.apache.poi.hpsf
  The Variant types as defined by Microsoft's COM.
Variant() - Constructor for class org.apache.poi.hpsf.Variant
VariantSupport - Class in org.apache.poi.hpsf
  Supports reading and writing of variant data.
VariantSupport() - Constructor for class org.apache.poi.hpsf.VariantSupport
VariantTypeException - Exception in org.apache.poi.hpsf
  This exception is thrown if HPSF encounters a problem with a variant type.
VariantTypeException(long, Object, String) - Constructor for exception org.apache.poi.hpsf.VariantTypeException
  Constructor.
VCenterRecord - Class in org.apache.poi.hssf.record
  Title: VCenter record
VCenterRecord() - Constructor for class org.apache.poi.hssf.record.VCenterRecord
VCenterRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.VCenterRecord
verifyBelongsToWorkbook(HSSFWorkbook) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  Verifies that this style belongs to the supplied Workbook.
verifyPassword(String) - Method in class org.apache.poi.poifs.crypt.Decryptor
VERSION - Static variable in class org.apache.poi.hssf.record.BOFRecord
  suggested default (0x0600 - BIFF8)
VERTICAL_ALIGNMENT - Static variable in class org.apache.poi.ss.util.CellUtil
VERTICAL_ALIGNMENT_BOTTOM - Static variable in class org.apache.poi.hssf.record.chart.TextRecord
VERTICAL_ALIGNMENT_BOTTOM - Static variable in class org.apache.poi.hssf.usermodel.HSSFTextbox
VERTICAL_ALIGNMENT_CENTER - Static variable in class org.apache.poi.hssf.record.chart.TextRecord
VERTICAL_ALIGNMENT_CENTER - Static variable in class org.apache.poi.hssf.usermodel.HSSFTextbox
VERTICAL_ALIGNMENT_DISTRIBUTED - Static variable in class org.apache.poi.hssf.usermodel.HSSFTextbox
VERTICAL_ALIGNMENT_JUSTIFY - Static variable in class org.apache.poi.hssf.record.chart.TextRecord
VERTICAL_ALIGNMENT_JUSTIFY - Static variable in class org.apache.poi.hssf.usermodel.HSSFTextbox
VERTICAL_ALIGNMENT_TOP - Static variable in class org.apache.poi.hssf.record.chart.TextRecord
VERTICAL_ALIGNMENT_TOP - Static variable in class org.apache.poi.hssf.usermodel.HSSFTextbox
  How to align text vertically
VERTICAL_BOTTOM - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
VERTICAL_BOTTOM - Static variable in interface org.apache.poi.ss.usermodel.CellStyle
  bottom-aligned vertical alignment
VERTICAL_CENTER - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
VERTICAL_CENTER - Static variable in interface org.apache.poi.ss.usermodel.CellStyle
  center-aligned vertical alignment
VERTICAL_JUSTIFY - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
VERTICAL_JUSTIFY - Static variable in interface org.apache.poi.ss.usermodel.CellStyle
  vertically justified vertical alignment
VERTICAL_SCROLL - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
VERTICAL_TEXT_ALIGNMENT_BOTTOM - Static variable in class org.apache.poi.hssf.record.TextObjectRecord
VERTICAL_TEXT_ALIGNMENT_CENTER - Static variable in class org.apache.poi.hssf.record.TextObjectRecord
VERTICAL_TEXT_ALIGNMENT_JUSTIFY - Static variable in class org.apache.poi.hssf.record.TextObjectRecord
VERTICAL_TEXT_ALIGNMENT_TOP - Static variable in class org.apache.poi.hssf.record.TextObjectRecord
VERTICAL_TOP - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
VERTICAL_TOP - Static variable in interface org.apache.poi.ss.usermodel.CellStyle
  top-aligned vertical alignment
VerticalAlignment - Class in org.apache.poi.ss.usermodel
  This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.
VerticalAlignment(int) - Constructor for class org.apache.poi.ss.usermodel.VerticalAlignment
VerticalPageBreakRecord - Class in org.apache.poi.hssf.record
  VerticalPageBreak (0x001A) record that stores page breaks at columns

VerticalPageBreakRecord() - Constructor for class org.apache.poi.hssf.record.VerticalPageBreakRecord
  Creates an empty vertical page break record
VerticalPageBreakRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.VerticalPageBreakRecord
VIETNAMESE - Static variable in class org.apache.poi.ss.usermodel.FontCharset
ViewDefinitionRecord - Class in org.apache.poi.hssf.record.pivottable
  SXVIEW - View Definition (0x00B0)
ViewDefinitionRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.pivottable.ViewDefinitionRecord
ViewFieldsRecord - Class in org.apache.poi.hssf.record.pivottable
  SXVD - View Fields (0x00B1)
ViewFieldsRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.pivottable.ViewFieldsRecord
viewFile(String) - Static method in class org.apache.poi.poifs.dev.POIFSHeaderDumper
viewFile(String, boolean) - Static method in class org.apache.poi.poifs.dev.POIFSLister
ViewSourceRecord - Class in org.apache.poi.hssf.record.pivottable
  SXVS - View Source (0x00E3)
ViewSourceRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.pivottable.ViewSourceRecord
VIOLET - Static variable in class org.apache.poi.ss.usermodel.IndexedColors
visitCellsForRow(int, RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate
visitContainedRecords(RecordAggregate.RecordVisitor, int) - Method in class org.apache.poi.hssf.model.InternalSheet
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.CFRecordsAggregate
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.ChartSubstreamRecordAggregate
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.ColumnInfoRecordsAggregate
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.ConditionalFormattingTable
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.CustomViewSettingsRecordAggregate
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.DataValidityTable
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.MergedCellsTable
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.RecordAggregate
  Visit each of the atomic BIFF records contained in this `RecordAggregate` in the order that they should be written to file.
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.RowRecordsAggregate
visitContainedRecords(RecordAggregate.RecordVisitor) - Method in class org.apache.poi.hssf.record.aggregates.WorksheetProtectionBlock
visitRecord(Record) - Method in class org.apache.poi.hssf.record.aggregates.RecordAggregate.PositionTrackingVisitor
visitRecord(Record) - Method in interface org.apache.poi.hssf.record.aggregates.RecordAggregate.RecordVisitor
  Implementors may call non-mutating methods on Record r.
Vlookup - Class in org.apache.poi.hssf.record.formula.functions
  Implementation of the VLOOKUP() function.

  VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.
  Syntax:
  VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

  lookup_value The value to be found in the first column of the table array.
  table_array An area reference for the lookup data.
Vlookup() - Constructor for class org.apache.poi.hssf.record.formula.functions.Vlookup
VT_ARRAY - Static variable in class org.apache.poi.hpsf.Variant
  [V] SAFEARRAY*.
VT_BLOB - Static variable in class org.apache.poi.hpsf.Variant
  [P] Length prefixed bytes.
VT_BLOB_OBJECT - Static variable in class org.apache.poi.hpsf.Variant
  [P] Blob contains an object.
VT_BOOL - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] True=-1, False=0.
VT_BSTR - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] OLE Automation string.
VT_BYREF - Static variable in class org.apache.poi.hpsf.Variant
  [V] void* for local use.
VT_CARRAY - Static variable in class org.apache.poi.hpsf.Variant
  [T] C style array.
VT_CF - Static variable in class org.apache.poi.hpsf.Variant
  [P] Clipboard format.
VT_CLSID - Static variable in class org.apache.poi.hpsf.Variant
  [P] A Class ID.
VT_CY - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] currency.
VT_DATE - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] date.
VT_DECIMAL - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][S] 16 byte fixed point.
VT_DISPATCH - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] IDispatch *.
VT_EMPTY - Static variable in class org.apache.poi.hpsf.Variant
  [V][P] Nothing, i.e.
VT_ERROR - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][S] SCODE.
VT_FILETIME - Static variable in class org.apache.poi.hpsf.Variant
  [P] FILETIME.
VT_HRESULT - Static variable in class org.apache.poi.hpsf.Variant
  [T] Standard return type.
VT_I1 - Static variable in class org.apache.poi.hpsf.Variant
  [T] signed char.
VT_I2 - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] 2 byte signed int.
VT_I4 - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] 4 byte signed int.
VT_I8 - Static variable in class org.apache.poi.hpsf.Variant
  [T][P] signed 64-bit int.
VT_ILLEGAL - Static variable in class org.apache.poi.hpsf.Variant
  FIXME (3): Document this!
VT_ILLEGALMASKED - Static variable in class org.apache.poi.hpsf.Variant
  FIXME (3): Document this!
VT_INT - Static variable in class org.apache.poi.hpsf.Variant
  [T] signed machine int.
VT_LPSTR - Static variable in class org.apache.poi.hpsf.Variant
  [T][P] null terminated string.
VT_LPWSTR - Static variable in class org.apache.poi.hpsf.Variant
  [T][P] wide (Unicode) null terminated string.
VT_NULL - Static variable in class org.apache.poi.hpsf.Variant
  [V][P] SQL style Null.
VT_PTR - Static variable in class org.apache.poi.hpsf.Variant
  [T] pointer type.
VT_R4 - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] 4 byte real.
VT_R8 - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] 8 byte real.
VT_RESERVED - Static variable in class org.apache.poi.hpsf.Variant
  FIXME (3): Document this!
VT_SAFEARRAY - Static variable in class org.apache.poi.hpsf.Variant
  [T] (use VT_ARRAY in VARIANT).
VT_STORAGE - Static variable in class org.apache.poi.hpsf.Variant
  [P] Name of the storage follows.
VT_STORED_OBJECT - Static variable in class org.apache.poi.hpsf.Variant
  [P] Storage contains an object.
VT_STREAM - Static variable in class org.apache.poi.hpsf.Variant
  [P] Name of the stream follows.
VT_STREAMED_OBJECT - Static variable in class org.apache.poi.hpsf.Variant
  [P] Stream contains an object.
VT_TYPEMASK - Static variable in class org.apache.poi.hpsf.Variant
  FIXME (3): Document this!
VT_UI1 - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] unsigned char.
VT_UI2 - Static variable in class org.apache.poi.hpsf.Variant
  [T][P] unsigned short.
VT_UI4 - Static variable in class org.apache.poi.hpsf.Variant
  [T][P] unsigned int.
VT_UI8 - Static variable in class org.apache.poi.hpsf.Variant
  [T][P] unsigned 64-bit int.
VT_UINT - Static variable in class org.apache.poi.hpsf.Variant
  [T] unsigned machine int.
VT_UNKNOWN - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][S] IUnknown *.
VT_USERDEFINED - Static variable in class org.apache.poi.hpsf.Variant
  [T] user defined type.
VT_VARIANT - Static variable in class org.apache.poi.hpsf.Variant
  [V][T][P][S] VARIANT *.
VT_VECTOR - Static variable in class org.apache.poi.hpsf.Variant
  [P] simple counted array.
VT_VOID - Static variable in class org.apache.poi.hpsf.Variant
  [T] C style void.

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV LETTER NEXT LETTER | FRAMES NO FRAMES

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _