Problem with using org.apache.poi.ss.usermodel package?

I found there is a Class in org.apache.poi.ss.usermodel. FormulaEvaluator; we can solve the above problem using this by following way.

Up vote 0 down vote favorite share g+ share fb share tw.

I am using apache poi 3.6 with java to read excel files. Initially I started with HSSF files. So, I was implementing org.apache.poi.hssf.usermodel.

*; package for all those functionalities. For Example... 1) I am using mySheet. SetForceFormulaRecalcualtion(true); => for formula must be recalculated when workbook is opened.

2)org.apache.poi.hssf.usermodel. FormulaEvaluator formulaEvaluator=new FormulaEvaluator(mySheet, myWorkBook); formulaEvaluator. EvaluateFormulaCell(cell);=> to evaluate the formula and save the result of the formula.

But I want to use these functionalities for both HSSF(.xls) and XSSF(.xlsx) formatted files. So, now I am implementing org.apache.poi.ss. Usermodel package to represent both .

Xls and . Xlsx files. But I am able to do all those function that has already done in HSSF.

But I can't do the above said 2 functionalities using this org.apache.poi.ss. Usermodel package.. please anybody having solution plz send to me... I am most awaiting for your valuable reply. Thanks & Regards, P.

SARAVANAN apache-poi link|improve this question edited Oct 18 '10 at 9:25JoseK11.9k41030 asked Oct 15 '10 at 10:38Saravanan1,241624 98% accept rate.

I found there is a Class in org.apache.poi.ss.usermodel. FormulaEvaluator; we can solve the above problem using this by following way: FormulaEvaluator formulaEvaluator = myWorkBook. GetCreationHelper().

CreateFormulaEvaluator(); formulaEvaluator. EvaluateFormulaCell(cell); I think it would be helpful to you...

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.