search

monitorjbl / excel-streaming-reader

An easy-to-use implementation of a streaming Excel reader using Apache POI
Apache License 2.0
960 stars 345 forks source link

Cell value with type "Formula string (str)" placed between double quotation marks #133

Open nmsakos opened 6 years ago

nmsakos commented 6 years ago

Hi,

In our Excel file we have cells which are containing formulas, which are evaluated into strings. During processing such cells we found that these values are placed between double quotation marks by the StreamingSheetReeder.

I want to understand the root cause and the need for this behavior. Can it turned off somehow?

Btw, the library is awesome, and saved us!

Thanks! Akos

imranzahid01 commented 6 years ago

I would like to know the reason behind this as well?

hansih91 commented 6 years ago

same question here

hariharansethu commented 6 years ago

I too need help on this. How to retrieve the value which has a formula in its cell .

CMemorY180819 commented 5 years ago

same question here