Package org.apache.poi.xssf.extractor
Class XSSFEventBasedExcelExtractor
java.lang.Object
org.apache.poi.extractor.POITextExtractor
org.apache.poi.ooxml.extractor.POIXMLTextExtractor
org.apache.poi.xssf.extractor.XSSFEventBasedExcelExtractor
- All Implemented Interfaces:
Closeable,AutoCloseable,ExcelExtractor
- Direct Known Subclasses:
XSSFBEventBasedExcelExtractor
Implementation of a text extractor from OOXML Excel
files that uses SAX event based parsing.
-
Nested Class Summary
Nested Classes -
Field Summary
FieldsModifier and TypeFieldDescriptionprotected booleanprotected OPCPackageprotected booleanprotected booleanprotected booleanprotected booleanprotected booleanprotected Localeprotected POIXMLProperties -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoidclose()Allows to free resources of the Extractor as soon as it is not needed any more.protected SharedStringscreateSharedStringsTable(XSSFReader xssfReader, OPCPackage container) Returns the core document propertiesReturns the custom document propertiesReturns the extended document propertiesbooleanbooleanbooleanbooleanbooleanReturns the opened OPCPackage container.getText()Processes the file and returns the textstatic voidvoidprocessSheet(XSSFSheetXMLHandler.SheetContentsHandler sheetContentsExtractor, Styles styles, Comments comments, SharedStrings strings, InputStream sheetInputStream) Processes the given sheetvoidsetConcatenatePhoneticRuns(boolean concatenatePhoneticRuns) Concatenate text from <rPh> text elements in SharedStringsTable Default is true;voidsetFormulasNotResults(boolean formulasNotResults) Should we return the formula itself, and not the result it produces? Default is falsevoidsetIncludeCellComments(boolean includeCellComments) Should cell comments be included? Default is falsevoidsetIncludeHeadersFooters(boolean includeHeadersFooters) Should headers and footers be included? Default is truevoidsetIncludeSheetNames(boolean includeSheetNames) Should sheet names be included? Default is truevoidsetIncludeTextBoxes(boolean includeTextBoxes) Should text from textboxes be included? Default is truevoidMethods inherited from class org.apache.poi.ooxml.extractor.POIXMLTextExtractor
checkMaxTextSize, getDocument, getMetadataTextExtractorMethods inherited from class org.apache.poi.extractor.POITextExtractor
setFilesystem
-
Field Details
-
container
-
properties
-
locale
-
includeTextBoxes
protected boolean includeTextBoxes -
includeSheetNames
protected boolean includeSheetNames -
includeCellComments
protected boolean includeCellComments -
formulasNotResults
protected boolean formulasNotResults -
concatenatePhoneticRuns
protected boolean concatenatePhoneticRuns
-
-
Constructor Details
-
XSSFEventBasedExcelExtractor
public XSSFEventBasedExcelExtractor(String path) throws org.apache.xmlbeans.XmlException, OpenXML4JException, IOException - Throws:
org.apache.xmlbeans.XmlExceptionOpenXML4JExceptionIOException
-
XSSFEventBasedExcelExtractor
public XSSFEventBasedExcelExtractor(OPCPackage container) throws org.apache.xmlbeans.XmlException, OpenXML4JException, IOException - Throws:
org.apache.xmlbeans.XmlExceptionOpenXML4JExceptionIOException
-
-
Method Details
-
main
- Throws:
Exception
-
setIncludeSheetNames
public void setIncludeSheetNames(boolean includeSheetNames) Should sheet names be included? Default is true- Specified by:
setIncludeSheetNamesin interfaceExcelExtractor- Parameters:
includeSheetNames-trueif the sheet names should be included
-
getIncludeSheetNames
public boolean getIncludeSheetNames()- Returns:
- whether to include sheet names
- Since:
- 3.16-beta3
-
setFormulasNotResults
public void setFormulasNotResults(boolean formulasNotResults) Should we return the formula itself, and not the result it produces? Default is false- Specified by:
setFormulasNotResultsin interfaceExcelExtractor- Parameters:
formulasNotResults-trueif the formula itself is returned
-
getFormulasNotResults
public boolean getFormulasNotResults()- Returns:
- whether to include formulas but not results
- Since:
- 3.16-beta3
-
setIncludeTextBoxes
public void setIncludeTextBoxes(boolean includeTextBoxes) Should text from textboxes be included? Default is true -
getIncludeTextBoxes
public boolean getIncludeTextBoxes()- Returns:
- whether or not to extract textboxes
- Since:
- 3.16-beta3
-
setIncludeCellComments
public void setIncludeCellComments(boolean includeCellComments) Should cell comments be included? Default is false- Specified by:
setIncludeCellCommentsin interfaceExcelExtractor- Parameters:
includeCellComments-trueif cell comments should be included
-
getIncludeCellComments
public boolean getIncludeCellComments()- Returns:
- whether cell comments should be included
- Since:
- 3.16-beta3
-
setConcatenatePhoneticRuns
public void setConcatenatePhoneticRuns(boolean concatenatePhoneticRuns) Concatenate text from <rPh> text elements in SharedStringsTable Default is true;- Parameters:
concatenatePhoneticRuns- true if runs should be concatenated, false otherwise
-
setLocale
-
getLocale
- Returns:
- locale
- Since:
- 3.16-beta3
-
getPackage
Returns the opened OPCPackage container.- Overrides:
getPackagein classPOIXMLTextExtractor- Returns:
- the opened OPCPackage
-
getCoreProperties
Returns the core document properties- Overrides:
getCorePropertiesin classPOIXMLTextExtractor- Returns:
- the core document properties
-
getExtendedProperties
Returns the extended document properties- Overrides:
getExtendedPropertiesin classPOIXMLTextExtractor- Returns:
- the extended document properties
-
getCustomProperties
Returns the custom document properties- Overrides:
getCustomPropertiesin classPOIXMLTextExtractor- Returns:
- the custom document properties
-
getText
Processes the file and returns the text- Specified by:
getTextin interfaceExcelExtractor- Specified by:
getTextin classPOITextExtractor- Returns:
- All the text from the document
-
close
Description copied from class:POITextExtractorAllows to free resources of the Extractor as soon as it is not needed any more. This may include closing open file handles and freeing memory. The Extractor cannot be used after close has been called.- Specified by:
closein interfaceAutoCloseable- Specified by:
closein interfaceCloseable- Overrides:
closein classPOIXMLTextExtractor- Throws:
IOException
-