Thanks, Nick! On Wed, Nov 5, 2014 at 4:05 PM, Nick Burch <[email protected]> wrote:
> On Wed, 5 Nov 2014, Blake Watson wrote: > >> Is there a way to ascertain what data type a formula will return? If you >> invoke getCellType, you just get "formula". >> > > If you need to be certain, you'll need to evaluate it, and check the result > > If "what Excel last calculated this to be" is good enough, try > https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Cell.html# > getCachedFormulaResultType%28%29 > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 [email protected] <[email protected]> www.PennyMacUSA.com <http://www.pennymacusa.com/>
