public class XSSFExcelExtractor extends java.lang.Object implements POIXMLTextExtractor, 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 |
---|---|
XSSFWorkbook |
getDocument()
Returns opened document
(返回打开的文档)
|
XSSFWorkbook |
getFilesystem() |
java.lang.String |
getText()
Retrieves the text contents of the file
(检索文件的文本内容)
|
boolean |
isCloseFilesystem() |
void |
setCloseFilesystem(boolean doCloseFilesystem) |
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(java.util.Locale locale)
What Locale should be used for formatting numbers (based on the styles applied to the cells)
(应该使用什么区域设置来格式化数字(基于应用于单元格的样式))
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
checkMaxTextSize, close, getCoreProperties, getCustomProperties, getExtendedProperties, getMetadataTextExtractor, getPackage
public static final XSSFRelation[] SUPPORTED_TYPES
public XSSFExcelExtractor(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 XSSFExcelExtractor(XSSFWorkbook workbook)
public void setIncludeSheetNames(boolean includeSheetNames)
setIncludeSheetNames
in interface
ExcelExtractor
(接口 ExcelExtractor 中的 setIncludeSheetNames)
includeSheetNames
-
true
if the sheet names should be included
(includeSheetNames - 如果应包含工作表名称,则为 true)
public void setFormulasNotResults(boolean formulasNotResults)
setFormulasNotResults
in interface
ExcelExtractor
(接口 ExcelExtractor 中的 setFormulasNotResults)
formulasNotResults
-
true
if the formula itself is returned
(formulasNotResults - 如果返回公式本身,则为 true)
public void setIncludeCellComments(boolean includeCellComments)
setIncludeCellComments
in interface
ExcelExtractor
(接口 ExcelExtractor 中的 setIncludeCellComments)
includeCellComments
-
true
if cell comments should be included
(includeCellComments - 如果应该包含单元格注释,则为 true)
public void setIncludeHeadersFooters(boolean includeHeadersFooters)
setIncludeHeadersFooters
in interface
ExcelExtractor
(接口 ExcelExtractor 中的 setIncludeHeadersFooters)
includeHeadersFooters
-
true
if headers and footers should be included
(includeHeadersFooters - 如果应该包含页眉和页脚,则为 true)
public void setIncludeTextBoxes(boolean includeTextBoxes)
includeTextBoxes
- True if textboxes should be included, false if not.
(includeTextBoxes - 如果应该包含文本框则为真,否则为假。)
public void setLocale(java.util.Locale locale)
public java.lang.String getText()
getText
in interface
POITextExtractor
(接口 POITextExtractor 中的 getText)
getText
in interface
ExcelExtractor
(接口 ExcelExtractor 中的 getText)
public XSSFWorkbook getDocument()
POIXMLTextExtractor
getDocument
in interface
POITextExtractor
(接口 POITextExtractor 中的 getDocument)
getDocument
in interface
POIXMLTextExtractor
(接口 POIXMLTextExtractor 中的 getDocument)
public void setCloseFilesystem(boolean doCloseFilesystem)
setCloseFilesystem
in interface
POITextExtractor
(接口 POITextExtractor 中的 setCloseFilesystem)
doCloseFilesystem
-
true
(default), if underlying resources/filesystem should be closed on
POITextExtractor.close()
(doCloseFilesystem - true(默认),如果底层资源/文件系统应该在 POITextExtractor.close() 上关闭)
public boolean isCloseFilesystem()
isCloseFilesystem
in interface
POITextExtractor
(接口 POITextExtractor 中的 isCloseFilesystem)
true
, if resources/filesystem should be closed on
POITextExtractor.close()
(true,如果资源/文件系统应该在 POITextExtractor.close() 上关闭)
public XSSFWorkbook getFilesystem()
getFilesystem
in interface
POITextExtractor
(接口 POITextExtractor 中的 getFilesystem)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.