Anyone know of a tool that can extract the calculation/dependency DAG from an Ex... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		snthpy on April 12, 2019 \| parent \| context \| favorite \| on: Google makes BigQuery available in Sheets 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 on April 12, 2019 | [–]

https://formulas.readthedocs.io/en/stable/

snthpy on April 12, 2019 | | [–]

Thank you, thank you, thank you. That is exactly what I was looking for.

prepend on April 12, 2019 | [–]

Excel is just a zip of xml so your graph is in there already. Just xslt it to whatever format you prefer.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact