Partager via


XmlMappedRange.PageBreak Property

Gets or sets the location of a page break.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Property PageBreak As Integer
int PageBreak { get; set; }

Property Value

Type: System.Int32

Remarks

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

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

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 Sub SetPageBreak()
    Me.CustomerLastNameCell.PageBreak = Excel.XlPageBreak.xlPageBreakManual
End Sub
private void SetPageBreak()
{
    this.CustomerLastNameCell.PageBreak = 
        (int)Excel.XlPageBreak.xlPageBreakManual;
}

.NET Framework Security

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace