CfSpreadsheet Read: Formulas being literally read as opposed to cell value

[Guest]

I am having a problem with cfspreadsheet.

I am reading an excel spreadsheet and converting it into a CSV file. I noticed that my cfspreadsheet returns formula values and not the calculated value of the cell. Is there a way to work around that? I researched this forum and other forums and similar posts had no entries/responses from the CF community. Please help.

Thank you!

[Guest]

I had the same issue and I used Ben Nadel's POI utility to read the excel file. It reads the cell values instead of the formula properly.

http://www.bennadel.com/projects/poi-utility.htm