High RAM consumption when evaluating a formula

dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph

GNU General Public License v3.0

570 stars 149 forks source link

High RAM consumption when evaluating a formula #90

Open OysterD3 opened 4 years ago

OysterD3 commented 4 years ago

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?