Choose TextBox in terms of name instead of index

Aspose.Cells Product Family
1

Hi,



Can I use the name of the textbox instead of index to choose a textbox. Like workbook.Worksheets[“Sheet1”].TextBoxes[“TextBox1”] instead of workbook.Worksheets[“Sheet1”].TextBoxes[0] in the attached MenuWithBackground.xlsx?

2

Hi there,


You can achieve this as follow.

C#

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(dir + “MenuWithBackground.xlsx”);
Aspose.Cells.Drawing.TextBox textbox = (Aspose.Cells.Drawing.TextBox)workbook.Worksheets[“Sheet1”].Shapes[“TextBox1”];
textbox.Text = “Sample Text”;
workbook.Save(dir + “output.xlsx”);

Please feel free to contact us back in case you have further questions.
3

Hi,

Thanks for using Aspose.Cells.

We have fixed your following issue

  • CELLSNET-44301 - Choose TextBox in terms of name instead of index

Now you will be able to run this code.


TextBox tb = worksheet.TextBoxes[“TextBox 1”];


We will soon provide the fix after performing QA and including other enhancements and fixes.

4

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.7.1.4 and let us know your feedback.

5

The issues you have found earlier (filed as CELLSNET-44301) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.