WorksheetBase.PageSetup Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets a PageSetup that contains all the page setup settings for the worksheet.

public:
 property Microsoft::Office::Interop::Excel::PageSetup ^ PageSetup { Microsoft::Office::Interop::Excel::PageSetup ^ get(); };
public Microsoft.Office.Interop.Excel.PageSetup PageSetup { get; }
member this.PageSetup : Microsoft.Office.Interop.Excel.PageSetup
Public ReadOnly Property PageSetup As PageSetup

Property Value

PageSetup

A PageSetup that contains all the page setup settings for the worksheet.

Examples

The following code example uses the PageSetup property to set the bottom and header margins, the first page number, and the center headers and footers of the worksheet.

This example is for a document-level customization.

private void AdjustPageFormat()
{
    this.PageSetup.BottomMargin = 10;
    this.PageSetup.FirstPageNumber = 1;
    this.PageSetup.HeaderMargin = 10;
    this.PageSetup.CenterHeader = "December Sales Forcasts";
    this.PageSetup.CenterFooter = DateTime.Now.ToShortDateString();

    // Enter a range value and then preview the worksheet to 
    // display the page setup changes.
    this.Range["A1", "A5"].Value2 = "Sales";
    this.PrintPreview(false);
}

Private Sub AdjustPageFormat()
    With Me.PageSetup
        .BottomMargin = 10
        .FirstPageNumber = 1
        .HeaderMargin = 10
        .CenterHeader = "December Sales Forcasts"
        .CenterFooter = DateTime.Now.ToShortDateString()
    End With

    ' Enter a range value and then preview the worksheet to 
    ' display the page setup changes.
    Me.Range("A1", "A5").Value2 = "Sales"
    Me.PrintPreview(False)
End Sub

Applies to