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.

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact