Examples with CTSheet org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet used on opensource projects

Example 1 with CTSheet

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet in project poi by apache.

the class HybridStreaming method main.

public static void main(String[] args) throws IOException, SAXException {
    InputStream sourceBytes = new FileInputStream("workbook.xlsx");
    XSSFWorkbook workbook = new XSSFWorkbook(sourceBytes) {

        /** Avoid DOM parse of large sheet */
        @Override
        public void parseSheet(java.util.Map<String, XSSFSheet> shIdMap, CTSheet ctSheet) {
            if (!SHEET_TO_STREAM.equals(ctSheet.getName())) {
                super.parseSheet(shIdMap, ctSheet);
            }
        }
    };
    // Having avoided a DOM-based parse of the sheet, we can stream it instead.
    ReadOnlySharedStringsTable strings = new ReadOnlySharedStringsTable(workbook.getPackage());
    new XSSFSheetXMLHandler(workbook.getStylesSource(), strings, createSheetContentsHandler(), false);
    workbook.close();
    sourceBytes.close();
}

Example 2 with CTSheet

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet in project poi by apache.

the class XSSFWorkbook method isSheetHidden.

@Override
public boolean isSheetHidden(int sheetIx) {
    validateSheetIndex(sheetIx);
    CTSheet ctSheet = sheets.get(sheetIx).sheet;
    return ctSheet.getState() == STSheetState.HIDDEN;
}

Example 3 with CTSheet

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet in project poi by apache.

the class XSSFWorkbook method getSheetVisibility.

@Override
public SheetVisibility getSheetVisibility(int sheetIx) {
    validateSheetIndex(sheetIx);
    final CTSheet ctSheet = sheets.get(sheetIx).sheet;
    final STSheetState.Enum state = ctSheet.getState();
    if (state == STSheetState.VISIBLE) {
        return SheetVisibility.VISIBLE;
    }
    if (state == STSheetState.HIDDEN) {
        return SheetVisibility.HIDDEN;
    }
    if (state == STSheetState.VERY_HIDDEN) {
        return SheetVisibility.VERY_HIDDEN;
    }
    throw new IllegalArgumentException("This should never happen");
}

Example 4 with CTSheet

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet in project poi by apache.

the class XSSFWorkbook method onDocumentRead.

@Override
protected void onDocumentRead() throws IOException {
    try {
        WorkbookDocument doc = WorkbookDocument.Factory.parse(getPackagePart().getInputStream(), DEFAULT_XML_OPTIONS);
        this.workbook = doc.getWorkbook();
        ThemesTable theme = null;
        Map<String, XSSFSheet> shIdMap = new HashMap<String, XSSFSheet>();
        Map<String, ExternalLinksTable> elIdMap = new HashMap<String, ExternalLinksTable>();
        for (RelationPart rp : getRelationParts()) {
            POIXMLDocumentPart p = rp.getDocumentPart();
            if (p instanceof SharedStringsTable) {
                sharedStringSource = (SharedStringsTable) p;
            } else if (p instanceof StylesTable) {
                stylesSource = (StylesTable) p;
            } else if (p instanceof ThemesTable) {
                theme = (ThemesTable) p;
            } else if (p instanceof CalculationChain) {
                calcChain = (CalculationChain) p;
            } else if (p instanceof MapInfo) {
                mapInfo = (MapInfo) p;
            } else if (p instanceof XSSFSheet) {
                shIdMap.put(rp.getRelationship().getId(), (XSSFSheet) p);
            } else if (p instanceof ExternalLinksTable) {
                elIdMap.put(rp.getRelationship().getId(), (ExternalLinksTable) p);
            }
        }
        boolean packageReadOnly = (getPackage().getPackageAccess() == PackageAccess.READ);
        if (stylesSource == null) {
            // Create Styles if it is missing
            if (packageReadOnly) {
                stylesSource = new StylesTable();
            } else {
                stylesSource = (StylesTable) createRelationship(XSSFRelation.STYLES, XSSFFactory.getInstance());
            }
        }
        stylesSource.setWorkbook(this);
        stylesSource.setTheme(theme);
        if (sharedStringSource == null) {
            // Create SST if it is missing
            if (packageReadOnly) {
                sharedStringSource = new SharedStringsTable();
            } else {
                sharedStringSource = (SharedStringsTable) createRelationship(XSSFRelation.SHARED_STRINGS, XSSFFactory.getInstance());
            }
        }
        // Load individual sheets. The order of sheets is defined by the order
        //  of CTSheet elements in the workbook
        sheets = new ArrayList<XSSFSheet>(shIdMap.size());
        for (CTSheet ctSheet : this.workbook.getSheets().getSheetArray()) {
            parseSheet(shIdMap, ctSheet);
        }
        // Load the external links tables. Their order is defined by the order 
        //  of CTExternalReference elements in the workbook
        externalLinks = new ArrayList<ExternalLinksTable>(elIdMap.size());
        if (this.workbook.isSetExternalReferences()) {
            for (CTExternalReference er : this.workbook.getExternalReferences().getExternalReferenceArray()) {
                ExternalLinksTable el = elIdMap.get(er.getId());
                if (el == null) {
                    logger.log(POILogger.WARN, "ExternalLinksTable with r:id " + er.getId() + " was defined, but didn't exist in package, skipping");
                    continue;
                }
                externalLinks.add(el);
            }
        }
        // Process the named ranges
        reprocessNamedRanges();
    } catch (XmlException e) {
        throw new POIXMLException(e);
    }
}

Example 5 with CTSheet

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet in project poi by apache.

the class XSSFWorkbook method setSheetVisibility.

@Override
public void setSheetVisibility(int sheetIx, SheetVisibility visibility) {
    validateSheetIndex(sheetIx);
    final CTSheet ctSheet = sheets.get(sheetIx).sheet;
    switch(visibility) {
        case VISIBLE:
            ctSheet.setState(STSheetState.VISIBLE);
            break;
        case HIDDEN:
            ctSheet.setState(STSheetState.HIDDEN);
            break;
        case VERY_HIDDEN:
            ctSheet.setState(STSheetState.VERY_HIDDEN);
            break;
        default:
            throw new IllegalArgumentException("This should never happen");
    }
}