forked from sheetjs/docs.sheetjs.com
24 lines
908 B
HTML
24 lines
908 B
HTML
|
<body>
|
||
|
|
<style>TABLE { border-collapse: collapse; } TD { border: 1px solid; }</style>
|
||
|
|
<div id="tavolo"></div>
|
||
|
|
<script src="https://cdn.sheetjs.com/xlsx-latest/package/dist/xlsx.full.min.js"></script>
|
||
|
|
<script type="text/javascript">
|
||
|
|
(async() => {
|
||
|
|
/* fetch and parse workbook -- see the fetch example for details */
|
||
|
|
const workbook = XLSX.read(await (await fetch("https://sheetjs.com/pres.numbers")).arrayBuffer());
|
||
|
|
|
||
|
|
let output = [];
|
||
|
|
/* loop through the worksheet names in order */
|
||
|
|
workbook.SheetNames.forEach(name => {
|
||
|
|
/* generate HTML from the corresponding worksheets */
|
||
|
|
const worksheet = workbook.Sheets[name];
|
||
|
|
const html = XLSX.utils.sheet_to_html(worksheet);
|
||
|
|
/* add a header with the title name followed by the table */
|
||
|
|
output.push(`<H3>${name}</H3>${html}`);
|
||
|
|
});
|
||
|
|
/* write to the DOM at the end */
|
||
|
|
tavolo.innerHTML = output.join("\n");
|
||
|
|
})();
|
||
|
|
</script>
|
||
|
|
</body>
|