pycel
pycel copied to clipboard
dgorissen
A library for compiling excel spreadsheets to python code & visualizing them as a graph
Hello! I just wanted to first clarify that we'd be open to paying contributors to help optimize this for us. Please let me know if this is of interest. If...
- [x] tests added / passed - [x] passes ``tox`` Added implementations for ADDRESS, COUNTA, COUNTBLANK, COLUMNS, ROWS, FILTER, and a few financial functions (IRR, PMT, PPMT). The financial functions...
Just a short PR to add the two basic random functions: RAND and RANDBETWEEN. I used numpy.random module to generate the random numbers so no further dependencies added. - [x]...
#### Problem description When I match the string value, the result is incorrect. #### What actually happened ``` ============================= test session starts ============================= collecting ... collected 3 items test_lookup.py::test_match_for_string[1-lookup_array0-1-3] test_lookup.py::test_match_for_string[B-lookup_array1-1-3]...
#### What actually happened I loaded an `ExcelCompiler` model from an `openpyxl` `Workbook` using the `excel` attribute of `ExcelCompiler` and got different and wrong results depending on the order in...
This pull request isn't in any way ready for merging but is more of an idea I'd like to get feedback on and if this is something you'd consider for...
#### What actually happened and expected behavior Sorry, this is probably more a question than an issue, but I'm trying to use the `excel_helper` decorator and it's not behaving the...
- [x] closes #136 - [x] tests added / passed - [x] passes ``tox`` Previously, we had the following behavior for variations of `'=SUM(Sheet2!A1:A2)'`: ```python from openpyxl import Workbook wb...
#### What happened and code sample This doesn't seem like a big deal but wanted to document it. In a situation where we write a formula having an unnecessary space...