How to add/insert TextBox to Worksheet with Node.js via 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 for Node.js via C++

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.

const AsposeCells = require("aspose.cells.node");
const path = require("path");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Create an object of the Workbook class
const workbook = new AsposeCells.Workbook();

// Access first worksheet from the collection
const sheet = workbook.getWorksheets().get(0);

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

// Save. You can check your text box in this way.
workbook.save("result.xlsx", AsposeCells.SaveFormat.Xlsx);

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