java poi读取excel公式，返回计算值

http://blog.csdn.net/CYZERO/article/details/6573015

经测试，确实可以

 1 package hrds.zpf.poi;  2  3  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  4  import org.apache.poi.hssf.usermodel.HSSFSheet;  5  import org.apache.poi.hssf.usermodel.HSSFRow;  6  import org.apache.poi.hssf.usermodel.HSSFCell;  7  8 import java.io.*;  9 10 public class FormulaToString { 11 12     /** 13      * @param args 14      */ 15     public void fileInput() throws IOException { 16 17         HSSFWorkbook hw = new HSSFWorkbook(new FileInputStream( 18                 "d:/My Documents/Desktop/poi.xls")); 19         HSSFSheet hsheet = hw.getSheet("poi test"); 20         HSSFRow hrow = hsheet.getRow(0); 21         HSSFCell hcell = hrow.getCell(0); 22         String cellValue = this.getCellValue(hcell); 23         System.out.println(cellValue); 24 25     } 26 27     public String getCellValue(HSSFCell cell) { 28         String value = null; 29         if (cell != null) { 30             switch (cell.getCellType()) { 31             case HSSFCell.CELL_TYPE_FORMULA: 32                 // cell.getCellFormula(); 33                 try { 34                     value = String.valueOf(cell.getNumericCellValue()); 35                 } catch (IllegalStateException e) { 36                     value = String.valueOf(cell.getRichStringCellValue()); 37                 } 38                 break; 39             case HSSFCell.CELL_TYPE_NUMERIC: 40                 value = String.valueOf(cell.getNumericCellValue()); 41                 break; 42             case HSSFCell.CELL_TYPE_STRING: 43                 value = String.valueOf(cell.getRichStringCellValue()); 44                 break; 45             } 46         } 47 48         return value; 49     } 50 51     public static void main(String[] args) { 52         try { 53             // TODO Auto-generated method stub 54             FormulaToString fts = new FormulaToString(); 55             fts.fileInput(); 56         } catch (IOException e) { 57             e.printStackTrace(); 58         } 59     } 60 61 }