public class XSSFBEventBasedExcelExtractor extends XSSFEventBasedExcelExtractor
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
(处理文件并返回文本)
|
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
(我们应该返回公式本身,而不是它产生的结果吗?默认为 false 这当前不支持 xssfb)
|
void |
setHandleHyperlinksInCells(boolean handleHyperlinksInCells) |
createSharedStringsTable, getCoreProperties, getCustomProperties, getDocument, getExtendedProperties, getFilesystem, getFormulasNotResults, getIncludeCellComments, getIncludeHeadersFooters, getIncludeSheetNames, getIncludeTextBoxes, getLocale, getPackage, isCloseFilesystem, processSheet, setCloseFilesystem, setConcatenatePhoneticRuns, setIncludeCellComments, setIncludeHeadersFooters, setIncludeSheetNames, setIncludeTextBoxes, setLocale
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
checkMaxTextSize, close, getMetadataTextExtractor
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
(org.apache.xmlbeans.XmlException)
OpenXML4JException
(OpenXML4JException)
java.io.IOException
(java.io.IOException)
public XSSFBEventBasedExcelExtractor(OPCPackage container) throws org.apache.xmlbeans.XmlException, OpenXML4JException, java.io.IOException
org.apache.xmlbeans.XmlException
(org.apache.xmlbeans.XmlException)
OpenXML4JException
(OpenXML4JException)
java.io.IOException
(java.io.IOException)
public void setHandleHyperlinksInCells(boolean handleHyperlinksInCells)
public void setFormulasNotResults(boolean formulasNotResults)
setFormulasNotResults
in interface
ExcelExtractor
(接口 ExcelExtractor 中的 setFormulasNotResults)
setFormulasNotResults
in class
XSSFEventBasedExcelExtractor
formulasNotResults
-
true
if the formula itself is returned
(formulasNotResults - 如果返回公式本身,则为 true)
public void processSheet(XSSFSheetXMLHandler.SheetContentsHandler sheetContentsExtractor, XSSFBStylesTable styles, XSSFBCommentsTable comments, SharedStrings strings, java.io.InputStream sheetInputStream) throws java.io.IOException
java.io.IOException
(java.io.IOException)
public java.lang.String getText()
getText
in interface
POITextExtractor
(接口 POITextExtractor 中的 getText)
getText
in interface
ExcelExtractor
(接口 ExcelExtractor 中的 getText)
getText
in class
XSSFEventBasedExcelExtractor
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.