Text boxes in Excel

Aspose.Cells Product Family
1

Hello,

Is it possible to pull the value from a textbox(e.g. shape) in a spreadsheet?

Thanks

Big Smile

2

This feature is not supported in Aspose.Excel.

3

@theMadLad,
Aspose.Excel is discarded and is replaced with an advanced product Aspose.Cells that supports all the latest features in different versions of MS Excel like adding variety of controls into a worksheet. For example you can add Text Box, Check Box, Radio Button, Combo Box, Label, List Box, Button, Line, Rectangle, Arc, Oval, Spinner, Scroll Bar and Group Box.

Here is an example that demonstrates the adding of a Text Box into a worksheet.

// Instantiate a new Workbook.
Workbook workbook = new Workbook();

// Get the first worksheet in the book.
Worksheet worksheet = workbook.Worksheets[0];

// Add a new textbox to the collection.
int textboxIndex = worksheet.TextBoxes.Add(2, 1, 160, 200);

// Get the textbox object.
Aspose.Cells.Drawing.TextBox textbox0 = worksheet.TextBoxes[textboxIndex];

// Fill the text.
textbox0.Text = "ASPOSE The .NET & JAVA Component Publisher!";

// Set the placement.
textbox0.Placement = PlacementType.FreeFloating;

// Set the font color.
textbox0.Font.Color = Color.Blue;

// Set the font to bold.
textbox0.Font.IsBold = true;

// Set the font size.
textbox0.Font.Size = 14;

// Set font attribute to italic.
textbox0.Font.IsItalic = true;

// Add a hyperlink to the textbox.
textbox0.AddHyperlink("http://www.aspose.com/");

// Get the filformat of the textbox.
Aspose.Cells.Drawing.FillFormat fillformat = textbox0.Fill;

// Get the lineformat type of the textbox.
Aspose.Cells.Drawing.LineFormat lineformat = textbox0.Line;

// Set the line weight.
lineformat.Weight = 6;

// Set the dash style to squaredot.
lineformat.DashStyle = MsoLineDashStyle.SquareDot;

// Add another textbox.
textboxIndex = worksheet.TextBoxes.Add(15, 4, 85, 120);

// Get the second textbox.
Aspose.Cells.Drawing.TextBox textbox1 = worksheet.TextBoxes[textboxIndex];

// Input some text to it.
textbox1.Text = "This is another simple text box";

// Set the placement type as the textbox will move and
// Resize with cells.
textbox1.Placement = PlacementType.MoveAndSize;

// Save the excel file.
workbook.Save("book1TextBox.xlsx");

For a detailed introduction and sample codes to render controls on a worksheet refer to the following article:
Managing Controls

You can download the latest trial version of Aspose.Cells for .NET to run this example.

Here is a runnable solution that contains variety of examples to test different features of the product.