⁠19.12. Worksheet Commands

Worksheet commands are the children of workbooks and are usually executed only once.

⁠19.12.1. Grouping

Provides grouping of columns and rows.
<e:groupRows>
Attributes
  • startRow — A number value denoting the row at which to begin the grouping. The value is 0-based.
  • endRow — A number value denoting the row at which to end the grouping. The value is 0-based.
  • collapse — A Boolean determining whether the grouping is initially collapsed.
Child elements
  • none
Facets
  • none
<e:groupColumns>
Attributes
  • startColumn — A number value denoting the column at which to begin the grouping. The value is 0-based.
  • endColumn — A number value denoting the column at which to end the grouping. The value is 0-based.
  • collapse — A Boolean determining whether the grouping is initially collapsed.
Child elements
  • none
Facets
  • none 
​ 
​<e:workbook> 
​  <e:worksheet>
​    <e:groupRows startRow="4" endRow="9" collapse="true"/> 
​    <e:groupColumns startColumn="0" endColumn="9" collapse="false"/> 
​  </e:worksheet> 
​</e:workbook>
This groups rows 5 through 10 and columns 5 through 10 so that the rows are initially collapsed (but not the columns).

⁠19.12.2. Page breaks

Provides page breaks
<e:rowPageBreak>
Attributes
  • row — A number value denoting the row at which a page break should occur. The value is 0-based.
Child elements
  • none
Facets
  • none 
​ 
​<e:workbook> 
​  <e:worksheet> 
​    <e:rowPageBreak row="4"/> 
​  </e:worksheet> 
​</e:workbook>
This causes a page break at row 5.

⁠19.12.3. Merging

Provides cell merging
<e:mergeCells>
Attributes
  • startRow — A number value denoting the row at which to begin the merge. The value is 0-based.
  • startColumn — A number value denoting the column at which to begin the merge. The value is 0-based.
  • endRow — A number value denoting the row at which to end the merge. The value is 0-based.
  • endColumn — A number value denoting the column at which to end the merge. The value is 0-based.
Child elements
  • none
Facets
  • none 
​ 
​<e:workbook> 
​  <e:worksheet> 
​    <e:mergeCells startRow="0" startColumn="0" endRow="9" endColumn="9"/> 
​  </e:worksheet> 
​</e:workbook>
This merges the cells in the range A1:J10.