Public
Edited
Sep 6, 2023
Insert cell
data2
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
workbook1 = FileAttachment("2022-2023学第二学期授课计划.xlsx").xlsx()
Insert cell
workbook1.sheetNames
Insert cell
data1 = workbook1.sheet(0, {
headers: false,
// range: "A1:J10"
})
Insert cell
Select a data source…
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
workbook = FileAttachment("Laser_Report_2020.xlsx").xlsx()
Insert cell
Insert cell
sheet1 = workbook.sheet("Laser Report 2020")
Insert cell
Insert cell
Inputs.table(sheet1)
Insert cell
sheet1
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
workbook.sheetNames
Insert cell
Insert cell
Insert cell
workbook.sheet(0) // the first sheet of the workbook
Insert cell
Insert cell
partial = workbook.sheet(0, { headers: true, range: "C1:J" }) // from cell C1 to column J, last row
Insert cell
Insert cell
Insert cell
data = workbook.sheet(0, { headers: true, range: ":J" })
Insert cell
Insert cell
data
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
{
const zip = await FileAttachment("reports.zip").zip();
const workbook = await zip.file("Laser_Report_2020.xlsx").xlsx();
return workbook.sheet(0, { headers: true, range: ":J" });
}
Insert cell
Insert cell
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