NativeExcel for .Net Developer's Reference

IPageBreak.Delete Method 

Deletes the specified page break.

[Visual Basic]
Sub Delete()
[C#]
void Delete();
[C++]
void Delete();
[JScript]
function Delete();

Example

This example deletes any horizontal page breaks which located at row less then 20.

[C#]
IPageBreaks pbs = book.Worksheets[1].HPageBreaks;
for (int i = pbs.Count; i > 0; i--) {
    if (pbs[i].Location.Row < 20) pbs[i].Delete();
}  
[Visual Basic]
Dim pbs As IPageBreaks = book.Worksheets(1).HPageBreaks
Dim i As Integer = pbs.Count
While i > 0
   If pbs(i).Location.Row  < 20
       pbs(i).Delete()
   End If
   i = i - 1
End While    
[C++]
IPageBreaks* pbs = book->Worksheets->Item[1]->HPageBreaks;
for (int i = pbs->Count; i > 0; i--) {
    if (pbs->Item[i]->Location->Row < 20) {
        pbs->Item[i]->Delete();
    }   
}  

See Also

IPageBreak Interface | NativeExcel Namespace | IWorksheet.HPageBreaks | IWorksheet.VPageBreaks | IPageBreaks Interface