Hi All,
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