XmlMappedRange.PageBreak Property

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assembly:

Microsoft.Office.Tools.Excel.dll

Gets or sets the location of a page break.

public:
 property int PageBreak { int get(); void set(int value); };

public int PageBreak { get; set; }

member this.PageBreak : int with get, set

Public Property PageBreak As Integer

Property Value

Int32

Examples

The following code example uses the PageBreak property to set a page break at an XmlMappedRange. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.

private void SetPageBreak()
{
    this.CustomerLastNameCell.PageBreak = 
        (int)Excel.XlPageBreak.xlPageBreakManual;
}

Private Sub SetPageBreak()
    Me.CustomerLastNameCell.PageBreak = Excel.XlPageBreak.xlPageBreakManual
End Sub

Remarks

You can set this property using one of the following XlPageBreakvalues:

• xlPageBreakAutomatic

• xlPageBreakManual

• xlPageBreakNone

This property can return the location of either automatic or manual page breaks, but it can only set the location of manual breaks (it can only be set to xlPageBreakManual or xlPageBreakNone).