Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Resolving formulas in cfspreadsheet

Posted on 2010-08-24
1
Medium Priority
?
1,159 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
[X]
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
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

636 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