pycel
pycel copied to clipboard
High RAM consumption when evaluating a formula
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 is just 200MB+
I would like to know how does evaluate
work. Does it read through every single cell?
How can I prevent high RAM consumption when evaluating a formula?