ShapeCollection.AddLabel

ShapeCollection.AddLabel method

Adds a Label to the worksheet.

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

Return Value

A Label object.

Examples

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

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

            // Get the shapes collection
            ShapeCollection shapes = worksheet.Shapes;

            // Add a label to the worksheet
            Label label = shapes.AddLabel(1, 0, 1, 0, 100, 50);
            label.Text = "Sample Label";

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

See Also