Convertir JSON en Excel avec JavaScript via C++
Contents
[
Hide
]
Aspose.Cells supporte la conversion d’un fichier JSON (JavaScript Object Notation) en classeur Excel.
Convertir JSON en classeur Excel
Inutile de se demander comment convertir JSON en fichier Excel, car Aspose.Cells for JavaScript via C++ offre la meilleure solution. L’API Aspose.Cells supporte la conversion du format JSON en feuilles de calcul. Vous pouvez utiliser la classe JsonLoadOptions pour spécifier des paramètres supplémentaires pour l’importation de JSON dans le classeur.
L’exemple de code suivant démontre l’importation du JSON dans le Classeur Excel. Veuillez consulter le code pour convertir le fichier source en fichier xlsx généré par le code à titre de référence.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells Example - Convert JSON to XLSX</h1>
<input type="file" id="fileInput" accept=".json" />
<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 a JSON file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// create a Workbook object from uploaded file (JSON)
const wb = new Workbook(new Uint8Array(arrayBuffer));
// save file to xlsx format
const outputData = wb.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'sample_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Conversion completed successfully! Click the download link to get the XLSX file.</p>';
});
</script>
</html>
L’exemple de code suivant, utilisant la classe JsonLoadOptions pour spécifier des paramètres supplémentaires, montre comment importer JSON dans un classeur Excel. Veuillez consulter le code pour convertir le fichier source en fichier xlsx généré par le code à titre de référence.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Load JSON into Workbook and Save as XLSX</h1>
<input type="file" id="fileInput" accept=".json" />
<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, JsonLoadOptions, 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 a JSON file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Create an options of loading the file.
const options = new JsonLoadOptions();
options.multipleWorksheets = true;
// Loads the workbook from JSON file
const book = new Workbook(new Uint8Array(arrayBuffer), options);
// Save file to xlsx format
const outputData = book.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'sample_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Operation completed successfully! Click the download link to get the converted file.</p>';
});
</script>
</html>
L’exemple de code suivant montre comment importer une chaîne JSON dans un classeur Excel. Vous pouvez également spécifier l’emplacement de la mise en page lors de l’importation du JSON. Veuillez consulter le code pour convertir une chaîne JSON en fichier xlsx généré par le code à titre de référence.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Import JSON as Table 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, JsonLayoutOptions, JsonUtility, Utils } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
// Converted logic from JavaScript to browser-compatible code
const inputJson = JSON.stringify([
{ BEFORE: 'before cell', TEST: 'asd1', AFTER: 'after cell' },
{ BEFORE: 'before cell', TEST: 'asd2', AFTER: 'after cell' },
{ BEFORE: 'before cell', TEST: 'asd3', AFTER: 'after cell' },
{ BEFORE: 'before cell', TEST: 'asd4', AFTER: 'after cell' }
]);
const sheetName = "Sheet1";
const row = 3;
const column = 2;
document.getElementById('runExample').addEventListener('click', async () => {
// Create a Workbook object
const book = new Workbook();
const worksheet = book.worksheets.get(sheetName);
// set JsonLayoutOptions to treat Arrays as Table
const jsonLayoutOptions = new JsonLayoutOptions();
jsonLayoutOptions.arrayAsTable = true;
// Import JSON data into worksheet cells at specified row and column
AsposeCells.JsonUtility.importData(inputJson, worksheet.cells, row, column, jsonLayoutOptions);
// Save file to xlsx format and prepare download link
const outputData = book.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">JSON imported as table and file generated. Click the download link to get the file.</p>';
});
</script>
</html>