Class XSSFExcelExtractor

    • Field Detail

      • SUPPORTED_TYPES

        public static final XSSFRelation[] SUPPORTED_TYPES
    • Constructor Detail

      • XSSFExcelExtractor

        public XSSFExcelExtractor​(OPCPackage container)
                           throws org.apache.xmlbeans.XmlException,
                                  OpenXML4JException,
                                  java.io.IOException
        Throws:
        org.apache.xmlbeans.XmlException
        OpenXML4JException
        java.io.IOException
      • XSSFExcelExtractor

        public XSSFExcelExtractor​(XSSFWorkbook workbook)
    • Method Detail

      • main

        public static void main​(java.lang.String[] args)
                         throws java.lang.Exception
        Throws:
        java.lang.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​(java.util.Locale locale)
        What Locale should be used for formatting numbers (based on the styles applied to the cells)
      • getText

        public java.lang.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