Class HorizontalPageBreakCollection

HorizontalPageBreakCollection class

Encapsulates a collection of HorizontalPageBreak objects.

public class HorizontalPageBreakCollection : CollectionBase<HorizontalPageBreak>

Properties

NameDescription
Capacity { get; set; }
Count { get; }
Item { get; }Gets the HorizontalPageBreak element at the specified index. (2 indexers)
Item { get; set; }

Methods

NameDescription
Add(int)Adds a horizontal page break to the collection.
Add(string)Adds a horizontal page break to the collection.
Add(int, int)Adds a horizontal page break to the collection.
Add(int, int, int)Adds a horizontal page break to the collection.
BinarySearch(HorizontalPageBreak)
BinarySearch(HorizontalPageBreak, IComparer<HorizontalPageBreak>)
BinarySearch(int, int, HorizontalPageBreak, IComparer<HorizontalPageBreak>)
Clear()
Contains(HorizontalPageBreak)
CopyTo(HorizontalPageBreak[])
CopyTo(HorizontalPageBreak[], int)
CopyTo(int, HorizontalPageBreak[], int, int)
Exists(Predicate<HorizontalPageBreak>)
Find(Predicate<HorizontalPageBreak>)
FindAll(Predicate<HorizontalPageBreak>)
FindIndex(Predicate<HorizontalPageBreak>)
FindIndex(int, Predicate<HorizontalPageBreak>)
FindIndex(int, int, Predicate<HorizontalPageBreak>)
FindLast(Predicate<HorizontalPageBreak>)
FindLastIndex(Predicate<HorizontalPageBreak>)
FindLastIndex(int, Predicate<HorizontalPageBreak>)
FindLastIndex(int, int, Predicate<HorizontalPageBreak>)
GetEnumerator()
IndexOf(HorizontalPageBreak)
IndexOf(HorizontalPageBreak, int)
IndexOf(HorizontalPageBreak, int, int)
LastIndexOf(HorizontalPageBreak)
LastIndexOf(HorizontalPageBreak, int)
LastIndexOf(HorizontalPageBreak, int, int)
RemoveAt(int)Removes the HPageBreak element at a specified name. (2 methods)

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using System;

    public class HorizontalPageBreakCollectionDemo
    {
        public static void HorizontalPageBreakCollectionExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            
            // Access the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Add a horizontal page break at row 5
            worksheet.HorizontalPageBreaks.Add(5);
            
            // Add a horizontal page break at row 10, starting from column 1 to column 5
            worksheet.HorizontalPageBreaks.Add(10, 1, 5);
            
            // Add a horizontal page break at row 15, starting from column 2
            worksheet.HorizontalPageBreaks.Add(15, 2);
            
            // Add a horizontal page break at cell "G5"
            worksheet.HorizontalPageBreaks.Add("G5");
            
            // Remove the first horizontal page break
            worksheet.HorizontalPageBreaks.RemoveAt(0);
            
            // Save the workbook
            workbook.Save("HorizontalPageBreakCollectionExample.xlsx");
            workbook.Save("HorizontalPageBreakCollectionExample.pdf");
            return;
        }
    }
}

See Also