xlsxwriter_pandasformula

Bring your excel formulas under version control using the xlsxwriter python extension to jmcnamara/XlsxWriter!

impression

Run and see example.py for details on usage

python3 example.py

tested under Ubuntu 22.04 and Win10, pyhton 3.10.6, pandas 1.5.1, xlsxwriter 3.0.3 numpy 1.23.5

Formulas not calculated - Libreoffice calc does not recalculate formulas by default. You can either enable auto-recalculation in Tools/Options/LibreOffice Calc/Formula/Excel 2007 and Newer/Always recalculate, or just press Ctrl-Shift-F9.
I want to reference a view in another sheet - The example show the use of the sheetref=True optional argument, which should be used when referring to another sheet.

Name		Name	Last commit message	Last commit date
Latest commit History 22 Commits
.github/workflows		.github/workflows
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
example.py		example.py
exampleinput.csv		exampleinput.csv
xlsxwriter_pandasformula.py		xlsxwriter_pandasformula.py