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).