- N_A - Static variable in class org.apache.poi.ss.formula.ptg.ErrPtg
-
#N/A - Argument or function not available
- NA - Static variable in class org.apache.poi.ss.formula.eval.ErrorEval
-
#N/A - Argument or function not available
- Na - Class in org.apache.poi.ss.formula.functions
-
Implementation of Excel function NA()
- Na() - Constructor for class org.apache.poi.ss.formula.functions.Na
-
- name - Variable in enum org.apache.poi.ss.usermodel.ConditionalFormattingThreshold.RangeType
-
Name (system) of the type
- name - Variable in enum org.apache.poi.ss.usermodel.IconMultiStateFormatting.IconSet
-
Name (system) of the set
- Name - Interface in org.apache.poi.ss.usermodel
-
Represents a defined name for a range of cells.
- NAME_INVALID - Static variable in class org.apache.poi.ss.formula.eval.ErrorEval
-
#NAME? - Wrong function or range name
- NAME_INVALID - Static variable in class org.apache.poi.ss.formula.ptg.ErrPtg
-
#NAME? - Wrong function or range name
- NameCommentRecord - Class in org.apache.poi.hssf.record
-
Defines a comment associated with a specified name.
- NameCommentRecord(NameCommentRecord) - Constructor for class org.apache.poi.hssf.record.NameCommentRecord
-
- NameCommentRecord(String, String) - Constructor for class org.apache.poi.hssf.record.NameCommentRecord
-
- NameCommentRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.NameCommentRecord
-
- NameIdentifier - Class in org.apache.poi.ss.formula
-
- NameIdentifier(String, boolean) - Constructor for class org.apache.poi.ss.formula.NameIdentifier
-
- NamePtg - Class in org.apache.poi.ss.formula.ptg
-
See the spec at 2.5.198.76 PtgName
- NamePtg(int) - Constructor for class org.apache.poi.ss.formula.ptg.NamePtg
-
- NamePtg(NamePtg) - Constructor for class org.apache.poi.ss.formula.ptg.NamePtg
-
- NamePtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.NamePtg
-
Creates new NamePtg
- NameRecord - Class in org.apache.poi.hssf.record
-
Defines a named range within a workbook.
- NameRecord() - Constructor for class org.apache.poi.hssf.record.NameRecord
-
Creates new NameRecord
- NameRecord(NameRecord) - Constructor for class org.apache.poi.hssf.record.NameRecord
-
- NameRecord(byte, int) - Constructor for class org.apache.poi.hssf.record.NameRecord
-
Constructor to create a built-in named region
- NameRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.NameRecord
-
called by the constructor, should set class level fields.
- nameSet() - Method in class org.apache.poi.hpsf.CustomProperties
-
Returns a set of all the names of our custom properties
- NameXPtg - Class in org.apache.poi.ss.formula.ptg
-
A Name, be that a Named Range or a Function / User Defined
Function, addressed in the HSSF External Sheet style.
- NameXPtg(int, int) - Constructor for class org.apache.poi.ss.formula.ptg.NameXPtg
-
- NameXPtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.NameXPtg
-
- NameXPxg - Class in org.apache.poi.ss.formula.ptg
-
A Name, be that a Named Range or a Function / User Defined
Function, addressed in the HSSF External Sheet style.
- NameXPxg(int, String, String) - Constructor for class org.apache.poi.ss.formula.ptg.NameXPxg
-
- NameXPxg(NameXPxg) - Constructor for class org.apache.poi.ss.formula.ptg.NameXPxg
-
- NameXPxg(String, String) - Constructor for class org.apache.poi.ss.formula.ptg.NameXPxg
-
- NameXPxg(String) - Constructor for class org.apache.poi.ss.formula.ptg.NameXPxg
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.LineDecoration.DecorationShape
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.LineDecoration.DecorationSize
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.PictureData.PictureType
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.PresetColor
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.ShapeType
-
Preset-ID for binary-based shapes
- nativeId - Variable in enum org.apache.poi.sl.usermodel.StrokeStyle.LineCap
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.StrokeStyle.LineCompound
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.StrokeStyle.LineDash
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.TabStop.TabStopType
-
- nativeId - Variable in enum org.apache.poi.sl.usermodel.TextShape.TextPlaceholder
-
- nativeName - Variable in enum org.apache.poi.sl.usermodel.ShapeType
-
POI-specific name for the binary-based type
- nativeNotesId - Variable in enum org.apache.poi.sl.usermodel.Placeholder
-
- nativeNotesMasterId - Variable in enum org.apache.poi.sl.usermodel.Placeholder
-
- nativeSlideId - Variable in enum org.apache.poi.sl.usermodel.Placeholder
-
- nativeSlideMasterId - Variable in enum org.apache.poi.sl.usermodel.Placeholder
-
- needsBouncyCastle - Variable in enum org.apache.poi.poifs.crypt.CipherAlgorithm
-
- needsBouncyCastle - Variable in enum org.apache.poi.poifs.crypt.HashAlgorithm
-
is bouncycastle necessary for calculating the digest
- newAutoFilterInstance() - Static method in class org.apache.poi.hssf.record.LbsDataSubRecord
-
- newDocumentBuilder() - Static method in class org.apache.poi.util.XMLHelper
-
Creates a new document builder, with sensible defaults
- newDocumentLink() - Method in class org.apache.poi.hssf.record.HyperlinkRecord
-
Initialize a new document link
- newDocumentSummaryInformation() - Static method in class org.apache.poi.hpsf.PropertySetFactory
-
Creates a new document summary information.
- newFileLink() - Method in class org.apache.poi.hssf.record.HyperlinkRecord
-
Initialize a new file link
- newInstance() - Method in enum org.apache.poi.ss.formula.functions.DStarRunner.DStarAlgorithmEnum
-
- newSummaryInformation() - Static method in class org.apache.poi.hpsf.PropertySetFactory
-
Creates a new summary information.
- newTransformer() - Static method in class org.apache.poi.util.XMLHelper
-
- newUrlLink() - Method in class org.apache.poi.hssf.record.HyperlinkRecord
-
Initialize a new url link
- newXMLEventFactory() - Static method in class org.apache.poi.util.StaxHelper
-
Deprecated.
Creates a new StAX XMLEventFactory, with sensible defaults
- newXMLEventFactory() - Static method in class org.apache.poi.util.XMLHelper
-
Creates a new StAX XMLEventFactory, with sensible defaults
- newXMLInputFactory() - Static method in class org.apache.poi.util.StaxHelper
-
Deprecated.
Creates a new StAX XMLInputFactory, with sensible defaults
- newXMLInputFactory() - Static method in class org.apache.poi.util.XMLHelper
-
Creates a new StAX XMLInputFactory, with sensible defaults
- newXMLOutputFactory() - Static method in class org.apache.poi.util.StaxHelper
-
Deprecated.
Creates a new StAX XMLOutputFactory, with sensible defaults
- newXMLOutputFactory() - Static method in class org.apache.poi.util.XMLHelper
-
Creates a new StAX XMLOutputFactory, with sensible defaults
- newXMLReader() - Static method in class org.apache.poi.util.XMLHelper
-
Creates a new SAX XMLReader, with sensible defaults
- nextRecord() - Method in class org.apache.poi.hssf.record.RecordFactoryInputStream
-
- nextRecord() - Method in class org.apache.poi.hssf.record.RecordInputStream
-
Moves to the next record in the stream.
- NO_COMPARISON - Static variable in interface org.apache.poi.hssf.record.CFRuleBase.ComparisonOperator
-
- NO_COMPARISON - Static variable in class org.apache.poi.ss.usermodel.ComparisonOperator
-
- NO_FILL - Static variable in class org.apache.poi.hssf.record.cf.PatternFormatting
-
No background
- NO_FILL - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
-
- NO_FILL - Static variable in interface org.apache.poi.ss.usermodel.PatternFormatting
-
No background
- NO_FILL_DEFAULT - Static variable in class org.apache.poi.hssf.usermodel.HSSFShape
-
- NO_FILLHITTEST_FALSE - Static variable in class org.apache.poi.hssf.usermodel.HSSFShape
-
- NO_FILLHITTEST_TRUE - Static variable in class org.apache.poi.hssf.usermodel.HSSFShape
-
- NO_FONT - Static variable in class org.apache.poi.hssf.usermodel.HSSFRichTextString
-
Place holder for indicating that NO_FONT has been applied here
- NO_INTERSECTION - Static variable in class org.apache.poi.ss.util.CellRangeUtil
-
- NO_SELF_RELATIVE_SECURITY_FEATURE - Static variable in class org.apache.poi.hssf.record.common.FeatProtection
-
- NO_SMOKING - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- NoFormatIDException - Exception in org.apache.poi.hpsf
-
- NoFormatIDException() - Constructor for exception org.apache.poi.hpsf.NoFormatIDException
-
Constructor
- NoFormatIDException(String) - Constructor for exception org.apache.poi.hpsf.NoFormatIDException
-
Constructor
- NoFormatIDException(Throwable) - Constructor for exception org.apache.poi.hpsf.NoFormatIDException
-
Constructor
- NoFormatIDException(String, Throwable) - Constructor for exception org.apache.poi.hpsf.NoFormatIDException
-
Constructor
- NON_ISOSCELES_TRAPEZOID - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- NONE - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
-
- NoPropertySetStreamException - Exception in org.apache.poi.hpsf
-
This exception is thrown if a format error in a property set stream is
detected or when the input data do not constitute a property set stream.
- NoPropertySetStreamException() - Constructor for exception org.apache.poi.hpsf.NoPropertySetStreamException
-
Constructor
- NoPropertySetStreamException(String) - Constructor for exception org.apache.poi.hpsf.NoPropertySetStreamException
-
Constructor
- NoPropertySetStreamException(Throwable) - Constructor for exception org.apache.poi.hpsf.NoPropertySetStreamException
-
Constructor
- NoPropertySetStreamException(String, Throwable) - Constructor for exception org.apache.poi.hpsf.NoPropertySetStreamException
-
Constructor
- NormDist - Class in org.apache.poi.ss.formula.functions
-
Implementation for Excel NORMDIST() and NORM.DIST() functions.
- NormInv - Class in org.apache.poi.ss.formula.functions
-
Implementation for Excel NORMINV() and NORM.INV() functions.
- NormSDist - Class in org.apache.poi.ss.formula.functions
-
Implementation for Excel NORMSDIST() and NORM.S.DIST functions.
- NormSInv - Class in org.apache.poi.ss.formula.functions
-
Implementation for Excel NORMSINV() and NORM.S.INV() functions.
- NoSingleSectionException - Exception in org.apache.poi.hpsf
-
- NoSingleSectionException() - Constructor for exception org.apache.poi.hpsf.NoSingleSectionException
-
Constructor
- NoSingleSectionException(String) - Constructor for exception org.apache.poi.hpsf.NoSingleSectionException
-
Constructor
- NoSingleSectionException(Throwable) - Constructor for exception org.apache.poi.hpsf.NoSingleSectionException
-
Constructor
- NoSingleSectionException(String, Throwable) - Constructor for exception org.apache.poi.hpsf.NoSingleSectionException
-
Constructor
- NoSmoking - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
-
- NOT - Static variable in class org.apache.poi.ss.formula.functions.BooleanFunction
-
- NOT_BETWEEN - Static variable in interface org.apache.poi.hssf.record.CFRuleBase.ComparisonOperator
-
- NOT_BETWEEN - Static variable in class org.apache.poi.ss.usermodel.ComparisonOperator
-
'Not between' operator
- NOT_BETWEEN - Static variable in class org.apache.poi.ss.usermodel.DataValidationConstraint.OperatorType
-
- NOT_EQUAL - Static variable in interface org.apache.poi.hssf.record.CFRuleBase.ComparisonOperator
-
- NOT_EQUAL - Static variable in class org.apache.poi.ss.usermodel.ComparisonOperator
-
'Not equal to' operator
- NOT_EQUAL - Static variable in class org.apache.poi.ss.usermodel.DataValidationConstraint.OperatorType
-
- NOTCHED_RIGHT_ARROW - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- NotchedCircularArrow - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
-
- NotchedRightArrow - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
-
- NOTE8_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
-
US Note 8 1/2 x 11 in
- NOTE_HIDDEN - Static variable in class org.apache.poi.hssf.record.NoteRecord
-
Flag indicating that the comment is hidden (default)
- NOTE_VISIBLE - Static variable in class org.apache.poi.hssf.record.NoteRecord
-
Flag indicating that the comment is visible
- NotEqualEval - Static variable in class org.apache.poi.ss.formula.eval.RelationalOperationEval
-
- NotEqualPtg - Class in org.apache.poi.ss.formula.ptg
-
Ptg class to implement not equal
- NoteRecord - Class in org.apache.poi.hssf.record
-
NOTE: Comment Associated with a Cell (0x001C)
- NoteRecord() - Constructor for class org.apache.poi.hssf.record.NoteRecord
-
Construct a new NoteRecord and
fill its data with the default values
- NoteRecord(NoteRecord) - Constructor for class org.apache.poi.hssf.record.NoteRecord
-
- NoteRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.NoteRecord
-
Read the record data from the supplied RecordInputStream
- Notes<S extends Shape<S,P>,P extends TextParagraph<S,P,? extends TextRun>> - Interface in org.apache.poi.sl.usermodel
-
- NoteStructureSubRecord - Class in org.apache.poi.hssf.record
-
ftNts (0x000D)
- NoteStructureSubRecord() - Constructor for class org.apache.poi.hssf.record.NoteStructureSubRecord
-
Construct a new NoteStructureSubRecord and
fill its data with the default values
- NoteStructureSubRecord(NoteStructureSubRecord) - Constructor for class org.apache.poi.hssf.record.NoteStructureSubRecord
-
- NoteStructureSubRecord(LittleEndianInput, int) - Constructor for class org.apache.poi.hssf.record.NoteStructureSubRecord
-
Read the record data from the supplied RecordInputStream
- NoteStructureSubRecord(LittleEndianInput, int, int) - Constructor for class org.apache.poi.hssf.record.NoteStructureSubRecord
-
- notifyDeleteCell(HSSFCell) - Method in class org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
-
Should be called to tell the cell value cache that the specified cell has just been
deleted.
- notifyDeleteCell(Cell) - Method in class org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
-
- notifyDeleteCell(EvaluationCell) - Method in class org.apache.poi.ss.formula.WorkbookEvaluator
-
Should be called to tell the cell value cache that the specified cell has just been
deleted.
- notifyDeleteCell(Cell) - Method in interface org.apache.poi.ss.usermodel.FormulaEvaluator
-
Should be called to tell the cell value cache that the specified cell has just become a
formula cell, or the formula text has changed
- notifyFormulaChanging() - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
-
Should be called by any code which is either deleting this formula cell, or changing
its type.
- notifySetFormula(Cell) - Method in class org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
-
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
- notifySetFormula(Cell) - Method in interface org.apache.poi.ss.usermodel.FormulaEvaluator
-
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
- notifyUpdateCell(HSSFCell) - Method in class org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
-
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
- notifyUpdateCell(Cell) - Method in class org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
-
- notifyUpdateCell(EvaluationCell) - Method in class org.apache.poi.ss.formula.WorkbookEvaluator
-
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
- notifyUpdateCell(Cell) - Method in interface org.apache.poi.ss.usermodel.FormulaEvaluator
-
Should be called to tell the cell value cache that the specified (value or formula) cell
has changed.
- NotImplemented - Annotation Type in org.apache.poi.util
-
This feature has not been implemented yet.
- NotImplementedException - Exception in org.apache.poi.ss.formula.eval
-
An exception thrown by implementors of
FormulaEvaluator,
when attempting to evaluate a formula which requires features
that POI does not (yet) support.
- NotImplementedException(String) - Constructor for exception org.apache.poi.ss.formula.eval.NotImplementedException
-
- NotImplementedException(String, NotImplementedException) - Constructor for exception org.apache.poi.ss.formula.eval.NotImplementedException
-
- NotImplementedFunction - Class in org.apache.poi.ss.formula.functions
-
This is the default implementation of a Function class.
- NotImplementedFunction() - Constructor for class org.apache.poi.ss.formula.functions.NotImplementedFunction
-
- NotImplementedFunction(String) - Constructor for class org.apache.poi.ss.formula.functions.NotImplementedFunction
-
- NotImplementedFunctionException - Exception in org.apache.poi.ss.formula.eval
-
An exception thrown by implementors of
FormulaEvaluator when
attempting to evaluate a formula which requires a function that POI
does not (yet) support.
- NotImplementedFunctionException(String) - Constructor for exception org.apache.poi.ss.formula.eval.NotImplementedFunctionException
-
- NotImplementedFunctionException(String, NotImplementedException) - Constructor for exception org.apache.poi.ss.formula.eval.NotImplementedFunctionException
-
- NotOLE2FileException - Exception in org.apache.poi.poifs.filesystem
-
This exception is thrown when we try to open a file that doesn't
seem to actually be an OLE2 file after all
- NotOLE2FileException(String) - Constructor for exception org.apache.poi.poifs.filesystem.NotOLE2FileException
-
- NotPrimitive - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
-
- Now - Class in org.apache.poi.ss.formula.functions
-
Implementation of Excel NOW() Function
- Now() - Constructor for class org.apache.poi.ss.formula.functions.Now
-
- NPER - Static variable in class org.apache.poi.ss.formula.functions.FinanceFunction
-
- nper(double, double, double, double, boolean) - Static method in class org.apache.poi.ss.formula.functions.FinanceLib
-
- npv(double, double[]) - Static method in class org.apache.poi.ss.formula.functions.FinanceLib
-
calculates the Net Present Value of a principal amount
given the discount rate and a sequence of cash flows
(supplied as an array).
- Npv - Class in org.apache.poi.ss.formula.functions
-
Calculates the net present value of an investment by using a discount rate
and a series of future payments (negative values) and income (positive
values).
- Npv() - Constructor for class org.apache.poi.ss.formula.functions.Npv
-
- NULL - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
-
- NULL_INTERSECTION - Static variable in class org.apache.poi.ss.formula.eval.ErrorEval
-
#NULL! - Intersection of two cell ranges is empty
- NULL_INTERSECTION - Static variable in class org.apache.poi.ss.formula.ptg.ErrPtg
-
#NULL! - Intersection of two cell ranges is empty
- NullEscherSerializationListener - Class in org.apache.poi.ddf
-
Ignores all serialization events.
- NullEscherSerializationListener() - Constructor for class org.apache.poi.ddf.NullEscherSerializationListener
-
- num - Variable in enum org.apache.poi.ss.usermodel.IconMultiStateFormatting.IconSet
-
How many icons in the set
- NUM_ERROR - Static variable in class org.apache.poi.ss.formula.eval.ErrorEval
-
#NUM! - Value range overflow
- NUM_ERROR - Static variable in class org.apache.poi.ss.formula.ptg.ErrPtg
-
#NUM! - Value range overflow
- NumberComparer - Class in org.apache.poi.ss.util
-
- NumberComparer() - Constructor for class org.apache.poi.ss.util.NumberComparer
-
- numberError() - Static method in exception org.apache.poi.ss.formula.eval.EvaluationException
-
#NUM! - Value range overflow
- NumberEval - Class in org.apache.poi.ss.formula.eval
-
- NumberEval(Ptg) - Constructor for class org.apache.poi.ss.formula.eval.NumberEval
-
- NumberEval(double) - Constructor for class org.apache.poi.ss.formula.eval.NumberEval
-
- NumberFormatIndexRecord - Class in org.apache.poi.hssf.record.chart
-
The number format index record indexes format table.
- NumberFormatIndexRecord() - Constructor for class org.apache.poi.hssf.record.chart.NumberFormatIndexRecord
-
- NumberFormatIndexRecord(NumberFormatIndexRecord) - Constructor for class org.apache.poi.hssf.record.chart.NumberFormatIndexRecord
-
- NumberFormatIndexRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.NumberFormatIndexRecord
-
- NumberPtg - Class in org.apache.poi.ss.formula.ptg
-
Number Stores a floating point value in a formula value stored in a 8 byte
field using IEEE notation
- NumberPtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.NumberPtg
-
- NumberPtg(String) - Constructor for class org.apache.poi.ss.formula.ptg.NumberPtg
-
Create a NumberPtg from a string representation of the number Number
format is not checked, it is expected to be validated in the parser that
calls this method.
- NumberPtg(double) - Constructor for class org.apache.poi.ss.formula.ptg.NumberPtg
-
- NumberRecord - Class in org.apache.poi.hssf.record
-
NUMBER (0x0203) Contains a numeric cell value.
- NumberRecord() - Constructor for class org.apache.poi.hssf.record.NumberRecord
-
Creates new NumberRecord
- NumberRecord(NumberRecord) - Constructor for class org.apache.poi.hssf.record.NumberRecord
-
- NumberRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.NumberRecord
-
- NumberToTextConverter - Class in org.apache.poi.ss.util
-
Excel converts numbers to text with different rules to those of java, so
Double.toString(value) won't do.
- NumberValueFunction - Class in org.apache.poi.ss.formula.functions
-
/**
Implementation for the NUMBERVALUE() Excel function.
- NumericFunction - Class in org.apache.poi.ss.formula.functions
-
- NumericFunction() - Constructor for class org.apache.poi.ss.formula.functions.NumericFunction
-
- NumericValueEval - Interface in org.apache.poi.ss.formula.eval
-
- numFormattingRuns() - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
-
- numFormattingRuns() - Method in interface org.apache.poi.ss.usermodel.RichTextString
-
- numPages() - Static method in class org.apache.poi.hssf.usermodel.HeaderFooter
-