search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
647 stars 116 forks source link

Handle cells of type FORMULA in Cell.asDate() #335

Closed r3mv closed 8 months ago

r3mv commented 9 months ago

As the name says. I had an excel files with dates computed with respect to other dates (e.g. add 1 hour to an original date). FastExcel would throw an ExcelReaderException with "wrong cell type" while it could handle type FORMULA with the same code. I modified the code and completed the tests to handle this case

samuelexyz commented 8 months ago

Hi, can I know which version it will be implemented in?

ochedru commented 8 months ago

Sorry for the delay. Thank you for your PR!