PageSetup element

Contains information related to settings for printing worksheets.

Usage

      
<PageSetup
	Orientation="xsd:string"
	CenterHorizontal="OneZeroType"
	CenterVertical="OneZeroType"
	StartPageNumber="xsd:string"
	Margin="xsd:double"
	Data="xsd:string"
	Margin="xsd:double"
	Data="xsd:string"
	Left="xsd:double"
	Right="xsd:double"
	Top="xsd:double"
	Bottom="xsd:double"
/>

Element Information

Element type PageSetupType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
WorksheetOptions Contains information about options related to the worksheet.

Child Elements

Element Description
Layout Contains information related to page layout.
Header Contains information related to headers.
Footer Contains information related to footers.
PageMargins Contains information related to page margins.

Attributes

Attribute Type Required Description Possible Values
Orientation Anonymous optional Specifies whether the page orientation is portrait or landscape
  • Landscape
  • Portrait
CenterHorizontal OneZeroType optional Specifies whether the worksheet is centered horizontally on the page when it is printed.
  • 0
  • 1
CenterVertical OneZeroType optional Specifies whether the worksheet is centered vertically on the page when it is printed.
  • 0
  • 1
StartPageNumber xsd:string optional Specifies the first page number that will be used when the worksheet is printed. See external namespace.
Margin xsd:double optional Specifies the distance in points from the top of the page to the header. See external namespace.
Data xsd:string optional Contains the content for the header. See external namespace.
Margin xsd:double optional Specifies the distance in points from the top of the page to the footer. See external namespace.
Data xsd:string optional Contains the content for the footer. See external namespace.
Left xsd:double optional Specifies the size in points of the left margin. See external namespace.
Right xsd:double optional Specifies the size in points of the right margin. See external namespace.
Top xsd:double optional Specifies the size in points of the top margin. See external namespace.
Bottom xsd:double optional Specifies the size in points of the bottom margin. See external namespace.

Definition

      
<xsd:element name="PageSetup" type="PageSetupType" minOccurs="0" >
</xsd:element>
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp