Is there any basic class to feed a HSSFCell containing a formula that would return the displayed value of the formula like Excel would?
We've been manually reading formula strings and writing code to explicitly look up each cell to calculate the formulas. Curve ball came our way when each new workbook has completely new formulas for roughly 60,000 workbooks. No longer feasible to manually parse these formulas, so I'm asking if there is any way to calculate the cells value without the human touch? Something where say 1 cell contains the SUM of two other cells.... Cell1=5 Cell2=5 Cell3 has the formula (Cell1 + Cell2) FormulaEvaluator.eval(cell3) = 10 Any ideas? (We have other formulas like lookups and division and such, just a simple example above) Now that they change workbook to workbook it's no longer feasible to manually grab cells to fetch values. Any help would be much appreciated. Cheers, Zach Davis Associate IT Programmer Analyst R.L. Polk Southfield Office ***************************************************************** This message has originated from R. L. Polk & Co., 26955 Northwestern Highway, Southfield, MI 48033. R. L. Polk & Co. sends various types of email communications. If this email message concerns the potential licensing of a Polk product or service, and you do not wish to receive further emails regarding Polk products, forward this email to [email protected] with the word "remove" in the subject line. The email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error, please delete this message and notify the Polk System Administrator at [email protected]. *****************************************************************
