|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.apache.poi.POITextExtractor org.apache.poi.POIXMLTextExtractor org.apache.poi.xssf.extractor.XSSFExcelExtractor
public class XSSFExcelExtractor
Helper class to extract text from an OOXML Excel file
Field Summary | |
---|---|
static XSSFRelation[] |
SUPPORTED_TYPES
|
Fields inherited from class org.apache.poi.POITextExtractor |
---|
document |
Constructor Summary | |
---|---|
XSSFExcelExtractor(OPCPackage container)
|
|
XSSFExcelExtractor(java.lang.String path)
Deprecated. Use XSSFExcelExtractor(org.apache.poi.openxml4j.opc.OPCPackage) instead. |
|
XSSFExcelExtractor(XSSFWorkbook workbook)
|
Method Summary | |
---|---|
java.lang.String |
getText()
Retreives the text contents of the file |
static void |
main(java.lang.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 true |
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 |
setLocale(java.util.Locale locale)
What Locale should be used for formatting numbers (based on the styles applied to the cells) |
Methods inherited from class org.apache.poi.POIXMLTextExtractor |
---|
getCoreProperties, getCustomProperties, getDocument, getExtendedProperties, getMetadataTextExtractor, getPackage |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final XSSFRelation[] SUPPORTED_TYPES
Constructor Detail |
---|
public XSSFExcelExtractor(java.lang.String path) throws org.apache.xmlbeans.XmlException, OpenXML4JException, java.io.IOException
XSSFExcelExtractor(org.apache.poi.openxml4j.opc.OPCPackage)
instead.
org.apache.xmlbeans.XmlException
OpenXML4JException
java.io.IOException
public XSSFExcelExtractor(OPCPackage container) throws org.apache.xmlbeans.XmlException, OpenXML4JException, java.io.IOException
org.apache.xmlbeans.XmlException
OpenXML4JException
java.io.IOException
public XSSFExcelExtractor(XSSFWorkbook workbook)
Method Detail |
---|
public static void main(java.lang.String[] args) throws java.lang.Exception
java.lang.Exception
public void setIncludeSheetNames(boolean includeSheetNames)
setIncludeSheetNames
in interface ExcelExtractor
public void setFormulasNotResults(boolean formulasNotResults)
setFormulasNotResults
in interface ExcelExtractor
public void setIncludeCellComments(boolean includeCellComments)
setIncludeCellComments
in interface ExcelExtractor
public void setIncludeHeadersFooters(boolean includeHeadersFooters)
public void setLocale(java.util.Locale locale)
public java.lang.String getText()
getText
in interface ExcelExtractor
getText
in class POITextExtractor
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |