It should be possible to call the getCellFormula() method on an HSSFCell object to recover a String encapsulating the formula the cell contained. Before doing this you should check of course to ensure that you are dealing with a formula cell.
--- On Tue, 10/14/08, Ernest Tam <[EMAIL PROTECTED]> wrote: From: Ernest Tam <[EMAIL PROTECTED]> Subject: Formula of a cell To: [email protected] Date: Tuesday, October 14, 2008, 10:05 PM Dear all: I am also new to this e-mail group. I have a project which requires to extract the business logic from Excel document i.e. the formula of cells. Of course , there will be data in the Excel too. Is there any way to get formula of a cell through POI API. Thanks in advance. Ernie Tam --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
