Search notes:

Office Open XML - SpreadsheetML: Merged cells

[Content_Types].xml

<?xml version="1.0" encoding="utf-8"?>
<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">

  <Default Extension="rels"                      ContentType="application/vnd.openxmlformats-package.relationships+xml"                     />
  <Default Extension="xml"                       ContentType="application/xml"                                                              />

  <Override PartName="/xl/theme/theme1.xml"      ContentType="application/vnd.openxmlformats-officedocument.theme+xml"                      />
  <Override PartName="/xl/styles.xml"            ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"       />
  <Override PartName="/xl/workbook.xml"          ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"   />
  <Override PartName="/docProps/app.xml"         ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"        />
  <Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"    />
  <Override PartName="/xl/sharedStrings.xml"     ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"/>
  <Override PartName="/docProps/core.xml"        ContentType="application/vnd.openxmlformats-package.core-properties+xml"                   />
</Types>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/[Content_Types].xml

_rels/.rels

<?xml version="1.0" encoding="utf-8"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
  <Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"  />
  <Relationship Id="rId2" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties"   Target="docProps/core.xml" />
  <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument"      Target="xl/workbook.xml"   />
</Relationships>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/_rels/.rels

docProps/core.xml

<?xml version="1.0" encoding="utf-8"?>
<cp:coreProperties xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
</cp:coreProperties>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/docProps/core.xml

docProps/app.xml

<?xml version="1.0" encoding="utf-8"?>
<Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes">
</Properties>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/docProps/app.xml

xl/sharedStrings.xml

<?xml version="1.0" encoding="utf-8"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="14" uniqueCount="14">
  <si><t>Span 5 columns</t></si>
  <si><t>Span 3 columns</t></si>
  <si><t>span 6 rows</t></si>
  <si><t>A1</t></si>
  <si><t>B2</t></si>
  <si><t>C3</t></si>
  <si><t>E5</t></si>
  <si><t>F6</t></si>
  <si><t>H7</t></si>
  <si><t>H4</t></si>
  <si><t>A4</t></si>
  <si><t>F2</t></si>
  <si><t>G1</t></si>
  <si><t>G8</t></si>
</sst>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/xl/sharedStrings.xml

xl/_rels/workbook.xml.rels

<?xml version="1.0" encoding="utf-8"?>
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
  <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet"     Target="worksheets/sheet1.xml" />
  <Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings" Target="sharedStrings.xml"     />
  <Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles"        Target="styles.xml"            />
</Relationships>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/xl/_rels/workbook.xml.rels

xl/styles.xml

<?xml version="1.0" encoding="utf-8"?>
<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac">
  <fonts count="1" x14ac:knownFonts="1">
    <font>
      <sz val="11" />
      <color theme="1" />
      <name val="Calibri" />
      <family val="2" />
      <scheme val="minor" />
    </font>
  </fonts>
  <fills count="4">
    <fill>
      <patternFill patternType="none" />
    </fill>
    <fill>
      <patternFill patternType="gray125" />
    </fill>
    <fill>
      <patternFill patternType="solid">
        <fgColor theme="0" tint="-4.9989318521683403E-2" />
        <bgColor indexed="64" />
      </patternFill>
    </fill>
    <fill>
      <patternFill patternType="solid">
        <fgColor theme="6" tint="0.79998168889431442" />
        <bgColor indexed="64" />
      </patternFill>
    </fill>
  </fills>
  <borders count="1">
    <border>
      <left />
      <right />
      <top />
      <bottom />
      <diagonal />
    </border>
  </borders>
  <cellStyleXfs count="1">
    <xf numFmtId="0" fontId="0" fillId="0" borderId="0" />
  </cellStyleXfs>
  <cellXfs count="3">
    <xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0" />
    <xf numFmtId="0" fontId="0" fillId="2" borderId="0" xfId="0" applyFill="1" applyAlignment="1" />
    <xf numFmtId="0" fontId="0" fillId="3" borderId="0" xfId="0" applyFill="1" applyAlignment="1">
      <alignment vertical="top" />
    </xf>
  </cellXfs>
  <cellStyles count="1">
    <cellStyle name="Normal" xfId="0" builtinId="0" />
  </cellStyles>
  <dxfs count="0" />
  <tableStyles count="0" defaultTableStyle="TableStyleMedium2" defaultPivotStyle="PivotStyleLight16" />
  <extLst>
    <ext xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main" uri="{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}">
      <x14:slicerStyles defaultSlicerStyle="SlicerStyleLight1" />
    </ext>
  </extLst>
