Interface ITextBoxShapeEx

This interface represents TextBox form control shape.

Inherited Members
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public interface ITextBoxShapeEx : ITextBoxShape, ITextBox, IShape, IParentApplication

Properties

Text of the comment.

Declaration
string TextLink { get; set; }
Property Value
Type
System.String

The following code illustrates how to set TextLink property.

        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];

            //Add data
            worksheet["C4"].Value = "Text";

            //Add shape
            ITextBoxShapeEx shape = worksheet.Shapes.AddTextBox();

            //Set dimensions
            shape.Top = 40;
            shape.Left = 20;
            shape.Height = 30;
            shape.Width = 70;

            //Set text link
            shape.TextLink = "=C4";

            //Save and dispose
            workbook.SaveAs("Shapes.xlsx");
            workbook.Close();
        }