Issue reading dates with "spreadsheet-reader" in php
<p>I'm using the <strong><a href="https://github.com/nuovo/spreadsheet-reader" rel="nofollow">spreadsheet-reader</a></strong> to read some <code>.xls</code> and <code>.xlsx</code> and convert them to <code>.csv</code>.</p>

<p>This is my simplified code:</p>

<pre><code>require_once(dirname(__FILE__) . '/../ext/spreadsheet-reader/SpreadsheetReader.php');
require_once(dirname(__FILE__) . '/../ext/spreadsheet-reader/php-excel-reader/excel_reader2.php');

$pCsvPath =  Config::$generatedCSVPath . "/" . str_replace(array(".xlsx", ".xls"), ".csv", $pFileName);

$csv = fopen($pCsvPath, "w");

$pReader = new SpreadsheetReader($pFilePath);

// Read only the first sheet
$pSheets = $pReader -&gt; Sheets();
$pReader -&gt; ChangeSheet(0);

foreach ($pReader as $row)
{
    fputcsv($csv, $row);
}
</code></pre>

<p>Everything's ok, but I'm having problems with the dates.</p>

<p>There's a column on the <code>.xls</code> / <code>.xlsx</code> files with the following format <code>2015-02-10</code>
When I write them to <code>.csv</code>, the output of this column is <code>2015201520152015-FebFeb-TueTue</code>.</p>

<p>How can I convert it to <code>.csv</code> using the code I post above but maintaining the date as the correct format (<code>2015-02-10</code>)?</p>

<p>Thanks in advance.</p>

<p><strong>EDIT:</strong> If I manually change the dates from <code>2015-01-01</code> to <code>01-01-2015</code> (put the year at the end) the dates are parsed correctly. If there's no way to save the date as <code>2015-01-01</code>, how can I change that row to the correct format (year at the end) using the code I post above? <br></p>

<p>I know I can parse a date manually, but not using the code above, as everything gets loaded when I call the <code>$pReader = new SpreadsheetReader($pFilePath)</code> function and there's no way to manipulate <em>only</em> the date.</p>