title: getting incorrect value from excel using apache poi
body: <p>in excel the value of column is 10101101010000000000 but when im reading it in java using POI the value is changed to 10101101009999999000, can anyone give me an idea on whats going on and how can i get the exact values from the excel.
  i've tried setting the celltype as string and use <code>cell.getStringCellValue()</code> and also this <code>new BigDecimal(cell.getNumericCellValue()).toPlainString()</code> but im still not getting the same value as with the excel</p>
  
  <p>here's my code</p>
  
  <pre><code>List&lt;BankClassVo&gt; data = new ArrayList&lt;BankClassVo&gt;();
      FileInputStream fis = new FileInputStream(new File(Constant.VALIDATION_REFERENCE_FILE_PATH + Constant.BANK_CLASSIFICATION_REF_FILE + ".xlsx"));
      XSSFWorkbook myWorkBook = new XSSFWorkbook(fis);
      XSSFSheet mySheet = myWorkBook.getSheetAt(1);
      Iterator&lt;Row&gt; rowIterator = mySheet.iterator();
  
  
      while (rowIterator.hasNext()) {
          Row row = rowIterator.next();
          Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
  
          BankClassVo vo = new BankClassVo ();
  
  
              while (cellIterator.hasNext()) {
                  Cell cell = cellIterator.next();
                  if (cell.getColumnIndex() == 0) {
                      vo.setsClass(new BigDecimal(cell.getNumericCellValue()).toPlainString());
                  }
                  else if (cell.getColumnIndex() == 1) {
                      vo.setClassification(cell.getStringCellValue());
                  }
              }
  
          data.add(vo);
      }
  
      myWorkBook.close();
      return data;
  </code></pre>