public class XSSFBEventBasedExcelExtractor extends XSSFEventBasedExcelExtractor implements ExcelExtractor
XSSFEventBasedExcelExtractor.SheetTextExtractor
Modifier and Type | Field and Description |
---|---|
static XSSFRelation[] |
SUPPORTED_TYPES |
concatenatePhoneticRuns, container, formulasNotResults, includeCellComments, includeHeadersFooters, includeSheetNames, includeTextBoxes, locale, properties
Constructor and Description |
---|
XSSFBEventBasedExcelExtractor(OPCPackage container) |
XSSFBEventBasedExcelExtractor(java.lang.String path) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getText()
Processes the file and returns the text
|
static void |
main(java.lang.String[] args) |
void |
processSheet(XSSFSheetXMLHandler.SheetContentsHandler sheetContentsExtractor,
XSSFBStylesTable styles,
XSSFBCommentsTable comments,
SharedStrings strings,
java.io.InputStream sheetInputStream)
Processes the given sheet
|
void |
setFormulasNotResults(boolean formulasNotResults)
Should we return the formula itself, and not
the result it produces? Default is false
This is currently unsupported for xssfb
|
void |
setHandleHyperlinksInCells(boolean handleHyperlinksInCells) |
close, createSharedStringsTable, getCoreProperties, getCustomProperties, getExtendedProperties, getFormulasNotResults, getIncludeCellComments, getIncludeHeadersFooters, getIncludeSheetNames, getIncludeTextBoxes, getLocale, getPackage, processSheet, setConcatenatePhoneticRuns, setIncludeCellComments, setIncludeHeadersFooters, setIncludeSheetNames, setIncludeTextBoxes, setLocale
checkMaxTextSize, getDocument, getMetadataTextExtractor
setFilesystem
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
setIncludeCellComments, setIncludeHeadersFooters, setIncludeSheetNames
public static final XSSFRelation[] SUPPORTED_TYPES
public XSSFBEventBasedExcelExtractor(java.lang.String path) throws org.apache.xmlbeans.XmlException, OpenXML4JException, java.io.IOException
org.apache.xmlbeans.XmlException
OpenXML4JException
java.io.IOException
public XSSFBEventBasedExcelExtractor(OPCPackage container) throws org.apache.xmlbeans.XmlException, OpenXML4JException, java.io.IOException
org.apache.xmlbeans.XmlException
OpenXML4JException
java.io.IOException
public static void main(java.lang.String[] args) throws java.lang.Exception
java.lang.Exception
public void setHandleHyperlinksInCells(boolean handleHyperlinksInCells)
public void setFormulasNotResults(boolean formulasNotResults)
setFormulasNotResults
in interface ExcelExtractor
setFormulasNotResults
in class XSSFEventBasedExcelExtractor
formulasNotResults
- true
if the formula itself is returnedpublic void processSheet(XSSFSheetXMLHandler.SheetContentsHandler sheetContentsExtractor, XSSFBStylesTable styles, XSSFBCommentsTable comments, SharedStrings strings, java.io.InputStream sheetInputStream) throws java.io.IOException
java.io.IOException
public java.lang.String getText()
getText
in interface ExcelExtractor
getText
in class XSSFEventBasedExcelExtractor
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.