pycel
pycel copied to clipboard
dgorissen
A library for compiling excel spreadsheets to python code & visualizing them as a graph
#### What actually happened I have a workbook with a circular formula chain. The workbook has iterative calculations disabled when received (I cannot change this). I've used Pycel's iterative calculations...
I have a 2.11MB of Excel file. When using pycel for evaluating the formula. The script's RAM consumption is 4GB+. When I evaluate a ~400kb's Excel file the RAM consumption...
@thecapacity In a72203a0d you change the GPL-v3 licensing of this project to Public-Domain. IANAL, but I believe you are not entitled to that, although your motives are kind. My understanding...
While the difference may be so great that it would make more sense to start from scratch: What would it take to make pycel work with LibreOffice Calc?
As far as I can tell it is not possible to use "defined names" in the `set_value` and `evaluate` methods. ``` excel = ExcelCompiler(filename='simple.xlsx') excel.evaluate('together') ``` ``` Traceback (most recent...
#### What actually happened [Please include the full traceback if there was an exception] Traceback (most recent call last): File "/opt/homebrew/lib/python3.11/site-packages/pycel/excelformula.py", line 923, in eval_func excel_formula.compiled_lambda()) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/homebrew/lib/python3.11/site-packages/pycel/excelformula.py", line...
In order to create an xlsx importer for [pyspread](https://pyspread.gitlab.io/), I am trying to convert the formula `=AVERAGE($C$1:$C$3)` into Python code. I am getting the code `average(_R_("C1:C3"))`. However, I would expect...
I have a spreadsheet with lots of range calculations (Sumif). This is an example Excel formula: `=IF($Q13=0,0,IF(OR($D13>X$7,X$11=$X$3,SUMIF($D$12:$D12,">="&$X$3,X$12:X12),SUMIF($D$12:$D12,"=" & _C_("BS4 Schedule!X3"), _R_("BS4 Schedule!X12:X13")), sumif(_R_("BS4 Schedule!D12:D13"), "
- [x] tests added / passed - [x] passes ``tox`` Compile changes in #155 & #139
