SmartArt ta metni JavaScript kullanarak C++ ile değiştir
Contents
[
Hide
]
Olası Kullanım Senaryoları
Smart art, çalışma kitabındaki ana nesnelerden biridir. Çoğu zaman smart art’taki metni güncellemek gerekebilir. Aspose.Cells for JavaScript ile bu özellik Shape.text özelliği ayarlayarak sağlanır.
Örnek kaynak dosyası aşağıdaki bağlantıdan indirilebilir:
Örnek Kod
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells SmartArt Example</title>
</head>
<body>
<h1>SmartArt Replacement 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, OoxmlSaveOptions } = 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 from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Access worksheets collection
const worksheets = workbook.worksheets;
for (let i = 0; i < worksheets.count; i++) {
const worksheet = worksheets.get(i);
const shapes = worksheet.shapes;
for (let j = 0; j < shapes.count; j++) {
const shape = shapes.get(j);
// Set alternative text using property assignment
shape.alternativeText = "ReplacedAlternativeText";
if (shape.isSmartArt()) {
// Access smart art grouped shapes via properties
const smartArtShapes = shape.resultOfSmartArt.groupedShapes;
for (let k = 0; k < smartArtShapes.length; k++) {
const smartart = smartArtShapes[k];
// Set text using property assignment
smartart.text = "ReplacedText";
}
}
}
}
// Configure save options and enable SmartArt update
const options = new OoxmlSaveOptions();
options.updateSmartArt = true;
// Save workbook to XLSX format with options and provide download link
const outputData = workbook.save(SaveFormat.Xlsx, options);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'outputSmartArt.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">SmartArt updated successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>