Excel markdown table | Notable.app Plugin

Custom|JS|Editor.js

const require = (url) => {
	const head = document.getElementsByTagName('head')[0];
	const script = document.createElement('script');
	script.type = 'text/javascript';
	script.src = url;
	head.appendChild(script);
}

require("https://cdn.jsdelivr.net/npm/hyperformula/dist/hyperformula.full.min.js");

$(document).on ( 'preview:render', ()=>{
	const tables = document.querySelectorAll('table');
	if (!tables.length) return
	const sheets = [...tables].reduce((prevtable, table, TI) => ({
		...prevtable,
		['table'+TI]: [...table.rows].map((row, ri) => [...row.cells].map((cell, ci) => {
			if (cell.innerHTML.match(/^=/g)) cell.setAttribute('data-table', JSON.stringify({row: ri, col: ci, sheet: TI}))
			return cell.innerHTML;
		}))
	}), {});
	const hfInstance = HyperFormula.buildFromSheets(sheets, {licenseKey: 'gpl-v3'});
	const cellsToCalculate = document.querySelectorAll('[data-table]');
	cellsToCalculate.forEach(el => el.innerHTML = hfInstance.getCellValue({ ...JSON.parse(el.getAttribute('data-table')) }))
	
});