Owner of Hammies, former Jupyter core developer and co-lead of Jupyter Notebook and JupyterLab teams
es-reactLeaflet DemoLeafletReactHandsontable DemoGoogle Auth and Google Sheets TestHandsontable ScrollingGoogle Auth APIGoogle Drive APIJSBarcodeAvery 5160 Barcode Labels TemplateGoogle Sheets with Formulae DemoTable Utilities DemoLocal Storage Table DemoLocal Storage TableGoogle Sheet TableTable UtilitiesSystemJSTipTapreact-json-formTailwind ComponentsHyperformulaCodeMirror componentTable DemoGrant's UtilitiesReact ComponentsJavascript Temporal APIGoogle Sheets APIGoogle Sheets API DemoFuse.jsList of countriesYahoo FinanceHandsontable for Observable
Hyperformula Demo
table(data, {
colHeaders: true,
rowHeaders: true,
formulas: {
engine: hf,
sheetName: "Sheet1"
}
})
runFormula = (formula) => {
// // Using a separate sheet
// if (hf.countSheets() < 2) {
// hf.addSheet('Queries');
// }
// hf.setCellContents({ sheet: 1, col: 0, row: 0 }, [[formula]]);
// return hf.getCellValue({ sheet: 1, col: 0, row: 0 });
// // Using named expression
// if (hf.listNamedExpressions().includes('Query')) {
// hf.changeNamedExpression('Query', formula);
// } else {
// hf.addNamedExpression('Query', formula);
// }
// return hf.getNamedExpressionValue('Query');
return hf.calculateFormula(formula, 0);
}
FormulaEditor = async (doc = '', extensions = []) => {
// https://github.com/codemirror/legacy-modes
// const { StreamLanguage } = await skypack('@codemirror/stream-parser');
// const { mathematica } = await skypack(
// '@codemirror/legacy-modes/mode/mathematica'
// );
return CodeMirror(doc, [
// StreamLanguage.define(mathematica),
...extensions
]);
}
data = {
const response = await fetch(
"//raw.githubusercontent.com/vega/vega/master/docs/data/cars.json"
);
return response.json();
}
// hf = {
// const hf = HyperFormula.buildFromArray(
// viewof dataTable.hot.getSourceDataArray(),
// {
// precisionRounding: 4,
// licenseKey: 'gpl-v3'
// }
// );
// Object.keys(data[0]).forEach((column, index) => {
// const a1 = hf
// .simpleCellAddressToString({ sheet: 0, col: index, row: 0 })
// .replace(/Sheet1!([A-Z])\d/, '$1');
// hf.addNamedExpression(column, `${a1}:${a1}`);
// });
// return hf;
// }
// hf = HyperFormula.buildFromArray(viewof dataTable.hot.getSourceDataArray(), {
// precisionRounding: 4,
// licenseKey: "gpl-v3"
// })
hf = HyperFormula.buildEmpty()
import { table } from "@gnestor/table"
import { CodeMirror, skypack } from '@gnestor/codemirror'
import { HyperFormula } from "@gnestor/hyperformula"
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.
