Exportar datos XML vinculados al mapa XML dentro del libro de trabajo con JavaScript vía C++
Contents
[
Hide
]
Exportar datos XML vinculados al mapa XML dentro del libro
Por favor, usa el método Workbook.exportXml() para exportar datos XML vinculados a tus mapas XML dentro de tu libro de trabajo. El siguiente código de ejemplo exporta los datos XML de todos los mapas XML uno por uno. Revisa el archivo de ejemplo de Excel usado en este código y los datos XML exportados del primer mapa 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>