19.11. Print areas and titles

Print areas and titles are the children of worksheets and worksheet templates, and provide print areas and titles.
<e:printArea>
Attributes
  • firstColumn — A number value denoting column that holds the top-left corner of the area. The value is 0-based.
  • firstRow — A number value denoting the row that holds the top left corner of the area.The value is 0-based.
  • lastColumn — A number value denoting the column that holds the bottom-right corner of the area. The value is 0-based.
  • lastRow — A number value denoting the row that holds the bottom-right corner of the area. The value is 0-based.
Child elements
  • none
Facets
  • none 
 
<e:workbook> 
  <e:worksheet> 
    <e:printTitles firstRow="0" firstColumn="0" lastRow="0" 
       lastColumn="9"/> 
    <e:printArea firstRow="1" firstColumn="0" lastRow="9" lastColumn="9"/> 
  </e:worksheet> 
</e:workbook>
This defines a print title between A1:A10 and a print area between B2:J10.