How to add/insert TextBox to Worksheet with C++

Add Text Box to Worksheet in Excel

In the Excel program (version 07 and above), there are two places where you can insert text boxes. One in “insert-shapes”, the other is on the right side of the top menu of the “Insert” option.

Method One:

Method Two:

How to Create

You can create text boxes with horizontal or vertical text.

• Select the corresponding option (horizontal or vertical)
• Left click on the page
• Hold down the left button and drag a distance on the page
• Release the left button

Now you get a text box.

Add Text Box to Worksheet in Aspose.Cells

When you need to bulk insert TextBox into the worksheet, the manual insertion method is obviously a disaster. If this bothers you, I think this document will help you. Aspose.Cells provides you with an API to easily do bulk inserts in your code.

The following sample code creates a text box.

#include <iostream>
#include "Aspose.Cells.h"

using namespace Aspose::Cells;
using namespace Aspose::Cells::Drawing;

int main()
{
    Aspose::Cells::Startup();

    // Source directory path
    U16String srcDir(u"..\\Data\\01_SourceDirectory\\");

    // Output directory path
    U16String outDir(u"..\\Data\\02_OutputDirectory\\");

    // Create an object of the Workbook class
    Workbook workbook;

    // Access first worksheet from the collection
    Worksheet sheet = workbook.GetWorksheets().Get(0);

    // Add the TextBox to the worksheet
    sheet.GetTextBoxes().Add(6, 10, 100, 200);

    // Save the workbook with the text box
    workbook.Save(outDir + u"result.xlsx", SaveFormat::Xlsx);

    std::cout << "Text box added successfully!" << std::endl;

    Aspose::Cells::Cleanup();
}

You will get a file similar to result file. In the file, you will see the following: