GrapeCity.Documents.Excel.ISlicer.Top

Top Property

Top

Gets or sets the vertical position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

Use this property to determine the slicer's current top offset on its worksheet.

Declaration

double Top { get; set; }

Property Top As Double

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Category", "Value"},
    {"Beverages", 100},
    {"Snacks", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ISlicer slicer = workbook.SlicerCaches.Add(table, "Category")
    .Slicers.Add(worksheet, "categorySlicer", "Category", 30, 100, 120, 160);
double top = slicer.Top;