|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.POITextExtractor
org.apache.poi.POIOLE2TextExtractor
org.apache.poi.hssf.extractor.ExcelExtractor
public class 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
XLS2CSVmra
Field Summary |
---|
Fields inherited from class org.apache.poi.POITextExtractor |
---|
document |
Constructor Summary | |
---|---|
ExcelExtractor(HSSFWorkbook wb)
|
|
ExcelExtractor(POIFSFileSystem fs)
|
Method Summary | |
---|---|
java.lang.String |
getText()
Retreives the text contents of the file |
void |
setFormulasNotResults(boolean formulasNotResults)
Should we return the formula itself, and not the result it produces? Default is false |
void |
setIncludeBlankCells(boolean includeBlankCells)
Should blank cells be output? Default is to only output cells that are present in the file and are non-blank. |
void |
setIncludeCellComments(boolean includeCellComments)
Should cell comments be included? Default is false |
void |
setIncludeSheetNames(boolean includeSheetNames)
Should sheet names be included? Default is true |
Methods inherited from class org.apache.poi.POIOLE2TextExtractor |
---|
getDocSummaryInformation, getMetadataTextExtractor, getSummaryInformation |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public ExcelExtractor(HSSFWorkbook wb)
public ExcelExtractor(POIFSFileSystem fs) throws java.io.IOException
java.io.IOException
Method Detail |
---|
public void setIncludeSheetNames(boolean includeSheetNames)
public void setFormulasNotResults(boolean formulasNotResults)
public void setIncludeCellComments(boolean includeCellComments)
public void setIncludeBlankCells(boolean includeBlankCells)
public java.lang.String getText()
getText
in class POITextExtractor
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |