GrapeCity.Documents.Excel.ISlicer.Shape

Shape Property

Shape

Gets the IShape object associated with the slicer.

Use the returned shape to access drawing-level properties of the slicer, such as its position, size, and other shape settings on the worksheet.

Declaration

IShape Shape { get; }

ReadOnly Property Shape As IShape

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Vegetables", 200},
    {"Fruit", 150}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISlicer slicer = workbook.SlicerCaches.Add(table, "Category")
    .Slicers.Add(worksheet, "categorySlicer", "Category", 30, 100, 120, 160);
IShape shape = slicer.Shape;