Learn how to add TextBox with Aspose.Cells

In this tutorial, we'll add TextBox in a excel file.

We'll start by creating a new workbook using the Aspose.Cells library and add TextBox.

Source code copied.

Copy

//ExSummary: Please check the following code to find out how to add TextBox. //ExStepSummary:0: The following code shows how to add TextBox and set text. //ExStepImage:0:step-1.png //ExStepSummary:1: The following code shows how to change the color of text. //ExStepImage:1:step-2.png //ExStepSummary:2: The following code shows how to change the rotation angle of TextBox. //ExStepImage:2:step-3.png //ExStart //ExStep:0- using Aspose.Cells; using Aspose.Cells.Drawing; Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; sheet.PageSetup.PrintGridlines = true; sheet.PageSetup.PrintArea = "A1:F20"; ShapeCollection shapes = sheet.Shapes; //Add TextBox and set text TextBox textBox = shapes.AddTextBox(1, 0, 1, 0, 200, 200); textBox.Text = "Aspose.Cells for .NET is a programming class library that allows software developers to manipulate and process spreadsheet files within their own applications."; //ExStep:1- //Change the color of text textBox.Font.Color = Color.Blue; //ExStep:2- //Change the rotation angle of TextBox textBox.RotationAngle = 90; //ExStep:0- //ExEnd

OUTPUT:

Run

‹

›

Initializing View...

Step/Step