3 ms·
Anyone know of a tool that can extract the calculation/dependency DAG from an Excel workbook or Google sheet? Ideally I'd like a Python package that I can poin
by snthpy 8y ago
Anyone know of a tool that can extract the calculation/dependency DAG from an Excel workbook or Google sheet?
Ideally I'd like a Python package that I can point at an .xlsx file and it would give me back an object graph that replicates the values and calculations of the workbook.
- haney 8y agohttps://formulas.readthedocs.io/en/stable/ https://formulas.readthedocs.io/en/stable/
- snthpy 8y agoThank you, thank you, thank you. That is exactly what I was looking for.
- prepend 8y agoExcel is just a zip of xml so your graph is in there already. Just xslt it to whatever format you prefer.