</styleSheet>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/xl/styles.xml

xl/workbook.xml

<?xml version="1.0" encoding="utf-8"?>
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
  <bookViews>
    <workbookView xWindow="120" yWindow="90" windowWidth="28515" windowHeight="14370" />
  </bookViews>
  <sheets>
    <sheet name="Name of sheet" sheetId="1" r:id="rId1" />
  </sheets>
  <calcPr calcId="125725" />
</workbook>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/xl/workbook.xml

xl/worksheets/sheet1.xml

<?xml version="1.0" encoding="utf-8"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac">
  <dimension ref="A1:K8" />
  <sheetViews>
    <sheetView tabSelected="1" workbookViewId="0">
      <selection activeCell="G9" sqref="G9" />
    </sheetView>
  </sheetViews>
  <sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25" />
  <cols>
    <col min="7" max="7" width="12.140625" customWidth="1" />
  </cols>
  <sheetData>
    <row r="1" spans="1:11" x14ac:dyDescent="0.25">
      <c r="A1" t="s">
        <v>3</v>
      </c>
      <c r="G1" t="s">
        <v>12</v>
      </c>
    </row>
    <row r="2" spans="1:11" x14ac:dyDescent="0.25">
      <c r="B2" t="s">
        <v>4</v>
      </c>
      <c r="F2" t="s">
        <v>11</v>
      </c>
      <c r="G2" s="2" t="s">
        <v>2</v>
      </c>
    </row>
    <row r="3" spans="1:11" x14ac:dyDescent="0.25">
      <c r="C3" t="s">
        <v>5</v>
      </c>
      <c r="G3" s="2" />
    </row>
    <row r="4" spans="1:11" x14ac:dyDescent="0.25">
      <c r="A4" t="s">
        <v>10</v>
      </c>
      <c r="B4" s="1" t="s">
        <v>0</v>
      </c>
      <c r="C4" s="1" />
      <c r="D4" s="1" />
      <c r="E4" s="1" />
      <c r="F4" s="1" />
      <c r="G4" s="2" />
      <c r="H4" t="s">
        <v>9</v>
      </c>
      <c r="I4" s="1" t="s">
        <v>1</v>
      </c>
      <c r="J4" s="1" />
      <c r="K4" s="1" />
    </row>
    <row r="5" spans="1:11" x14ac:dyDescent="0.25">
      <c r="E5" t="s">
        <v>6</v>
      </c>
      <c r="G5" s="2" />
    </row>
    <row r="6" spans="1:11" x14ac:dyDescent="0.25">
      <c r="F6" t="s">
        <v>7</v>
      </c>
      <c r="G6" s="2" />
    </row>
    <row r="7" spans="1:11" x14ac:dyDescent="0.25">
      <c r="G7" s="2" />
    </row>
    <row r="8" spans="1:11" x14ac:dyDescent="0.25">
      <c r="G8" t="s">
        <v>13</v>
      </c>
      <c r="H8" t="s">
        <v>8</v>
      </c>
    </row>
  </sheetData>
  <mergeCells count="3">
    <mergeCell ref="B4:F4" />
    <mergeCell ref="I4:K4" />
    <mergeCell ref="G2:G7" />
  </mergeCells>
  <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3" />
  <pageSetup paperSize="9" orientation="portrait" horizontalDpi="0" verticalDpi="0" r:id="rId1" />
</worksheet>
Github repository about-Office-Open-XML, path: /SpreadsheetML/Merge-cells/xl/worksheets/sheet1.xml

See also

SpreadsheetML

Index