Published
Edited
Nov 10, 2021
Insert cell
# Excel Mysteries
Insert cell
fa = FileAttachment("alpha-vantage-listing-result.xlsx")
Insert cell
ab = fa.arrayBuffer()
Insert cell
ab.byteLength
Insert cell
This workbook has a non-empty sheet array (look in the prototype)
Insert cell
wb = {
const wb2 = new exceljs.Workbook();
wb2.xlsx.load(ab);
return wb2;
}
Insert cell
Insert cell
worksheets = wb.worksheets
Insert cell
exceljs = require("exceljs")
Insert cell

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.
Learn more