HPageBreaks Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.

public interface class HPageBreaks : System::Collections::IEnumerable

[System.Runtime.InteropServices.Guid("00024404-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface HPageBreaks : System.Collections.IEnumerable

Public Interface HPageBreaks
Implements IEnumerable

Attributes

GuidAttribute InterfaceTypeAttribute

Implements

IEnumerable

Remarks

Use the HPageBreaks property to return the HPageBreaks collection. Use the Add(Object) method to add a horizontal page break.

If you add a page break that does not intersect the print area, then the newly-added HPageBreak object will not appear in the HPageBreaks collection for the print area.

When the Application property, Count property, Creator property, Item[Int32] property, Parent property, or Add(Object) method is used in conjunction with the HPageBreaks property:

• For an automatic print area, the HPageBreaks property applies only to the page breaks within the print area.
• For a user-defined print area of the same range, the HPageBreaks property applies to all of the page breaks.

Note There is a limit of 1,026 horizontal page breaks per sheet.

Properties

_Default[Int32]	Reserved for internal use.
Application	Returns an Application object that represents the Microsoft Excel application.
Count	Returns the number of objects in the collection.
Creator	Returns a 32-bit integer that indicates the application in which this object was created.
Item[Int32]	Returns a single object from a collection.
Parent	Returns the parent object for the specified object.

Methods

Add(Object)	Adds a horizontal page break. Returns an HPageBreak object.
GetEnumerator()