Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / PageLayout Class / RemovePageBreaksAtCell Method
The Address of the Cell that is used as a reference point for the removal; both the page breaks on top & at the left of this Cell will be removed.
Example


In This Topic
    RemovePageBreaksAtCell Method
    In This Topic
    Removes page breaks from the Worksheet, using the location of a specific Cell to determine which page breaks will be removed.
    Syntax
    'Declaration
     
    
    Public Sub RemovePageBreaksAtCell( _
       ByVal cellAddress As String _
    ) 
    'Usage
     
    
    Dim instance As PageLayout
    Dim cellAddress As String
     
    instance.RemovePageBreaksAtCell(cellAddress)
    public void RemovePageBreaksAtCell( 
       string cellAddress
    )

    Parameters

    cellAddress
    The Address of the Cell that is used as a reference point for the removal; both the page breaks on top & at the left of this Cell will be removed.
    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 page breaks using specific cells as a target location for the insertion.
          worksheet.PageLayout.InsertPageBreaksAtCell("B2");
          worksheet.PageLayout.InsertPageBreaksAtCell("C3");
    	  
          // Removes page breaks using a specific cell as the target location for the removal.
          worksheet.PageLayout.RemovePageBreaksAtCell("B2");
    	  
          // Saves workbook to disk.
          workbook.Save();
          Console.WriteLine( "/tCreated:PageMarginsAndBreaks.xlsx/n" );
        }
    }
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also