ShapeCollection.AddSpinner

ShapeCollection.AddSpinner method

Adds a Spinner to the worksheet.

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

Return Value

A Spinner object.

Examples

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

namespace AsposeCellsExamples
{
    public class ShapeCollectionMethodAddSpinnerWithInt32Int32Int32Int32Int32Int32Demo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            // Add a spinner to the worksheet
            Aspose.Cells.Drawing.Spinner spinner = (Aspose.Cells.Drawing.Spinner)worksheet.Shapes.AddSpinner(1, 0, 1, 0, 100, 50);

            // Set spinner properties
            spinner.LinkedCell = "A1";
            spinner.Min = 0;
            spinner.Max = 100;
            spinner.IncrementalChange = 1;

            // Save the workbook
            workbook.Save("AddSpinnerDemo.xlsx");
        }
    }
}

See Also