Get actual cell value of excel cell with POI without defining a datatype
<p>I catch my cells from an .xls file like this:</p>

<pre><code>cell.getStringCellValue();
</code></pre>

<p>But since some of the cells are numeric, I have to do this instead:</p>

<pre><code>                try
                {
                    cells[colIx] = cell.getStringCellValue();
                } catch (IllegalStateException e)
                {
                    cells[colIx] = String.valueOf(cell.getNumericCellValue());
                }
</code></pre>

<p>since it's getting a double and then converts it to a string this results in some unwanted operations like:</p>

<ul>
<li>1 converts into 1.0 (not that kind of a big problem)</li>
<li>16711680 converts to 1.671168E7</li>
</ul>

<p>How do I solve this and get the actual cell value instead of some converted numbers? Also, all of the cells are defined as default in excel</p>