search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
672 stars 122 forks source link

Evaluating Formulas #171

Closed akashraj11 closed 2 years ago

akashraj11 commented 2 years ago

Can the fastexcel reader be used to read sheets with formulas evaluated ?

I tried implementing excel file reader using Apache POI streaming reader, but using streaming reader I was not able to evaluate formulas and read. I had to implement non streaming reader using Apache POI to read sheets which has formulas, but this was throwing Java heap space error when reading excel files with more than 10 million rows.

Does the fastexcel library support reading excel files with 10 million or greater rows with formulas by evaluating Formulas while reading?

ochedru commented 2 years ago

Fastexcel reader does not evaluate formulas.