Examples with XSSFBHyperlinksTable org.apache.poi.xssf.binary.XSSFBHyperlinksTable used on opensource projects

Example 1 with XSSFBHyperlinksTable

use of org.apache.poi.xssf.binary.XSSFBHyperlinksTable in project poi by apache.

the class XSSFBEventBasedExcelExtractor method getText.

/**
     * Processes the file and returns the text
     */
public String getText() {
    try {
        XSSFBSharedStringsTable strings = new XSSFBSharedStringsTable(getPackage());
        XSSFBReader xssfbReader = new XSSFBReader(getPackage());
        XSSFBStylesTable styles = xssfbReader.getXSSFBStylesTable();
        XSSFBReader.SheetIterator iter = (XSSFBReader.SheetIterator) xssfbReader.getSheetsData();
        StringBuffer text = new StringBuffer();
        SheetTextExtractor sheetExtractor = new SheetTextExtractor();
        XSSFBHyperlinksTable hyperlinksTable = null;
        while (iter.hasNext()) {
            InputStream stream = iter.next();
            if (getIncludeSheetNames()) {
                text.append(iter.getSheetName());
                text.append('\n');
            }
            if (handleHyperlinksInCells) {
                hyperlinksTable = new XSSFBHyperlinksTable(iter.getSheetPart());
            }
            XSSFBCommentsTable comments = getIncludeCellComments() ? iter.getXSSFBSheetComments() : null;
            processSheet(sheetExtractor, styles, comments, strings, stream);
            if (getIncludeHeadersFooters()) {
                sheetExtractor.appendHeaderText(text);
            }
            sheetExtractor.appendCellText(text);
            if (getIncludeTextBoxes()) {
                processShapes(iter.getShapes(), text);
            }
            if (getIncludeHeadersFooters()) {
                sheetExtractor.appendFooterText(text);
            }
            sheetExtractor.reset();
            stream.close();
        }
        return text.toString();
    } catch (IOException e) {
        LOGGER.log(POILogger.WARN, e);
        return null;
    } catch (SAXException se) {
        LOGGER.log(POILogger.WARN, se);
        return null;
    } catch (OpenXML4JException o4je) {
        LOGGER.log(POILogger.WARN, o4je);
        return null;
    }
}