Public
Edited
Feb 12, 2023
1 star
Insert cell
Insert cell
Insert cell
clientId = "134940173616-9idertc5irfihj7jv49gb7msejjctu1t.apps.googleusercontent.com"
Insert cell
table(data, {
colHeaders: true,
rowHeaders: true,
formulas: {
engine: hf,
sheetName: "Sheet1"
}
})
Insert cell
Insert cell
data = sheet.getRange("Sheet1!A:Z")
Insert cell
sheet = spreadsheet("1-FPnBFFILAsweQV7Cg_MZUgelDxequaJzHeshzgOuCA")
Insert cell
hf = HyperFormula.buildEmpty()
Insert cell
valueRenderOption = "FORMULA"
Insert cell
responseValueRenderOption = "FORMULA"
Insert cell
import { gapi, authButton } with { clientId } from "@gnestor/google-auth"
Insert cell
import { spreadsheet } with {
gapi,
valueRenderOption,
responseValueRenderOption
} from "@gnestor/google-sheets"
Insert cell
import { table } from "@gnestor/table"
Insert cell
import { HyperFormula } from "@gnestor/hyperformula"
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