Esporta Excel in HTML con linee di griglia via JavaScript
Contents
[
Hide
]
Se desideri esportare il tuo file Excel in HTML con linee di griglia, utilizza la proprietà HtmlSaveOptions.exportGridLines() e impostala su true.
Esportare Excel in HTML con linee della griglia
Il seguente esempio di codice crea una cartella di lavoro, riempie il suo foglio di lavoro con alcuni valori e poi lo salva in formato HTML impostando HtmlSaveOptions.exportGridLines() su true.
<!DOCTYPE html>
<html>
<head>
<title>Export To HTML With GridLines Example</title>
</head>
<body>
<h1>Export To HTML With GridLines 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, HtmlSaveOptions, SaveFormat } = 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 () => {
// Create your workbook
const wb = new Workbook();
// Access first worksheet
const ws = wb.worksheets.get(0);
// Fill worksheet with some integer values
for (let r = 0; r < 10; r++) {
for (let c = 0; c < 10; c++) {
const cell = ws.cells.get(r, c);
cell.value = r * 1;
}
}
// Save your workbook in HTML format and export gridlines
const opts = new HtmlSaveOptions();
opts.exportGridLines = true;
const outputData = wb.save(SaveFormat.Html, opts);
const blob = new Blob([outputData], { type: 'text/html' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'ExportToHTMLWithGridLines_out.html';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download HTML File';
document.getElementById('result').innerHTML = '<p style="color: green;">HTML exported successfully! Click the download link to get the file.</p>';
});
</script>
</html>