public class XSSFExcelExtractor extends org.apache.poi.ooxml.extractor.POIXMLTextExtractor implements ExcelExtractor
Modifier and Type | Field and Description |
---|---|
static XSSFRelation[] |
SUPPORTED_TYPES |
Constructor and Description |
---|
XSSFExcelExtractor(OPCPackage container) |
XSSFExcelExtractor(XSSFWorkbook workbook) |
Modifier and Type | Method and Description |
---|---|
String |
getText()
Retrieves the text contents of the file
|
static void |
main(String[] args) |
void |
setFormulasNotResults(boolean formulasNotResults)
Should we return the formula itself, and not
the result it produces? Default is false
|
void |
setIncludeCellComments(boolean includeCellComments)
Should cell comments be included? Default is false
|
void |
setIncludeHeadersFooters(boolean includeHeadersFooters)
Should headers and footers be included? Default is true
|
void |
setIncludeSheetNames(boolean includeSheetNames)
Should sheet names be included? Default is true
|
void |
setIncludeTextBoxes(boolean includeTextBoxes)
Should text within textboxes be included? Default is true
|
void |
setLocale(Locale locale)
What Locale should be used for formatting numbers (based
on the styles applied to the cells)
|
close, getCoreProperties, getCustomProperties, getDocument, getExtendedProperties, getMetadataTextExtractor, getPackage
setFilesystem
public static final XSSFRelation[] SUPPORTED_TYPES
public XSSFExcelExtractor(OPCPackage container) throws XmlException, OpenXML4JException, IOException
public XSSFExcelExtractor(XSSFWorkbook workbook)
public void setIncludeSheetNames(boolean includeSheetNames)
setIncludeSheetNames
in interface ExcelExtractor
includeSheetNames
- true
if the sheet names should be includedpublic void setFormulasNotResults(boolean formulasNotResults)
setFormulasNotResults
in interface ExcelExtractor
formulasNotResults
- true
if the formula itself is returnedpublic void setIncludeCellComments(boolean includeCellComments)
setIncludeCellComments
in interface ExcelExtractor
includeCellComments
- true
if cell comments should be includedpublic void setIncludeHeadersFooters(boolean includeHeadersFooters)
setIncludeHeadersFooters
in interface ExcelExtractor
includeHeadersFooters
- true
if headers and footers should be includedpublic void setIncludeTextBoxes(boolean includeTextBoxes)
includeTextBoxes
- True if textboxes should be included, false if not.public void setLocale(Locale locale)
public String getText()
getText
in interface ExcelExtractor
getText
in class POITextExtractor
Copyright © 2010 - 2020 Adobe. All Rights Reserved