Esporta i dati XML collegati alla mappa XML all interno del workbook con JavaScript tramite C++
Contents
[
Hide
]
Esporta dati XML collegati alla mappa XML all’interno del Workbook
Per favore, utilizza il metodo Workbook.exportXml() per esportare dati XML collegati alle tue Maps XML nel workbook. Il seguente codice di esempio esporta i dati XML di tutte le Maps XML dal workbook una per una. Controlla il file Excel di esempio usato in questo codice e i dati XML esportati della prima Map XML.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Export XML Maps 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="downloads"></div>
<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 with the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Clear previous downloads/results
const downloadsContainer = document.getElementById('downloads');
downloadsContainer.innerHTML = '';
const downloadLink = document.getElementById('downloadLink');
downloadLink.style.display = 'none';
document.getElementById('result').innerHTML = '';
// Export all XML data from all XML Maps from the Workbook.
for (let i = 0; i < workbook.worksheets.xmlMaps.count; i++) {
// Access the XML Map.
const map = workbook.worksheets.xmlMaps.get(i);
// Exports its XML Data (returns data that can be downloaded)
const xmlData = workbook.exportXml(map.name);
// Create a downloadable link for each exported XML
const blob = new Blob([xmlData], { type: 'application/xml' });
const link = document.createElement('a');
link.href = URL.createObjectURL(blob);
link.download = `${map.name}.xml`;
link.textContent = `Download ${map.name}.xml`;
link.style.display = 'block';
downloadsContainer.appendChild(link);
}
if (downloadsContainer.children.length === 0) {
document.getElementById('result').innerHTML = '<p style="color: orange;">No XML Maps found in the workbook.</p>';
} else {
document.getElementById('result').innerHTML = '<p style="color: green;">Export completed. Use the links below to download the XML files.</p>';
}
});
</script>
</html>