Access the Text Box by the Name with JavaScript via C++
Contents
[
Hide
]
Access the Text Box by the Name
Earlier, text boxes were accessed by index from the Worksheet.textBoxes collection, but now you can also access the text box by name from this collection. This is a convenient and quick way to access your text box if you already know its name.
The following sample code first creates a text box and assigns it some text and name. Then in the next lines, we access the same text box by its name and print its text.
JavaScript code to access the text box by name
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells TextBox Example</title>
</head>
<body>
<h1>TextBox Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat, Utils } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
const fileInput = document.getElementById('fileInput');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
const workbook = new Workbook(new Uint8Array(arrayBuffer));
const sheet = workbook.worksheets.get(0);
const idx = sheet.textBoxes.add(10, 10, 10, 10);
const tb1 = sheet.textBoxes.get(idx);
tb1.name = "MyTextBox";
tb1.text = "This is MyTextBox";
const tb2 = sheet.textBoxes.get("MyTextBox");
console.log(tb2.text);
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'sample.modified.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = `<p style="color: green;">TextBox added. Text from named TextBox: ${tb2.text}</p>`;
});
</script>
</html>
Console output generated by the sample code
This is MyTextBox