Add formula evaluator

Created originally on Bitbucket by seongwoopark (Seongwoo Park)

Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.

I needed the function to evaluate the excel formula, so I have written this code for evaluator.

The evaluator works based on tokenizer and given worksheet. You can see the basic idea at the top of source code.

Currently, it is only possible to evaluate very basic excel functions, but it seems to be fine as the baseline.

Unit test with following command is passed.

python -m pytest openpyxl/formula/tests/test_evaluator.py

To improve performance, I put TODO things in the issues from my forked repository.

I hope that you will review this PR and answer to me. If you have any questions, please let me know.

Merge request reports

Loading