Hi, I'm going nuts trying to retrieve VALUES out of an Excel 2007 workbook with ColdFusion 9. What's happening is that I'm getting the 'formulas' instead of the 'values'. The formulas are 'cross sheet' formulas (meaning they refer to another sheet in the same workbook). I'm assuming this has something to do with the difficulty.
Here's what I've tried so far: 1. reading sheet in with <cfspreadsheet> into a query. 2. reading sheet in with SpreadsheetRead into an object and then using SpreadsheetGetCellValue() to get the cell value. 3. I've updated the POI jar's in my CF 9 installation with 3.8 POI jar's from Apache 4. I've tried using Ben Nadel's POI Utility, but I get an object instantiation error on this line: LOCAL.ExcelFileSystem = CreateObject( "java", "org.apache.poi.poifs.filesystem.POIFSFileSystem" ).Init( LOCAL.FileInputStream ); (I've confirmed that I'm using the full path (as is indicated on his website) I'm at a loss of how else to get this data out of the spreadsheet. Has someone had success with this and, if so, what can I do? Thanks, Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
