You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.#ctor(NPOI.OpenXml4Net.OPC.PackagePart,NPOI.OpenXml4Net.OPC.PackageRelationship)
"
>
Creates an POIXMLDocumentPart representing the given namespace part and relationship.
Called by {@link #read(POIXMLFactory, java.util.Map)} when Reading in an exisiting file.
@param part - The namespace part that holds xml data represenring this sheet.
@param rel - the relationship of the given namespace part
@see #read(POIXMLFactory, java.util.Map)
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.#ctor(NPOI.POIXMLDocumentPart,NPOI.OpenXml4Net.OPC.PackagePart,NPOI.OpenXml4Net.OPC.PackageRelationship)
"
>
Creates an POIXMLDocumentPart representing the given namespace part, relationship and parent
Called by {@link #read(POIXMLFactory, java.util.Map)} when Reading in an exisiting file.
@param parent - Parent part
@param part - The namespace part that holds xml data represenring this sheet.
@param rel - the relationship of the given namespace part
@see #read(POIXMLFactory, java.util.Map)
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.Rebase(NPOI.OpenXml4Net.OPC.OPCPackage)
"
>
When you open something like a theme, call this to
re-base the XML Document onto the core child of the
current core document
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.GetPackagePart
"
>
Provides access to the underlying PackagePart
@return the underlying PackagePart
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.GetPackageRelationship
"
>
Provides access to the PackageRelationship that identifies this POIXMLDocumentPart
@return the PackageRelationship that identifies this POIXMLDocumentPart
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.GetRelations
"
>
Returns the list of child relations for this POIXMLDocumentPart
@return child relations
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.GetRelationById(System.String)
"
>
Returns the target {@link POIXMLDocumentPart}, where a
{@link PackageRelationship} is set from the {@link PackagePart} of this
{@link POIXMLDocumentPart} to the {@link PackagePart} of the target
{@link POIXMLDocumentPart} with a {@link PackageRelationship#GetId()}
matching the given parameter value.
@param id
The relation id to look for
@return the target part of the relation, or null, if none exists
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.GetRelationId(NPOI.POIXMLDocumentPart)
"
>
Returns the {@link PackageRelationship#GetId()} of the
{@link PackageRelationship}, that sources from the {@link PackagePart} of
this {@link POIXMLDocumentPart} to the {@link PackagePart} of the given
parameter value.
@param part
The {@link POIXMLDocumentPart} for which the according
relation-id shall be found.
@return The value of the {@link PackageRelationship#GetId()} or null, if
parts are not related.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.AddRelation(System.String,NPOI.POIXMLDocumentPart)
"
>
Add a new child POIXMLDocumentPart
@param part the child to add
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.RemoveRelation(NPOI.POIXMLDocumentPart)
"
>
Remove the relation to the specified part in this namespace and remove the
part, if it is no longer needed.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.RemoveRelation(NPOI.POIXMLDocumentPart,System.Boolean)
"
>
Remove the relation to the specified part in this namespace and remove the
part, if it is no longer needed and flag is set to true.
@param part
The related part, to which the relation shall be Removed.
@param RemoveUnusedParts
true, if the part shall be Removed from the namespace if not
needed any longer.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.GetParent
"
>
Returns the parent POIXMLDocumentPart. All parts except root have not-null parent.
@return the parent POIXMLDocumentPart or <
code
>null</
code
> for the root element.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.Commit
"
>
Save the content in the underlying namespace part.
Default implementation is empty meaning that the namespace part is left unmodified.
Sub-classes should override and add logic to marshal the "model" into Ooxml4J.
For example, the code saving a generic XML entry may look as follows:
<
pre
><
code
>
protected void commit() {
PackagePart part = GetPackagePart();
Stream out = part.GetStream();
XmlObject bean = GetXmlBean(); //the "model" which holds Changes in memory
bean.save(out, DEFAULT_XML_OPTIONS);
out.close();
}
</
code
></
pre
>
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.OnSave(System.Collections.Generic.List{NPOI.OpenXml4Net.OPC.PackagePart})
"
>
Save Changes in the underlying OOXML namespace.
Recursively fires {@link #commit()} for each namespace part
@param alreadySaved context set Containing already visited nodes
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.CreateRelationship(NPOI.POIXMLRelation,NPOI.POIXMLFactory)
"
>
Create a new child POIXMLDocumentPart
@param descriptor the part descriptor
@param factory the factory that will create an instance of the requested relation
@return the Created child POIXMLDocumentPart
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.CreateRelationship(NPOI.POIXMLRelation,NPOI.POIXMLFactory,System.Int32,System.Boolean)
"
>
Create a new child POIXMLDocumentPart
@param descriptor the part descriptor
@param factory the factory that will create an instance of the requested relation
@param idx part number
@param noRelation if true, then no relationship is Added.
@return the Created child POIXMLDocumentPart
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.Read(NPOI.POIXMLFactory,System.Collections.Generic.Dictionary{NPOI.OpenXml4Net.OPC.PackagePart,NPOI.POIXMLDocumentPart})
"
>
Iterate through the underlying PackagePart and create child POIXMLFactory instances
using the specified factory
@param factory the factory object that Creates POIXMLFactory instances
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.GetTargetPart(NPOI.OpenXml4Net.OPC.PackageRelationship)
"
>
Get the PackagePart that is the target of a relationship.
@param rel The relationship
@return The target part
@throws InvalidFormatException
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.OnDocumentCreate
"
>
Fired when a new namespace part is Created
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.OnDocumentRead
"
>
Fired when a namespace part is read
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocumentPart.onDocumentRemove
"
>
Fired when a namespace part is about to be Removed from the namespace
</
member
>
<
member
name
=
"
F:NPOI.POIXMLDocument.pkg
"
>
The OPC Package
</
member
>
<
member
name
=
"
F:NPOI.POIXMLDocument.properties
"
>
The properties of the OPC namespace, opened as needed
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocument.OpenPackage(System.String)
"
>
Wrapper to open a namespace, returning an IOException
in the event of a problem.
Works around shortcomings in java's this() constructor calls
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocument.GetRelatedByType(System.String)
"
>
Retrieves all the PackageParts which are defined as
relationships of the base document with the
specified content type.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocument.HasOOXMLHeader(System.IO.Stream)
"
>
Checks that the supplied Stream (which MUST
support mark and reSet, or be a PushbackStream)
has a OOXML (zip) header at the start of it.
If your Stream does not support mark / reSet,
then wrap it in a PushBackStream, then be
sure to always use that, and not the original!
@param inp An Stream which supports either mark/reSet, or is a PushbackStream
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocument.GetProperties
"
>
Get the document properties. This gives you access to the
core ooxml properties, and the extended ooxml properties.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocument.GetAllEmbedds
"
>
Get the document's embedded files.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLDocument.Write(System.IO.Stream)
"
>
Write out this document to an Outputstream.
@param stream - the java Stream you wish to write the file to
@exception IOException if anything can't be written.
</
member
>
<
member
name
=
"
T:NPOI.POIXMLFactory
"
>
Defines a factory API that enables sub-classes to create instances of <
code
>POIXMLDocumentPart</
code
>
@author Yegor Kozlov
</
member
>
<
member
name
=
"
M:NPOI.POIXMLFactory.CreateDocumentPart(NPOI.POIXMLDocumentPart,NPOI.OpenXml4Net.OPC.PackageRelationship,NPOI.OpenXml4Net.OPC.PackagePart)
"
>
Create a POIXMLDocumentPart from existing namespace part and relation. This method is called
from {@link POIXMLDocument#load(POIXMLFactory)} when parsing a document
@param parent parent part
@param rel the namespace part relationship
@param part the PackagePart representing the Created instance
@return A new instance of a POIXMLDocumentPart.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLFactory.CreateDocumentPart(NPOI.POIXMLRelation)
"
>
Create a new POIXMLDocumentPart using the supplied descriptor. This method is used when Adding new parts
to a document, for example, when Adding a sheet to a workbook, slide to a presentation, etc.
@param descriptor describes the object to create
@return A new instance of a POIXMLDocumentPart.
</
member
>
<
member
name
=
"
T:NPOI.CoreProperties
"
>
The core document properties
</
member
>
<
member
name
=
"
T:NPOI.ExtendedProperties
"
>
Extended document properties
</
member
>
<
member
name
=
"
T:NPOI.CustomProperties
"
>
Custom document properties
</
member
>
<
member
name
=
"
F:NPOI.CustomProperties.FORMAT_ID
"
>
Each custom property element Contains an fmtid attribute
with the same GUID value ({D5CDD505-2E9C-101B-9397-08002B2CF9AE}).
</
member
>
<
member
name
=
"
M:NPOI.CustomProperties.Add(System.String)
"
>
Add a new property
@param name the property name
@throws IllegalArgumentException if a property with this name already exists
</
member
>
<
member
name
=
"
M:NPOI.CustomProperties.AddProperty(System.String,System.String)
"
>
Add a new string property
@throws IllegalArgumentException if a property with this name already exists
</
member
>
<
member
name
=
"
M:NPOI.CustomProperties.AddProperty(System.String,System.Double)
"
>
Add a new double property
@throws IllegalArgumentException if a property with this name already exists
</
member
>
<
member
name
=
"
M:NPOI.CustomProperties.AddProperty(System.String,System.Int32)
"
>
Add a new integer property
@throws IllegalArgumentException if a property with this name already exists
</
member
>
<
member
name
=
"
M:NPOI.CustomProperties.AddProperty(System.String,System.Boolean)
"
>
Add a new bool property
@throws IllegalArgumentException if a property with this name already exists
</
member
>
<
member
name
=
"
M:NPOI.CustomProperties.NextPid
"
>
Generate next id that uniquely relates a custom property
@return next property id starting with 2
</
member
>
<
member
name
=
"
M:NPOI.CustomProperties.Contains(System.String)
"
>
Check if a property with this name already exists in the collection of custom properties
@param name the name to check
@return whether a property with the given name exists in the custom properties
</
member
>
<
member
name
=
"
T:NPOI.POIXMLProperties
"
>
Wrapper around the two different kinds of OOXML properties
a document can have
</
member
>
<
member
name
=
"
M:NPOI.POIXMLProperties.Commit
"
>
Commit Changes to the underlying OPC namespace
</
member
>
<
member
name
=
"
P:NPOI.POIXMLProperties.CoreProperties
"
>
Returns the core document properties
</
member
>
<
member
name
=
"
P:NPOI.POIXMLProperties.ExtendedProperties
"
>
Returns the extended document properties
</
member
>
<
member
name
=
"
P:NPOI.POIXMLProperties.CustomProperties
"
>
Returns the custom document properties
</
member
>
<
member
name
=
"
T:NPOI.POIXMLPropertiesTextExtractor
"
>
A {@link POITextExtractor} for returning the textual
content of the OOXML file properties, eg author
and title.
</
member
>
<
member
name
=
"
F:NPOI.POIXMLTextExtractor._document
"
>
The POIXMLDocument that's open
</
member
>
<
member
name
=
"
M:NPOI.POIXMLTextExtractor.#ctor(NPOI.POIXMLDocument)
"
>
Creates a new text extractor for the given document
</
member
>
<
member
name
=
"
M:NPOI.POIXMLTextExtractor.GetCoreProperties
"
>
Returns the core document properties
</
member
>
<
member
name
=
"
M:NPOI.POIXMLTextExtractor.GetExtendedProperties
"
>
Returns the extended document properties
</
member
>
<
member
name
=
"
M:NPOI.POIXMLTextExtractor.GetCustomProperties
"
>
Returns the custom document properties
</
member
>
<
member
name
=
"
P:NPOI.POIXMLTextExtractor.Document
"
>
Returns opened document
</
member
>
<
member
name
=
"
P:NPOI.POIXMLTextExtractor.Package
"
>
Returns the opened OPCPackage that Contains the document
</
member
>
<
member
name
=
"
P:NPOI.POIXMLTextExtractor.MetadataTextExtractor
"
>
Returns an OOXML properties text extractor for the
document properties metadata, such as title and author.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLPropertiesTextExtractor.#ctor(NPOI.POIXMLDocument)
"
>
Creates a new POIXMLPropertiesTextExtractor for the
given open document.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLPropertiesTextExtractor.#ctor(NPOI.POIXMLTextExtractor)
"
>
Creates a new POIXMLPropertiesTextExtractor, for the
same file that another TextExtractor is already
working on.
</
member
>
<
member
name
=
"
M:NPOI.POIXMLPropertiesTextExtractor.GetCorePropertiesText
"
>
Returns the core document properties, eg author
</
member
>
<
member
name
=
"
M:NPOI.POIXMLPropertiesTextExtractor.GetExtendedPropertiesText
"
>
Returns the extended document properties, eg
application
</
member
>
<
member
name
=
"
M:NPOI.POIXMLPropertiesTextExtractor.GetCustomPropertiesText
"
>
Returns the custom document properties, if
there are any
</
member
>
<
member
name
=
"
T:NPOI.POIXMLRelation
"
>
Represents a descriptor of a OOXML relation.
@author Yegor Kozlov
</
member
>
<
member
name
=
"
F:NPOI.POIXMLRelation._type
"
>
Describes the content stored in a part.
</
member
>
<
member
name
=
"
F:NPOI.POIXMLRelation._relation
"
>
The kind of connection between a source part and a target part in a namespace.
</
member
>
<
member
name
=
"
F:NPOI.POIXMLRelation._defaultName
"
>
The path component of a pack URI.
</
member
>
<
member
name
=
"
F:NPOI.POIXMLRelation._cls
"
>
Defines what object is used to construct instances of this relationship
</
member
>
<
member
name
=
"
M:NPOI.POIXMLRelation.#ctor(System.String,System.String,System.String,System.Type)
"
>
Instantiates a POIXMLRelation.
@param type content type
@param rel relationship
@param defaultName default item name
@param cls defines what object is used to construct instances of this relationship
</
member
>
<
member
name
=
"
M:NPOI.POIXMLRelation.#ctor(System.String,System.String,System.String)
"
>
Instantiates a POIXMLRelation.
@param type content type
@param rel relationship
@param defaultName default item name
</
member
>
<
member
name
=
"
M:NPOI.POIXMLRelation.GetFileName(System.Int32)
"
>
Returns the filename for the nth one of these,
e.g. /xl/comments4.xml
</
member
>
<
member
name
=
"
P:NPOI.POIXMLRelation.ContentType
"
>
Return the content type. Content types define a media type, a subtype, and an
optional set of parameters, as defined in RFC 2616.
@return the content type
</
member
>
<
member
name
=
"
P:NPOI.POIXMLRelation.Relation
"
>
Return the relationship, the kind of connection between a source part and a target part in a namespace.
Relationships make the connections between parts directly discoverable without looking at the content
in the parts, and without altering the parts themselves.
@return the relationship
</
member
>
<
member
name
=
"
P:NPOI.POIXMLRelation.DefaultFileName
"
>
Return the default part name. Part names are used to refer to a part in the context of a
namespace, typically as part of a URI.
@return the default part name
</
member
>
<
member
name
=
"
P:NPOI.POIXMLRelation.RelationClass
"
>
Return type of the obejct used to construct instances of this relationship
@return the class of the object used to construct instances of this relation
</
member
>
<
member
name
=
"
F:NPOI.SS.UserModel.ImportOption.SheetContentOnly
"
>
<
summary
>
Only Text and Formulas are imported. Pictures, Drawing, Styles etc. are all ignored.
</
summary
>
</
member
>
<
member
name
=
"
F:NPOI.SS.UserModel.ImportOption.TextOnly
"
>
<
summary
>
Only Text, Comments and Formulas are imported. Pictures, Drawing, Styles etc. are all ignored.
</
summary
>
</
member
>
<
member
name
=
"
F:NPOI.SS.UserModel.ImportOption.All
"
>
<
summary
>
Everything is imported - this is the same as NONE.
</
summary
>
</
member
>
<
member
name
=
"
T:NPOI.SS.UserModel.WorkbookFactory
"
>
<
summary
>
Factory for creating the appropriate kind of Workbook
(be it HSSFWorkbook or XSSFWorkbook), from the given input
</
summary
>
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.Create(NPOI.POIFS.FileSystem.POIFSFileSystem)
"
>
<
summary
>
Creates an HSSFWorkbook from the given POIFSFileSystem
</
summary
>
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.Create(NPOI.POIFS.FileSystem.NPOIFSFileSystem)
"
>
Creates an HSSFWorkbook from the given NPOIFSFileSystem
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.Create(NPOI.OpenXml4Net.OPC.OPCPackage)
"
>
<
summary
>
Creates an XSSFWorkbook from the given OOXML Package
</
summary
>
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.Create(System.IO.Stream)
"
>
<
summary
>
Creates the appropriate HSSFWorkbook / XSSFWorkbook from
the given InputStream. The Stream is wraped inside a PushbackInputStream.
</
summary
>
<
param
name
=
"
inputStream
"
>Input Stream of .xls or .xlsx file</
param
>
<
returns
>IWorkbook depending on the input HSSFWorkbook or XSSFWorkbook is returned.</
returns
>
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.Create(System.String)
"
>
Creates the appropriate HSSFWorkbook / XSSFWorkbook from
the given File, which must exist and be readable.
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.Create(System.IO.Stream,NPOI.SS.UserModel.ImportOption)
"
>
<
summary
>
Creates the appropriate HSSFWorkbook / XSSFWorkbook from
the given InputStream. The Stream is wraped inside a PushbackInputStream.
</
summary
>
<
param
name
=
"
inputStream
"
>Input Stream of .xls or .xlsx file</
param
>
<
param
name
=
"
importOption
"
>Customize the elements that are processed on the next import</
param
>
<
returns
>IWorkbook depending on the input HSSFWorkbook or XSSFWorkbook is returned.</
returns
>
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.CreateFormulaEvaluator(NPOI.SS.UserModel.IWorkbook)
"
>
<
summary
>
Creates a specific FormulaEvaluator for the given workbook.
</
summary
>
</
member
>
<
member
name
=
"
M:NPOI.SS.UserModel.WorkbookFactory.SetImportOption(NPOI.SS.UserModel.ImportOption)
"
>
<
summary
>
Sets the import option when opening the next workbook.
Works only for XSSF. For HSSF workbooks this option is ignored.
</
summary
>
<
param
name
=
"
importOption
"
>Customize the elements that are processed on the next import</
param
>
</
member
>
<
member
name
=
"
T:NPOI.Util.IdentifierManager
"
>
<
summary
>
24.08.2009 @author Stefan Stern
</
summary
>
</
member
>
<
member
name
=
"
F:NPOI.Util.IdentifierManager.upperbound
"
>
</
member
>
<
member
name
=
"
F:NPOI.Util.IdentifierManager.lowerbound
"
>
</
member
>
<
member
name
=
"
F:NPOI.Util.IdentifierManager.segments
"
>
List of segments of available identifiers
</
member
>
<
member
name
=
"
M:NPOI.Util.IdentifierManager.#ctor(System.Int64,System.Int64)
"
>
@param lowerbound the lower limit of the id-range to manage. Must be greater than or equal to {@link #MIN_ID}.
@param upperbound the upper limit of the id-range to manage. Must be less then or equal {@link #MAX_ID}.
</
member
>
<
member
name
=
"
M:NPOI.Util.IdentifierManager.ReserveNew
"
>
@return a new identifier.
@throws IllegalStateException if no more identifiers are available, then an Exception is raised.
</
member
>
<
member
name
=
"
M:NPOI.Util.IdentifierManager.Release(System.Int64)
"
>
@param id
the identifier to release. Must be greater than or equal to
{@link #lowerbound} and must be less than or equal to {@link #upperbound}
@return true, if the identifier was reserved and has been successfully
released, false, if the identifier was not reserved.
</
member
>
<
member
name
=
"
M:NPOI.Util.IdentifierManager.VerifyIdentifiersLeft
"
>
</
member
>
<
member
name
=
"
T:NPOI.Util.PackageHelper
"
>
Provides handy methods to work with OOXML namespaces
@author Yegor Kozlov
</
member
>
<
member
name
=
"
M:NPOI.Util.PackageHelper.Clone(NPOI.OpenXml4Net.OPC.OPCPackage,System.String)
"
>
Clone the specified namespace.
@param pkg the namespace to clone
@param file the destination file
@return the Cloned namespace
</
member
>
<
member
name
=
"
M:NPOI.Util.PackageHelper.CreateTempFile
"
>
Creates an empty file in the default temporary-file directory,
</
member
>
<
member
name
=
"
M:NPOI.Util.PackageHelper.Copy(NPOI.OpenXml4Net.OPC.OPCPackage,NPOI.OpenXml4Net.OPC.PackagePart,NPOI.OpenXml4Net.OPC.OPCPackage,NPOI.OpenXml4Net.OPC.PackagePart)
"
>
Recursively copy namespace parts to the destination namespace
</
member
>
<
member
name
=
"
M:NPOI.Util.PackageHelper.CopyProperties(NPOI.OpenXml4Net.OPC.PackageProperties,NPOI.OpenXml4Net.OPC.PackageProperties)
"
>
Copy core namespace properties
@param src source properties
@param tgt target properties
</
member
>
<
member
name
=
"
T:NPOI.Util.Units
"
>
@author Yegor Kozlov
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Extractor.XSSFExcelExtractor
"
>
Helper class to extract text from an OOXML Excel file
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExcelExtractor.SetIncludeSheetNames(System.Boolean)
"
>
Should sheet names be included? Default is true
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExcelExtractor.SetFormulasNotResults(System.Boolean)
"
>
Should we return the formula itself, and not
the result it produces? Default is false
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExcelExtractor.SetIncludeCellComments(System.Boolean)
"
>
Should cell comments be included? Default is true
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExcelExtractor.SetIncludeHeadersFooters(System.Boolean)
"
>
Should headers and footers be included? Default is true
</
member
>
<
member
name
=
"
P:NPOI.XSSF.Extractor.XSSFExcelExtractor.Text
"
>
Retreives the text contents of the file
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Extractor.XSSFExportToXml
"
>
Maps an XLSX to an XML according to one of the mapping defined.
The output XML Schema must respect this limitations:
<
ul
>
<
li
> all mandatory elements and attributes must be mapped (enable validation to check this)</
li
>
<
li
> no
<
any
>
in complex type/element declaration </
li
>
<
li
> no
<
anyAttribute
>
attributes declaration </
li
>
<
li
> no recursive structures: recursive structures can't be nested more than one level </
li
>
<
li
> no abstract elements: abstract complex types can be declared but must not be used in elements. </
li
>
<
li
> no mixed content: an element can't contain simple text and child element(s) together </
li
>
<
li
> no
<
substitutionGroup
>
in complex type/element declaration </
li
>
</
ul
>
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExportToXml.#ctor(NPOI.XSSF.UserModel.XSSFMap)
"
>
Creates a new exporter and Sets the mapping to be used when generating the XML output document
@param map the mapping rule to be used
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExportToXml.ExportToXML(System.IO.Stream,System.Boolean)
"
>
Exports the data in an XML stream
@param os OutputStream in which will contain the output XML
@param validate if true, validates the XML againts the XML Schema
@throws SAXException
@throws TransformerException
@throws ParserConfigurationException
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExportToXml.ExportToXML(System.IO.Stream,System.String,System.Boolean)
"
>
Exports the data in an XML stream
@param os OutputStream in which will contain the output XML
@param encoding the output charset encoding
@param validate if true, validates the XML againts the XML Schema
@throws SAXException
@throws ParserConfigurationException
@throws TransformerException
@throws InvalidFormatException
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExportToXml.IsValid(System.Xml.XmlDocument)
"
>
Validate the generated XML against the XML Schema associated with the XSSFMap
@param xml the XML to validate
@return
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Extractor.XSSFExportToXml.Compare(System.String,System.String)
"
>
Compares two xpaths to define an ordering according to the XML Schema
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Model.CalculationChain
"
>
The cells in a workbook can be calculated in different orders depending on various optimizations and
dependencies. The calculation chain object specifies the order in which the cells in a workbook were last calculated.
@author Yegor Kozlov
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.CalculationChain.RemoveItem(System.Int32,System.String)
"
>
Remove a formula reference from the calculation chain
@param sheetId the sheet Id of a sheet the formula belongs to.
@param ref A1 style reference to the cell Containing the formula.
</
member
>
<
member
name
=
"
F:NPOI.XSSF.Model.CommentsTable.commentRefs
"
>
XML Beans uses a list, which is very slow
to search, so we wrap things with our own
map for fast Lookup.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.CommentsTable.ReferenceUpdated(System.String,NPOI.OpenXmlFormats.Spreadsheet.CT_Comment)
"
>
Called after the reference is updated, so that
we can reflect that in our cache
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.CommentsTable.FindAuthor(System.String)
"
>
<
summary
>
Searches the author. If not found he is added to the list of authors.
</
summary
>
<
param
name
=
"
author
"
>author to search</
param
>
<
returns
>index of the author</
returns
>
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Model.IndexedUDFFinder
"
>
A UDFFinder that can retrieve functions both by name and by fake index.
@author Yegor Kozlov
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Model.MapInfo
"
>
This class : the Custom XML Mapping Part (Open Office XML Part 1:
chapter 12.3.6)
An instance of this part type Contains a schema for an XML file, and
information on the behavior that is used when allowing this custom XML schema
to be mapped into the spreadsheet.
@author Roberto Manicardi
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.MapInfo.GetCTMapInfo
"
>
@return the internal data object
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.MapInfo.GetCTSchemaById(System.String)
"
>
Gets the
@param schemaId the schema ID
@return CTSchema by it's ID
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.MapInfo.GetAllXSSFMaps
"
>
@return all the mappings configured in this document
</
member
>
<
member
name
=
"
P:NPOI.XSSF.Model.MapInfo.Workbook
"
>
Returns the parent XSSFWorkbook
@return the parent XSSFWorkbook
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Model.SharedStringsTable
"
>
Table of strings shared across all sheets in a workbook.
<
p
>
A workbook may contain thousands of cells Containing string (non-numeric) data. Furthermore this data is very
likely to be repeated across many rows or columns. The goal of implementing a single string table that is shared
across the workbook is to improve performance in opening and saving the file by only Reading and writing the
repetitive information once.
</
p
>
<
p
>
Consider for example a workbook summarizing information for cities within various countries. There may be a
column for the name of the country, a column for the name of each city in that country, and a column
Containing the data for each city. In this case the country name is repetitive, being duplicated in many cells.
In many cases the repetition is extensive, and a tremendous savings is realized by making use of a shared string
table when saving the workbook. When displaying text in the spreadsheet, the cell table will just contain an
index into the string table as the value of a cell, instead of the full string.
</
p
>
<
p
>
The shared string table Contains all the necessary information for displaying the string: the text, formatting
properties, and phonetic properties (for East Asian languages).
</
p
>
@author Nick Birch
@author Yegor Kozlov
</
member
>
<
member
name
=
"
F:NPOI.XSSF.Model.SharedStringsTable.strings
"
>
Array of individual string items in the Shared String table.
</
member
>
<
member
name
=
"
F:NPOI.XSSF.Model.SharedStringsTable.stmap
"
>
Maps strings and their indexes in the <
code
>strings</
code
> arrays
</
member
>
<
member
name
=
"
F:NPOI.XSSF.Model.SharedStringsTable.count
"
>
An integer representing the total count of strings in the workbook. This count does not
include any numbers, it counts only the total of text strings in the workbook.
</
member
>
<
member
name
=
"
F:NPOI.XSSF.Model.SharedStringsTable.uniqueCount
"
>
An integer representing the total count of unique strings in the Shared String Table.
A string is unique even if it is a copy of another string, but has different formatting applied
at the character level.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.SharedStringsTable.GetEntryAt(System.Int32)
"
>
Return a string item by index
@param idx index of item to return.
@return the item at the specified position in this Shared String table.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.SharedStringsTable.AddEntry(NPOI.OpenXmlFormats.Spreadsheet.CT_Rst)
"
>
Add an entry to this Shared String table (a new value is appened to the end).
<
p
>
If the Shared String table already Contains this <
code
>CT_Rst</
code
> bean, its index is returned.
Otherwise a new entry is aded.
</
p
>
@param st the entry to add
@return index the index of Added entry
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.SharedStringsTable.WriteTo(System.IO.Stream)
"
>
this table out as XML.
@param out The stream to write to.
@throws IOException if an error occurs while writing.
</
member
>
<
member
name
=
"
P:NPOI.XSSF.Model.SharedStringsTable.Count
"
>
Return an integer representing the total count of strings in the workbook. This count does not
include any numbers, it counts only the total of text strings in the workbook.
@return the total count of strings in the workbook
</
member
>
<
member
name
=
"
P:NPOI.XSSF.Model.SharedStringsTable.UniqueCount
"
>
Returns an integer representing the total count of unique strings in the Shared String Table.
A string is unique even if it is a copy of another string, but has different formatting applied
at the character level.
@return the total count of unique strings in the workbook
</
member
>
<
member
name
=
"
P:NPOI.XSSF.Model.SharedStringsTable.Items
"
>
Provide low-level access to the underlying array of CT_Rst beans
@return array of CT_Rst beans
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Model.SingleXmlCells
"
>
This class : the Single Cell Tables Part (Open Office XML Part 4:
chapter 3.5.2)
@author Roberto Manicardi
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.SingleXmlCells.GetAllSimpleXmlCell
"
>
@return all the SimpleXmlCell Contained in this SingleXmlCells element
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Model.StylesTable
"
>
Table of styles shared across all sheets in a workbook.
@author ugo
</
member
>
<
member
name
=
"
F:NPOI.XSSF.Model.StylesTable.FIRST_CUSTOM_STYLE_ID
"
>
The first style id available for use as a custom style
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.#ctor
"
>
Create a new, empty StylesTable
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.ReadFrom(System.Xml.XmlDocument)
"
>
Read this shared styles table from an XML file.
@param is The input stream Containing the XML document.
@throws IOException if an error occurs while Reading.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.PutFont(NPOI.XSSF.UserModel.XSSFFont,System.Boolean)
"
>
Records the given font in the font table.
Will re-use an existing font index if this
font matches another, EXCEPT if forced
registration is requested.
This allows people to create several fonts
then customise them later.
Note - End Users probably want to call
{@link XSSFFont#registerTo(StylesTable)}
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.GetNumCellStyles
"
>
get the size of cell styles
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.GetNumberFormatSize
"
>
For unit testing only
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.GetXfsSize
"
>
For unit testing only
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.GetStyleXfsSize
"
>
For unit testing only
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.GetCTStylesheet
"
>
For unit testing only!
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.WriteTo(System.IO.Stream)
"
>
Write this table out as XML.
@param out The stream to write to.
@throws IOException if an error occurs while writing.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.StylesTable.FindFont(System.Int16,System.Int16,System.Int16,System.String,System.Boolean,System.Boolean,NPOI.SS.UserModel.FontSuperScript,NPOI.SS.UserModel.FontUnderlineType)
"
>
Finds a font that matches the one with the supplied attributes
</
member
>
<
member
name
=
"
T:NPOI.XSSF.Model.ThemesTable
"
>
Class that represents theme of XLSX document. The theme includes specific
colors and fonts.
@author Petr Udalau(Petr.Udalau at exigenservices.com) - theme colors
</
member
>
<
member
name
=
"
M:NPOI.XSSF.Model.ThemesTable.InheritFromThemeAsRequired(NPOI.XSSF.UserModel.XSSFColor)
"
>
If the colour is based on a theme, then inherit
information (currently just colours) from it as
required.
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFChartAxis
"
>
Base class for all axis types.
@author Roman Kashitsyn
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFChartDataFactory
"
>
@author Roman Kashitsyn
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFChartDataFactory.CreateScatterChartData``2
"
>
@return new scatter chart data instance
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFChartDataFactory.GetInstance
"
>
@return factory instance
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFChartLegend
"
>
Represents a SpreadsheetML chart legend
@author Roman Kashitsyn
</
member
>
<
member
name
=
"
F:NPOI.XSSF.UserModel.Charts.XSSFChartLegend.legend
"
>
Underlaying CTLagend bean
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFChartLegend.#ctor(NPOI.XSSF.UserModel.XSSFChart)
"
>
Create a new SpreadsheetML chart legend
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFChartLegend.GetCTLegend
"
>
Return the underlying CTLegend bean.
@return the underlying CTLegend bean
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFChartUtil
"
>
Package private class with utility methods.
@author Roman Kashitsyn
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFChartUtil.BuildAxDataSource``1(NPOI.OpenXmlFormats.Dml.Chart.CT_AxDataSource,NPOI.SS.UserModel.Charts.IChartDataSource{``0})
"
>
Builds CTAxDataSource object content from POI ChartDataSource.
@param ctAxDataSource OOXML data source to build
@param dataSource POI data source to use
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFChartUtil.BuildNumDataSource``1(NPOI.OpenXmlFormats.Dml.Chart.CT_NumDataSource,NPOI.SS.UserModel.Charts.IChartDataSource{``0})
"
>
Builds CTNumDataSource object content from POI ChartDataSource
@param ctNumDataSource OOXML data source to build
@param dataSource POI data source to use
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFManualLayout
"
>
Represents a SpreadsheetML manual layout.
@author Roman Kashitsyn
</
member
>
<
member
name
=
"
F:NPOI.XSSF.UserModel.Charts.XSSFManualLayout.layout
"
>
Underlaying CTManualLayout bean.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFManualLayout.#ctor(NPOI.OpenXmlFormats.Dml.Chart.CT_Layout)
"
>
Create a new SpreadsheetML manual layout.
@param layout a Spreadsheet ML layout that should be used as base.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFManualLayout.#ctor(NPOI.XSSF.UserModel.XSSFChart)
"
>
Create a new SpreadsheetML manual layout for chart.
@param chart a chart to create layout for.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFManualLayout.GetCTManualLayout
"
>
Return the underlying CTManualLayout bean.
@return the underlying CTManualLayout bean.
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFScatterChartData`2
"
>
Represents DrawingML scatter chart.
@author Roman Kashitsyn
</
member
>
<
member
name
=
"
F:NPOI.XSSF.UserModel.Charts.XSSFScatterChartData`2.series
"
>
List of all data series.
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFScatterChartData`2.Serie
"
>
Package private ScatterChartSerie implementation.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFScatterChartData`2.Serie.GetXValues
"
>
Returns data source used for X axis values.
@return data source used for X axis values
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFScatterChartData`2.Serie.GetYValues
"
>
Returns data source used for Y axis values.
@return data source used for Y axis values
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFScatterChartData`2.Serie.SetUseCache(System.Boolean)
"
>
@param useCache if true, cached results will be Added on plot
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Charts.XSSFScatterChartData`2.Serie.AddToChart(NPOI.OpenXmlFormats.Dml.Chart.CT_ScatterChart)
"
>
<
summary
>
Returns last calculated number cache for Y axis.
</
summary
>
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Charts.XSSFValueAxis
"
>
Value axis type.
@author Roman Kashitsyn
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment
"
>
Cell Settings avaiable in the Format/Alignment tab
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment.#ctor(NPOI.OpenXmlFormats.Spreadsheet.CT_CellAlignment)
"
>
Creates a Cell Alignment from the supplied XML defInition
@param cellAlignment
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment.GetCTCellAlignment
"
>
Access to low-level data
</
member
>
<
member
name
=
"
P:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment.Vertical
"
>
Get the type of vertical alignment for the cell
@return the type of aligment
@see VerticalAlignment
</
member
>
<
member
name
=
"
P:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment.Horizontal
"
>
Get the type of horizontal alignment for the cell
@return the type of aligment
@see HorizontalAlignment
</
member
>
<
member
name
=
"
P:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment.Indent
"
>
Get the number of spaces to indent the text in the cell
@return indent - number of spaces
</
member
>
<!--
Badly formed XML comment ignored for member "P:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment.TextRotation"
-->
<
member
name
=
"
P:NPOI.XSSF.UserModel.Extensions.XSSFCellAlignment.WrapText
"
>
Whether the text should be wrapped
@return a bool value indicating if the text in a cell should be line-wrapped within the cell.
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Extensions.BorderSide
"
>
The enumeration value indicating the side being used for a cell border.
</
member
>
<
member
name
=
"
T:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder
"
>
This element Contains border formatting information, specifying border defInition formats (left, right, top, bottom, diagonal)
for cells in the workbook.
Color is optional.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.#ctor(NPOI.OpenXmlFormats.Spreadsheet.CT_Border,NPOI.XSSF.Model.ThemesTable)
"
>
Creates a Cell Border from the supplied XML defInition
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.#ctor(NPOI.OpenXmlFormats.Spreadsheet.CT_Border)
"
>
Creates a Cell Border from the supplied XML defInition
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.#ctor
"
>
Creates a new, empty Cell Border.
You need to attach this to the Styles Table
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.SetThemesTable(NPOI.XSSF.Model.ThemesTable)
"
>
Records the Themes Table that is associated with
the current font, used when looking up theme
based colours and properties.
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.GetCTBorder
"
>
Returns the underlying XML bean.
@return CT_Border
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.GetBorderStyle(NPOI.XSSF.UserModel.Extensions.BorderSide)
"
>
Get the type of border to use for the selected border
@param side - - where to apply the color defInition
@return borderstyle - the type of border to use. default value is NONE if border style is not Set.
@see BorderStyle
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.SetBorderStyle(NPOI.XSSF.UserModel.Extensions.BorderSide,NPOI.SS.UserModel.BorderStyle)
"
>
Set the type of border to use for the selected border
@param side - - where to apply the color defInition
@param style - border style
@see BorderStyle
</
member
>
<
member
name
=
"
M:NPOI.XSSF.UserModel.Extensions.XSSFCellBorder.GetBorderColor(NPOI.XSSF.UserModel.Extensions.BorderSide)
"
>