OpenXmlSdkTs - v1.0.8
    Preparing search index...

    Class S

    SpreadsheetML namespace — element and attribute names for Excel documents.

    Covers the http://schemas.openxmlformats.org/spreadsheetml/2006/main namespace. Contains XName constants for elements like sheetData, row, c, v, worksheet, and hundreds more.

    import { S, NoNamespace } from "openxmlsdkts";

    const sheetData = xDoc.root!.element(S.sheetData);
    const rows = sheetData!.elements(S.row);
    for (const row of rows) {
    for (const cell of row.elements(S.c)) {
    const ref = cell.attribute(NoNamespace.r)?.value;
    const val = cell.element(S.v)?.value;
    }
    }
    Index

    Constructors

    Properties

    namespace alignment anchor author authors autoFilter autoSortScope b bgColor bk border borders bottom brk c cacheField cacheFields cacheHierarchies cacheHierarchy cacheSource calcChain calcPr calculatedColumnFormula calculatedItem calculatedItems calculatedMember calculatedMembers cell cellMetadata cellSmartTag cellSmartTagPr cellSmartTags cellStyle cellStyles cellStyleXfs cellWatch cellWatches cellXfs cfRule cfvo charset chartFormat chartFormats chartsheet col colBreaks colFields colHierarchiesUsage colHierarchyUsage colItems color colorFilter colors colorScale cols comment commentList comments condense conditionalFormat conditionalFormats conditionalFormatting connection connections consolidation control controlPr controls customFilter customFilters customPr customProperties customSheetView customSheetViews d dataBar dataConsolidate dataField dataFields dataRef dataRefs dataValidation dataValidations dateGroupItem dbPr ddeItem ddeItems ddeLink definedName definedNames deletedField diagonal dialogsheet dimension dimensions discretePr drawing dxf dxfs dynamicFilter e entries evenFooter evenHeader ext extend externalBook externalLink extLst f family fgColor field fieldGroup fieldsUsage fieldUsage fill fills filter filterColumn filters firstFooter firstHeader font fonts foo format formats formula formula1 formula2 from futureMetadata gradientFill group groupItems groupLevel groupLevels groupMember groupMembers groups header headerFooter headers horizontal hyperlink hyperlinks i iconFilter iconSet ignoredError ignoredErrors indexedColors inputCells _is item items k kpi kpis left legacyDrawing legacyDrawingHF location m main map maps mdx mdxMetadata measureGroup measureGroups member members mergeCell mergeCells metadata metadataStrings metadataType metadataTypes mp mpMap mps mruColors ms n _name nc ndxf numFmt numFmts objectPr oc oddFooter oddHeader odxf olapPr oldFormula oleItem oleItems oleLink oleObject oleObjects outline outlinePr p page pageField pageFields pageItem pageMargins pages pageSetup pageSetUpPr pane parameter parameters patternFill phoneticPr picture pivotArea pivotAreas pivotCache pivotCacheDefinition pivotCacheRecords pivotCaches pivotField pivotFields pivotHierarchies pivotHierarchy pivotSelection pivotTableDefinition pivotTableStyleInfo printOptions protectedRange protectedRanges protection query queryCache queryTable queryTableDeletedFields queryTableField queryTableFields queryTableRefresh r raf rangePr rangeSet rangeSets rc rcc rcft rcmt rcv rdn reference references reviewed reviewedList revisions rfmt rFont rgbColor right ris rm row rowBreaks rowFields rowHierarchiesUsage rowHierarchyUsage rowItems rPh rPr rqt rrc rsnm _s scenario scenarios scheme selection serverFormat serverFormats set sets shadow sharedItems sheet sheetCalcPr sheetData sheetDataSet sheetFormatPr sheetId sheetIdMap sheetName sheetNames sheetPr sheetProtection sheets sheetView sheetViews si singleXmlCell singleXmlCells smartTags sortByTuple sortCondition sortState sst stop stp strike styleSheet sz t tabColor table tableColumn tableColumns tablePart tableParts tables tableStyle tableStyleElement tableStyleInfo tableStyles text textField textFields textPr to top top10 totalsRowFormula tp tpl tpls tr tupleCache u undo userInfo users v val value valueMetadata values vertAlign vertical volType volTypes webPr webPublishItem webPublishItems worksheet worksheetEx14 worksheetSource x xf xmlCellPr xmlColumnPr xmlPr

    Constructors

    • Returns S

    Properties

    namespace: XNamespace = ...
    alignment: XName = ...
    anchor: XName = ...
    author: XName = ...
    authors: XName = ...
    autoFilter: XName = ...
    autoSortScope: XName = ...
    b: XName = ...
    bgColor: XName = ...
    bk: XName = ...
    border: XName = ...
    borders: XName = ...
    bottom: XName = ...
    brk: XName = ...
    c: XName = ...
    cacheField: XName = ...
    cacheFields: XName = ...
    cacheHierarchies: XName = ...
    cacheHierarchy: XName = ...
    cacheSource: XName = ...
    calcChain: XName = ...
    calcPr: XName = ...
    calculatedColumnFormula: XName = ...
    calculatedItem: XName = ...
    calculatedItems: XName = ...
    calculatedMember: XName = ...
    calculatedMembers: XName = ...
    cell: XName = ...
    cellMetadata: XName = ...
    cellSmartTag: XName = ...
    cellSmartTagPr: XName = ...
    cellSmartTags: XName = ...
    cellStyle: XName = ...
    cellStyles: XName = ...
    cellStyleXfs: XName = ...
    cellWatch: XName = ...
    cellWatches: XName = ...
    cellXfs: XName = ...
    cfRule: XName = ...
    cfvo: XName = ...
    charset: XName = ...
    chartFormat: XName = ...
    chartFormats: XName = ...
    chartsheet: XName = ...
    col: XName = ...
    colBreaks: XName = ...
    colFields: XName = ...
    colHierarchiesUsage: XName = ...
    colHierarchyUsage: XName = ...
    colItems: XName = ...
    color: XName = ...
    colorFilter: XName = ...
    colors: XName = ...
    colorScale: XName = ...
    cols: XName = ...
    comment: XName = ...
    commentList: XName = ...
    comments: XName = ...
    condense: XName = ...
    conditionalFormat: XName = ...
    conditionalFormats: XName = ...
    conditionalFormatting: XName = ...
    connection: XName = ...
    connections: XName = ...
    consolidation: XName = ...
    control: XName = ...
    controlPr: XName = ...
    controls: XName = ...
    customFilter: XName = ...
    customFilters: XName = ...
    customPr: XName = ...
    customProperties: XName = ...
    customSheetView: XName = ...
    customSheetViews: XName = ...
    d: XName = ...
    dataBar: XName = ...
    dataConsolidate: XName = ...
    dataField: XName = ...
    dataFields: XName = ...
    dataRef: XName = ...
    dataRefs: XName = ...
    dataValidation: XName = ...
    dataValidations: XName = ...
    dateGroupItem: XName = ...
    dbPr: XName = ...
    ddeItem: XName = ...
    ddeItems: XName = ...
    ddeLink: XName = ...
    definedName: XName = ...
    definedNames: XName = ...
    deletedField: XName = ...
    diagonal: XName = ...
    dialogsheet: XName = ...
    dimension: XName = ...
    dimensions: XName = ...
    discretePr: XName = ...
    drawing: XName = ...
    dxf: XName = ...
    dxfs: XName = ...
    dynamicFilter: XName = ...
    e: XName = ...
    entries: XName = ...
    evenFooter: XName = ...
    evenHeader: XName = ...
    ext: XName = ...
    extend: XName = ...
    externalBook: XName = ...
    externalLink: XName = ...
    extLst: XName = ...
    f: XName = ...
    family: XName = ...
    fgColor: XName = ...
    field: XName = ...
    fieldGroup: XName = ...
    fieldsUsage: XName = ...
    fieldUsage: XName = ...
    fill: XName = ...
    fills: XName = ...
    filter: XName = ...
    filterColumn: XName = ...
    filters: XName = ...
    firstFooter: XName = ...
    firstHeader: XName = ...
    font: XName = ...
    fonts: XName = ...
    foo: XName = ...
    format: XName = ...
    formats: XName = ...
    formula: XName = ...
    formula1: XName = ...
    formula2: XName = ...
    from: XName = ...
    futureMetadata: XName = ...
    gradientFill: XName = ...
    group: XName = ...
    groupItems: XName = ...
    groupLevel: XName = ...
    groupLevels: XName = ...
    groupMember: XName = ...
    groupMembers: XName = ...
    groups: XName = ...
    header: XName = ...
    headerFooter: XName = ...
    headers: XName = ...
    horizontal: XName = ...
    hyperlink: XName = ...
    hyperlinks: XName = ...
    i: XName = ...
    iconFilter: XName = ...
    iconSet: XName = ...
    ignoredError: XName = ...
    ignoredErrors: XName = ...
    indexedColors: XName = ...
    inputCells: XName = ...
    _is: XName = ...
    item: XName = ...
    items: XName = ...
    k: XName = ...
    kpi: XName = ...
    kpis: XName = ...
    left: XName = ...
    legacyDrawing: XName = ...
    legacyDrawingHF: XName = ...
    location: XName = ...
    m: XName = ...
    main: XName = ...
    map: XName = ...
    maps: XName = ...
    mdx: XName = ...
    mdxMetadata: XName = ...
    measureGroup: XName = ...
    measureGroups: XName = ...
    member: XName = ...
    members: XName = ...
    mergeCell: XName = ...
    mergeCells: XName = ...
    metadata: XName = ...
    metadataStrings: XName = ...
    metadataType: XName = ...
    metadataTypes: XName = ...
    mp: XName = ...
    mpMap: XName = ...
    mps: XName = ...
    mruColors: XName = ...
    ms: XName = ...
    n: XName = ...
    _name: XName = ...
    nc: XName = ...
    ndxf: XName = ...
    numFmt: XName = ...
    numFmts: XName = ...
    objectPr: XName = ...
    oc: XName = ...
    oddFooter: XName = ...
    oddHeader: XName = ...
    odxf: XName = ...
    olapPr: XName = ...
    oldFormula: XName = ...
    oleItem: XName = ...
    oleItems: XName = ...
    oleLink: XName = ...
    oleObject: XName = ...
    oleObjects: XName = ...
    outline: XName = ...
    outlinePr: XName = ...
    p: XName = ...
    page: XName = ...
    pageField: XName = ...
    pageFields: XName = ...
    pageItem: XName = ...
    pageMargins: XName = ...
    pages: XName = ...
    pageSetup: XName = ...
    pageSetUpPr: XName = ...
    pane: XName = ...
    parameter: XName = ...
    parameters: XName = ...
    patternFill: XName = ...
    phoneticPr: XName = ...
    picture: XName = ...
    pivotArea: XName = ...
    pivotAreas: XName = ...
    pivotCache: XName = ...
    pivotCacheDefinition: XName = ...
    pivotCacheRecords: XName = ...
    pivotCaches: XName = ...
    pivotField: XName = ...
    pivotFields: XName = ...
    pivotHierarchies: XName = ...
    pivotHierarchy: XName = ...
    pivotSelection: XName = ...
    pivotTableDefinition: XName = ...
    pivotTableStyleInfo: XName = ...
    printOptions: XName = ...
    protectedRange: XName = ...
    protectedRanges: XName = ...
    protection: XName = ...
    query: XName = ...
    queryCache: XName = ...
    queryTable: XName = ...
    queryTableDeletedFields: XName = ...
    queryTableField: XName = ...
    queryTableFields: XName = ...
    queryTableRefresh: XName = ...
    r: XName = ...
    raf: XName = ...
    rangePr: XName = ...
    rangeSet: XName = ...
    rangeSets: XName = ...
    rc: XName = ...
    rcc: XName = ...
    rcft: XName = ...
    rcmt: XName = ...
    rcv: XName = ...
    rdn: XName = ...
    reference: XName = ...
    references: XName = ...
    reviewed: XName = ...
    reviewedList: XName = ...
    revisions: XName = ...
    rfmt: XName = ...
    rFont: XName = ...
    rgbColor: XName = ...
    right: XName = ...
    ris: XName = ...
    rm: XName = ...
    row: XName = ...
    rowBreaks: XName = ...
    rowFields: XName = ...
    rowHierarchiesUsage: XName = ...
    rowHierarchyUsage: XName = ...
    rowItems: XName = ...
    rPh: XName = ...
    rPr: XName = ...
    rqt: XName = ...
    rrc: XName = ...
    rsnm: XName = ...
    _s: XName = ...
    scenario: XName = ...
    scenarios: XName = ...
    scheme: XName = ...
    selection: XName = ...
    serverFormat: XName = ...
    serverFormats: XName = ...
    set: XName = ...
    sets: XName = ...
    shadow: XName = ...
    sharedItems: XName = ...
    sheet: XName = ...
    sheetCalcPr: XName = ...
    sheetData: XName = ...
    sheetDataSet: XName = ...
    sheetFormatPr: XName = ...
    sheetId: XName = ...
    sheetIdMap: XName = ...
    sheetName: XName = ...
    sheetNames: XName = ...
    sheetPr: XName = ...
    sheetProtection: XName = ...
    sheets: XName = ...
    sheetView: XName = ...
    sheetViews: XName = ...
    si: XName = ...
    singleXmlCell: XName = ...
    singleXmlCells: XName = ...
    smartTags: XName = ...
    sortByTuple: XName = ...
    sortCondition: XName = ...
    sortState: XName = ...
    sst: XName = ...
    stop: XName = ...
    stp: XName = ...
    strike: XName = ...
    styleSheet: XName = ...
    sz: XName = ...
    t: XName = ...
    tabColor: XName = ...
    table: XName = ...
    tableColumn: XName = ...
    tableColumns: XName = ...
    tablePart: XName = ...
    tableParts: XName = ...
    tables: XName = ...
    tableStyle: XName = ...
    tableStyleElement: XName = ...
    tableStyleInfo: XName = ...
    tableStyles: XName = ...
    text: XName = ...
    textField: XName = ...
    textFields: XName = ...
    textPr: XName = ...
    to: XName = ...
    top: XName = ...
    top10: XName = ...
    totalsRowFormula: XName = ...
    tp: XName = ...
    tpl: XName = ...
    tpls: XName = ...
    tr: XName = ...
    tupleCache: XName = ...
    u: XName = ...
    undo: XName = ...
    userInfo: XName = ...
    users: XName = ...
    v: XName = ...
    val: XName = ...
    value: XName = ...
    valueMetadata: XName = ...
    values: XName = ...
    vertAlign: XName = ...
    vertical: XName = ...
    volType: XName = ...
    volTypes: XName = ...
    webPr: XName = ...
    webPublishItem: XName = ...
    webPublishItems: XName = ...
    worksheet: XName = ...
    worksheetEx14: XName = ...
    worksheetSource: XName = ...
    x: XName = ...
    xf: XName = ...
    xmlCellPr: XName = ...
    xmlColumnPr: XName = ...
    xmlPr: XName = ...