I'm working in CF9 and trying to use cfspreadsheet to pull the values out of an xls and write the values to a db. The xls has 4 sheets with the 4th sheet being the raw data being output from an allergen testing machine. Beneath the raw data there are formulas that are used to populate a chart on the 3rd sheet. I am trying to extract the values that are computed but when using cfspreadsheet it is returning the formula for the cell and not the computed value.
I've done some searching but have not found a solution to this issue and figured I'd throw out here and see if anyone has had to deal with this. I have come across spreadsheetGetCellValue but it does not let you specify the sheet. Is the only way to do this is to extract the entire sheet from the original and then create a new 1 page sheet from this and then use spreadsheetGetCellValue to get the value I need or is there a more streamlined solution?
