JavaScript kullanarak ve C++ ile bağlı olan XML Haritasına ait XML Verisini dışa aktarın
Contents
[
Hide
]
Çalışma Kitabı içinde XML Haritasına bağlı XML Verilerini Dışa Aktar
Lütfen çalışma kitabınızdaki XML Haritalarınıza bağlı XML verisini ihraç etmek için Workbook.exportXml() yöntemini kullanın. Aşağıdaki örnek kod, çalışma kitabındaki tüm XML Haritalarını tek tek ihraç eder. Bu kodda kullanılan örnek excel dosyasını ve birinci XML Haritasının ihraç edilen XML verisini kontrol edin.
<!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>