Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## 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.

Constructor Summary
`OldExcelExtractor(DirectoryNode directory)`
`OldExcelExtractor(java.io.File f)`
`OldExcelExtractor(java.io.InputStream input)`
`OldExcelExtractor(NPOIFSFileSystem fs)`

Method Summary
`void` | `close()`
`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
`protected void` | `handleNumericCell(java.lang.StringBuffer text, double value)`
`static void` | `main(java.lang.String[] args)`

Methods inherited from class java.lang.Object
`clone, equals, finalize, 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.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)

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.