Live programming @ University of Washington
Published
Edited
Nov 23, 2020
6 forks
Importers
27 stars
xlsx = require('https://bundle.run/xlsx@0.14.1')
viewof binary = html`<input type=file>`
input = new Uint8Array(await Files.buffer(binary))
wb = xlsx.read(input, {type: 'array'})
viewof sheet_name = select({options: wb.SheetNames, title: 'Sheet name'})
ws = wb.Sheets[sheet_name]
headers = Object.keys(xlsx.utils.sheet_to_json(wb.Sheets[sheet_name])[0])
as_json = xlsx.utils.sheet_to_json(ws)
table(as_json)
out_sheet = xlsx.utils.json_to_sheet(as_json, {header: headers})
write_sheet = out_sheet => {
const wb = xlsx.utils.book_new()
xlsx.utils.book_append_sheet(wb, out_sheet, 'output')
xlsx.writeFile(wb, 'out.xlsx')
}
import {table} from "@tmcw/tables"
import {checkbox, text, select} 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.
