Add XML Map into the Workbook using XmlMapCollection.Add method with JavaScript via C++
Contents
[
Hide
]
Possible Usage Scenarios
Aspose.Cells provides XmlMapCollection.add(string) method, which you can use to import your XML map into the workbook.
Add XML Map into the Workbook using XmlMapCollection.Add method
The following sample code adds an XML map into the workbook using the XmlMapCollection.add(string) method and saves it as an output Excel file (5115434.xlsx). The screenshot shows the XML map that has been imported from sample.xml into the output Excel file.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Add XML Map to Workbook Example</h1>
<input type="file" id="fileInput" accept=".xml" />
<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 XML file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
const xmlString = new TextDecoder().decode(arrayBuffer);
// Create workbook object
const wb = new Workbook();
// Add XML map found inside the uploaded sample.xml into the workbook
// Note: converted getter/setter usage to property access per universal conversion rules
wb.worksheets.xmlMaps.add(xmlString);
// Save the workbook in XLSX format and provide download link
const outputData = wb.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">XML map added and workbook saved. Click the download link to get the modified file.</p>';
});
</script>
</html>