ShapeCollection.AddScrollBar

ShapeCollection.AddScrollBar method

Adds a ScrollBar to the worksheet.

public ScrollBar AddScrollBar(int upperLeftRow, int top, int upperLeftColumn, int left, int height, 
    int width)
ParameterTypeDescription
upperLeftRowInt32Upper left row index.
topInt32Represents the vertical offset of ScrollBar from its left row, in unit of pixel.
upperLeftColumnInt32Upper left column index.
leftInt32Represents the horizontal offset of ScrollBar from its left column, in unit of pixel.
heightInt32Represents the height of ScrollBar, in unit of pixel.
widthInt32Represents the width of ScrollBar, in unit of pixel.

Return Value

A ScrollBar object.

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Drawing;

namespace AsposeCellsExamples
{
    public class ShapeCollectionMethodAddScrollBarWithInt32Int32Int32Int32Int32Int32Demo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];
            ShapeCollection shapes = worksheet.Shapes;

            ScrollBar scrollBar = shapes.AddScrollBar(1, 0, 100, 20, 0, 100);
            scrollBar.CurrentValue = 50;
            scrollBar.Width = 200;
            scrollBar.Height = 30;

            workbook.Save("ScrollBarDemo.xlsx");
        }
    }
}

See Also