Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Resolving formulas in cfspreadsheet

Posted on 2010-08-24
1
1,100 Views
Last Modified: 2012-05-10
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
Comment
Question by:jdthedj
1 Comment
 
LVL 3

Accepted Solution

by:
jdthedj earned 0 total points
ID: 33525589
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question