org.apache.poi.hssf.extractor

Class OldExcelExtractor

java.lang.Object

org.apache.poi.hssf.extractor.OldExcelExtractor

public class OldExcelExtractor
extends java.lang.Object

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.

Constructor Summary

Constructors

Constructor and Description
OldExcelExtractor(DirectoryNode directory)
OldExcelExtractor(java.io.File f)
OldExcelExtractor(java.io.InputStream input)
OldExcelExtractor(NPOIFSFileSystem fs)

Method Summary

Modifier and Type	Method and Description
int	getBiffVersion() The Biff version, largely corresponding to the Excel version
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
java.lang.String	getText() Retrieves the text contents of the file, as best we can for these old file formats
static void	main(java.lang.String[] args)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

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

Method Detail

main

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

Throws:

java.lang.Exception

getBiffVersion

public int getBiffVersion()

The Biff version, largely corresponding to the Excel 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

getText

public java.lang.String getText()

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