Extract Text from the Gear Type SmartArt Shape with JavaScript via C++
Contents
[
Hide
]
Possible Usage Scenarios
Aspose.Cells can extract text from the Gear Type SmartArt Shape. In order to do so, you should first convert the SmartArt shape to a Group Shape using the Shape.resultOfSmartArt property. Then you should get the array of all the individual shapes forming the Group Shape using the GroupShape.groupedShapes property. Finally, you can iterate all of the individual shapes one by one in a loop and extract their text using the Shape.text property.
Extract Text from the Gear Type SmartArt Shape
The following sample code loads the sample Excel file that contains a Gear Type SmartArt Shape. It then extracts the text from its individual shapes as discussed above. Please see the console output of the code given below for a reference.
Sample Code
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Extract Gear SmartArt Text 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, Worksheet, Cell, 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();
// Instantiating a Workbook object by opening the Excel file through the file stream
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Access first worksheet.
const worksheet = workbook.worksheets.get(0);
// Access first shape.
const shape = worksheet.shapes.get(0);
// Get the result of the gear‑type SmartArt shape in the form of a group shape.
const groupShape = shape.resultOfSmartArt;
// Get the list of individual shapes that constitute the group shape.
const shapes = groupShape.groupedShapes;
// Extract the text of gear‑type shapes and display them.
const results = [];
for (let i = 0; i < shapes.count; i++) {
const s = shapes.get(i);
if (s.type === AsposeCells.AutoShapeType.Gear9 || s.type === AsposeCells.AutoShapeType.Gear6) {
const text = s.text;
results.push(text);
console.log("Gear Type Shape Text: " + text);
}
}
if (results.length) {
document.getElementById('result').innerHTML = '<p style="color: green;">Found gear shape texts:</p><ul>' + results.map(t => '<li>' + t + '</li>').join('') + '</ul>';
} else {
document.getElementById('result').innerHTML = '<p style="color: orange;">No gear type SmartArt shapes found in the first shape.</p>';
}
});
</script>
</html>
Console Output
Gear Type Shape Text: Nice
Gear Type Shape Text: Good
Gear Type Shape Text: Excellent