Class XSSFExcelExtractor

All Implemented Interfaces:
Closeable, AutoCloseable, ExcelExtractor

public class XSSFExcelExtractor extends POIXMLTextExtractor implements ExcelExtractor
Helper class to extract text from an OOXML Excel file
  • Field Details

    • SUPPORTED_TYPES

      public static final XSSFRelation[] SUPPORTED_TYPES
  • Constructor Details

  • Method Details

    • main

      public static void main(String[] args) throws Exception
      Throws:
      Exception
    • setIncludeSheetNames

      public void setIncludeSheetNames(boolean includeSheetNames)
      Should sheet names be included? Default is true
      Specified by:
      setIncludeSheetNames in interface ExcelExtractor
      Parameters:
      includeSheetNames - true if the sheet names should be included
    • setFormulasNotResults

      public void setFormulasNotResults(boolean formulasNotResults)
      Should we return the formula itself, and not the result it produces? Default is false
      Specified by:
      setFormulasNotResults in interface ExcelExtractor
      Parameters:
      formulasNotResults - true if the formula itself is returned
    • setIncludeCellComments

      public void setIncludeCellComments(boolean includeCellComments)
      Should cell comments be included? Default is false
      Specified by:
      setIncludeCellComments in interface ExcelExtractor
      Parameters:
      includeCellComments - true if cell comments should be included
    • setIncludeHeadersFooters

      public void setIncludeHeadersFooters(boolean includeHeadersFooters)
      Should headers and footers be included? Default is true
      Specified by:
      setIncludeHeadersFooters in interface ExcelExtractor
      Parameters:
      includeHeadersFooters - true if headers and footers should be included
    • setIncludeTextBoxes

      public void setIncludeTextBoxes(boolean includeTextBoxes)
      Should text within textboxes be included? Default is true
      Parameters:
      includeTextBoxes - True if textboxes should be included, false if not.
    • setLocale

      public void setLocale(Locale locale)
      What Locale should be used for formatting numbers (based on the styles applied to the cells)
    • getText

      public String getText()
      Retrieves the text contents of the file
      Specified by:
      getText in interface ExcelExtractor
      Specified by:
      getText in class POITextExtractor
      Returns:
      All the text from the document