Published
Edited
Feb 1, 2021
md`# xlsx-populate parse and set style demo`
XlsxPopulate = require('https://bundle.run/xlsx-populate@1.21.0')
dataFileWithBorder = FileAttachment("crime_2016.xlsx")
workbook = XlsxPopulate.fromDataAsync(await dataFileWithBorder.blob())
{
b2;
workbook.sheet(0).usedRange().style('border', true);
workbook.outputAsync()
.then(function (blob) {
if (window.navigator && window.navigator.msSaveOrOpenBlob) {
// If IE, you must uses a different method.
window.navigator.msSaveOrOpenBlob(blob, "out.xlsx");
} else {
var url = window.URL.createObjectURL(blob);
var a = document.createElement("a");
document.body.appendChild(a);
a.href = url;
a.download = "out.xlsx";
a.click();
window.URL.revokeObjectURL(url);
document.body.removeChild(a);
}
})
}
import {button} from "@jashkenas/inputs"
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
