ShapeCollection.AddSpinner

ShapeCollection.AddSpinner method

Adds a Spinner to the worksheet.

public Spinner AddSpinner(int topRow, int top, int leftColumn, int left, int height, int width)
ParameterTypeDescription
topRowInt32Upper left row index.
topInt32Represents the vertical offset of Spinner from its left row, in unit of pixel.
leftColumnInt32Upper 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