org.apache.poi.hssf.extractor
Class OldExcelExtractor

java.lang.Object
  org.apache.poi.hssf.extractor.OldExcelExtractor

All Implemented Interfaces:

java.io.Closeable

public class OldExcelExtractor
extends java.lang.Object
implements java.io.Closeable

A text extractor for old Excel files, which are too old for HSSFWorkbook to handle. This includes Excel 95, and very old (pre-OLE2) Excel files, such as Excel 4 files.

Returns much (but not all) of the textual content of the file, suitable for indexing by something like Apache Lucene, or used by Apache Tika, but not really intended for display to the user.

OldExcelExtractor

public OldExcelExtractor(java.io.InputStream input)
                  throws java.io.IOException

Throws:

java.io.IOException

OldExcelExtractor

public OldExcelExtractor(java.io.File f)
                  throws java.io.IOException

Throws:

java.io.IOException

OldExcelExtractor

public OldExcelExtractor(NPOIFSFileSystem fs)
                  throws java.io.IOException

Throws:

java.io.IOException

OldExcelExtractor

public OldExcelExtractor(DirectoryNode directory)
                  throws java.io.IOException

Throws:

java.io.IOException

main

public static void main(java.lang.String[] args)
                 throws java.io.IOException

Throws:

java.io.IOException

getBiffVersion

public int getBiffVersion()

The Biff version, largely corresponding to the Excel version

Returns:

the Biff version

getFileType

public int getFileType()

The kind of the file, one of BOFRecord.TYPE_WORKSHEET, BOFRecord.TYPE_CHART, BOFRecord.TYPE_EXCEL_4_MACRO or BOFRecord.TYPE_WORKSPACE_FILE

Returns:

the file type

getText

public java.lang.String getText()

Retrieves the text contents of the file, as best we can for these old file formats

Returns:

the text contents of the file

close

public void close()

Specified by:

close in interface java.io.Closeable

handleNumericCell

protected void handleNumericCell(java.lang.StringBuffer text,
                                 double value)