Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / PageLayout Class / InsertPageBreakRow Method
The index that corresponds to the targeted Row; the page break will be added on top of that Row.
Example


In This Topic
    InsertPageBreakRow Method
    In This Topic
    Inserts a page break on top of a specific Row
    Syntax
    'Declaration
     
    
    Public Sub InsertPageBreakRow( _
       ByVal row As Integer _
    ) 
    'Usage
     
    
    Dim instance As PageLayout
    Dim row As Integer
     
    instance.InsertPageBreakRow(row)
    public void InsertPageBreakRow( 
       int row
    )

    Parameters

    row
    The index that corresponds to the targeted Row; the page break will be added on top of that Row.
    Example
    public static void PageMarginsAndPageBreaks()
    {
      using( var workbook = Workbook.Create( PageLayoutSample.PageLayoutSampleOutputDirectory + @"PageMarginsAndBreaks.xlsx" ))
        {
          // Gets the first worksheet; a workbook always contains at least 1 worksheet.
          var worksheet = workbook.Worksheets[0];
    	  
          // Adds a title.
          worksheet.Cells["B1"].Value = "Page Margins and Breaks";
          worksheet.Cells["B1"].Style.Font = new Font() {Bold = true, Size = 15.5d};
    	  
          // Inserts pages breaks using rows as a reference point for the insertion.
          worksheet.PageLayout.InsertPageBreakRow(777);
          worksheet.PageLayout.InsertPageBreakRow(999);
    	  
          // Saves workbook to disk.
          workbook.Save();
          Console.WriteLine( "/tCreated:PageMarginsAndBreaks.xlsx/n" );
        }
    }
    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also