laravel maatwebsite excel export currency row
<p>Im using the <a href="http://www.maatwebsite.nl/laravel-excel/docs/export#format" rel="nofollow">laravel maatwebsite packag</a>e to export an excel sheet.
One column contains euro currency, so im trying to make a currency column for the data.</p>

<p>my code for the columns:</p>

<pre><code>    $sheet-&gt;setColumnFormat(array(
        'G' =&gt;  \PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00,
        'H' =&gt;  "[$EUR ]#,##0.00_-",
        'I' =&gt;  \PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE,
    ));
</code></pre>

<p>with no luck, when for example 5 (without any decimals) is inserted in one of these columns the data looks like 5 instead of € 5.00</p>

<p>How is the formating set in the correct way?</p>