{"action":"created","issue":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/584","labels_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/584/labels{/name}","comments_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/584/comments","events_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/584/events","html_url":"https://github.com/PHPOffice/PHPExcel/issues/584","id":85529824,"number":584,"title":"Can date be formatted automatically?","user":{"login":"Serhioromano","id":650741,"avatar_url":"https://avatars.githubusercontent.com/u/650741?v=3","gravatar_id":"","url":"https://api.github.com/users/Serhioromano","html_url":"https://github.com/Serhioromano","followers_url":"https://api.github.com/users/Serhioromano/followers","following_url":"https://api.github.com/users/Serhioromano/following{/other_user}","gists_url":"https://api.github.com/users/Serhioromano/gists{/gist_id}","starred_url":"https://api.github.com/users/Serhioromano/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Serhioromano/subscriptions","organizations_url":"https://api.github.com/users/Serhioromano/orgs","repos_url":"https://api.github.com/users/Serhioromano/repos","events_url":"https://api.github.com/users/Serhioromano/events{/privacy}","received_events_url":"https://api.github.com/users/Serhioromano/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-05T13:09:00Z","updated_at":"2015-06-05T15:27:52Z","closed_at":"2015-06-05T15:27:52Z","body":"I am using this example.\r\n\r\n```php\r\n$rowArray = array('Value1', 'Value2', 'Value3', 'Value4');\r\n$objPHPExcel->getActiveSheet()\r\n    ->fromArray(\r\n        $rowArray,   // The data to set\r\n        NULL,        // Array values with this value will not be set\r\n        'C3'         // Top left coordinate of the worksheet range where\r\n                     //    we want to set these values (default is A1)\r\n    );\r\n```\r\n\r\nAnd one of the values is date. I do not want to access every cell. In fact document is complex and that would be problematic. \r\n\r\nIs there any string format like ISO8601 that would be automatically formatted as date? For instance if string matches `2015-05-22T15:38:46+00:00` then it is date format.\r\n\r\nPossible?"},"comment":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/comments/109328401","html_url":"https://github.com/PHPOffice/PHPExcel/issues/584#issuecomment-109328401","issue_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/584","id":109328401,"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":"2015-06-05T15:27:51Z","updated_at":"2015-06-05T15:27:51Z","body":"Why not just apply the advanced value binder, which can recognise dates, percentages, fractions, etc and set appropriate styling..... and if you don't want fractions, percentages, etc, or want a slightly different format to be applied then create your own value binder"}}