koala
koala copied to clipboard
vallettea
Transpose your Excel calculations into python for better performances and scaling.
Bumps [lxml](https://github.com/lxml/lxml) from 4.1.1 to 4.9.1. Changelog Sourced from lxml's changelog. 4.9.1 (2022-07-01) Bugs fixed A crash was resolved when using iterwalk() (or canonicalize()) after parsing certain incorrect input. Note...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
Dumps sheets, cells and formulae from graph to xlsx Todo: handle ranges, test with larger & more complex sheets, ? Specific case: ``` ‘’’Create workbook and spreadsheet instance’’’ >>> from...
Hi Apologies if this has been answered somewhere, but I went through the docs and couldn't find anything related to saving changes I make to a spreadsheet to a new...
Hi Everyone, I have a vested interest in increasing Koala's maintainability. My project FlyingKoala relies on Koala and I am trying to start a business off the back of it....
I upgraded my python version from 3.6 to 3.7. The code below throws error: ``` from koala.ExcelCompiler import ExcelCompiler from koala.Spreadsheet import Spreadsheet sp = Spreadsheet("data/Data Warehouse T-Shirt Size.xlsx") ```...
Hi, I am handling yet another Excel spreadsheet and I naively thought I could use koala to do some calculations with it. However, koala complains (rightly I believe) with this...
Formulae such as `--("A"="B")` cause `IndexError` in `koala/ast/__init__.py:build_ast` due to "double operator" Workaround until fix: replace `--` with `1*` in workbook Example minimum reproduction: [double_minus.xlsx](https://github.com/vallettea/koala/files/4934349/double_minus.xlsx) ``` def build_ast(expression, debug =...
Hello, The libray is working well but when I try to clean pointers I have an error: ``` from koala.Spreadsheet import Spreadsheet from koala.ExcelCompiler import ExcelCompiler sp = Spreadsheet(file) sp.clean_pointers()...
Could be great with support for the SUBSTITUTE function. I was able to get the substitute to work by adding the substitute function to koala/excellib.py def substitute(*args): if tuple(flatten(args)) !=...
