Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1162
  • Last Modified:

Resolving formulas in cfspreadsheet

I have a very complex spreadsheet sent to me each week containing payroll data which I need to extract.  The spreadsheet contains several sheets and the summary page contains formulas in just about every cell, but this sheet contains the data I need.

Using cfspreadsheet and outputting it I get cell values like "fnnNormalWkOrdTime($A10,$EZ10-$FF10)-$FC10".  How can I resolve the formulas to a numeric value like "8"?  (Believe it or not, that is the value from that formula!)
0
jdthedj
Asked:
jdthedj
1 Solution
 
jdthedjAuthor Commented:
Since there have been no replies I am assuming resolving formulas cannot be done using CFSpreadsheet.  I have trawled the net and found something that works for me in Java.

http://aspalliance.com/1832_Import_and_Export_Data_From_Excel_Using_ColdFusion.2
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now