{"action":"created","issue":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/698","labels_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/698/labels{/name}","comments_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/698/comments","events_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/698/events","html_url":"https://github.com/PHPOffice/PHPExcel/issues/698","id":110724027,"number":698,"title":"CSV Dates Written Differently Depending on Reader File Format","user":{"login":"ComputerTinker","id":9611807,"avatar_url":"https://avatars.githubusercontent.com/u/9611807?v=3","gravatar_id":"","url":"https://api.github.com/users/ComputerTinker","html_url":"https://github.com/ComputerTinker","followers_url":"https://api.github.com/users/ComputerTinker/followers","following_url":"https://api.github.com/users/ComputerTinker/following{/other_user}","gists_url":"https://api.github.com/users/ComputerTinker/gists{/gist_id}","starred_url":"https://api.github.com/users/ComputerTinker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ComputerTinker/subscriptions","organizations_url":"https://api.github.com/users/ComputerTinker/orgs","repos_url":"https://api.github.com/users/ComputerTinker/repos","events_url":"https://api.github.com/users/ComputerTinker/events{/privacy}","received_events_url":"https://api.github.com/users/ComputerTinker/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2015-10-09T19:40:45Z","updated_at":"2016-01-01T11:23:31Z","closed_at":"2015-10-15T17:23:59Z","body":"I've created a very simple php script which reads in either an XLSX or XLS file, and then exports the file content to CSV. Here's the guts of the program, which you've seen many times before:\r\n\r\n```php\r\n$objReader = PHPExcel_IOFactory::createReader($cExcelFileType);\r\n$objSpreadsheet = $objReader->load($cExcelFileName);\r\n$objWriter = PHPExcel_IOFactory::createWriter($objSpreadsheet, \"CSV\");\r\n$objWriter->save($cCsvFileName);\r\n```\r\n\r\nWhat's interesting is that if I read in an XLS file and then output a CSV, dates are written in dd/mm/yyyy format as expected. However, if I read in an XLSX file and output a CSV, the dates are written out as integers.  I would have expected the CSV file to be written out using date strings regardless of the import format."},"comment":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/comments/168302399","html_url":"https://github.com/PHPOffice/PHPExcel/issues/698#issuecomment-168302399","issue_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/698","id":168302399,"user":{"login":"MarkBaker","id":770298,"avatar_url":"https://avatars.githubusercontent.com/u/770298?v=3","gravatar_id":"","url":"https://api.github.com/users/MarkBaker","html_url":"https://github.com/MarkBaker","followers_url":"https://api.github.com/users/MarkBaker/followers","following_url":"https://api.github.com/users/MarkBaker/following{/other_user}","gists_url":"https://api.github.com/users/MarkBaker/gists{/gist_id}","starred_url":"https://api.github.com/users/MarkBaker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MarkBaker/subscriptions","organizations_url":"https://api.github.com/users/MarkBaker/orgs","repos_url":"https://api.github.com/users/MarkBaker/repos","events_url":"https://api.github.com/users/MarkBaker/events{/privacy}","received_events_url":"https://api.github.com/users/MarkBaker/received_events","type":"User","site_admin":false},"created_at":"2016-01-01T11:23:31Z","updated_at":"2016-01-01T11:23:31Z","body":"No, nor do I.... and I'm not likely to be able to guess. I have no idea what filetype you're loading, or what it really contains; so you're giving me no clues to try and figure it out either\r\n\r\nHijacking a closed question isn't a good way of asking either"}}