Package loci.poi.hssf.extractor
Class ExcelExtractor
java.lang.Object
loci.poi.POITextExtractor
loci.poi.hssf.extractor.ExcelExtractor
A text extractor for Excel files.
Returns the textual content of the file, suitable for
indexing by something like Lucene, but not really
intended for display to the user.
To turn an excel file into a CSV or similar, then see
the XLS2CSVmra example
-
Field Summary
Fields inherited from class loci.poi.POITextExtractor
document -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptiongetText()Retreives the text contents of the filevoidsetFormulasNotResults(boolean formulasNotResults) Should we return the formula itself, and not the result it produces? Default is falsevoidsetIncludeSheetNames(boolean includeSheetNames) Should sheet names be included? Default is true
-
Constructor Details
-
ExcelExtractor
-
ExcelExtractor
- Throws:
IOException
-
-
Method Details
-
setIncludeSheetNames
public void setIncludeSheetNames(boolean includeSheetNames) Should sheet names be included? Default is true -
setFormulasNotResults
public void setFormulasNotResults(boolean formulasNotResults) Should we return the formula itself, and not the result it produces? Default is false -
getText
Retreives the text contents of the file- Specified by:
getTextin classPOITextExtractor- Returns:
- All the text from the document
-