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

Question

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!

Anonymous · Answer

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded