{"action":"created","issue":{"url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/324","labels_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/324/labels{/name}","comments_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/324/comments","events_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/324/events","html_url":"https://github.com/Maatwebsite/Laravel-Excel/issues/324","id":55395156,"number":324,"title":"Formatting troubles","user":{"login":"devinfd","id":468399,"avatar_url":"https://avatars.githubusercontent.com/u/468399?v=3","gravatar_id":"","url":"https://api.github.com/users/devinfd","html_url":"https://github.com/devinfd","followers_url":"https://api.github.com/users/devinfd/followers","following_url":"https://api.github.com/users/devinfd/following{/other_user}","gists_url":"https://api.github.com/users/devinfd/gists{/gist_id}","starred_url":"https://api.github.com/users/devinfd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devinfd/subscriptions","organizations_url":"https://api.github.com/users/devinfd/orgs","repos_url":"https://api.github.com/users/devinfd/repos","events_url":"https://api.github.com/users/devinfd/events{/privacy}","received_events_url":"https://api.github.com/users/devinfd/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2015-01-25T03:38:25Z","updated_at":"2015-07-15T10:55:04Z","closed_at":"2015-02-16T16:13:41Z","body":"I've tried not to bother you with this but I am getting no where so I'm afraid I have to ask for help.\r\nI'm having two issues with Maatwebsite/Laravel-Excel / PHPExcel that I can not find an answer to and I'm hoping that somebody out there can help.\r\n\r\n1. I'm importing a csv and one of the columns has numbers in it with leading zeros that keep getting trimmed off. How can I prevent that? Preferable I would like all values to be treated as strings and not have the values manipulated at all.\r\n\r\n```php\r\nExcel::load($filePath)->toArray();\r\n```\r\n\r\n2. I'm also exporting a csv that must have an empty last column in each row. The problem is that, that column is dropped on export. If I add a space as the value then it remains but unfortunately I need the value to be empty."},"comment":{"url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/comments/121576253","html_url":"https://github.com/Maatwebsite/Laravel-Excel/issues/324#issuecomment-121576253","issue_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/324","id":121576253,"user":{"login":"jackbraj","id":7742756,"avatar_url":"https://avatars.githubusercontent.com/u/7742756?v=3","gravatar_id":"","url":"https://api.github.com/users/jackbraj","html_url":"https://github.com/jackbraj","followers_url":"https://api.github.com/users/jackbraj/followers","following_url":"https://api.github.com/users/jackbraj/following{/other_user}","gists_url":"https://api.github.com/users/jackbraj/gists{/gist_id}","starred_url":"https://api.github.com/users/jackbraj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jackbraj/subscriptions","organizations_url":"https://api.github.com/users/jackbraj/orgs","repos_url":"https://api.github.com/users/jackbraj/repos","events_url":"https://api.github.com/users/jackbraj/events{/privacy}","received_events_url":"https://api.github.com/users/jackbraj/received_events","type":"User","site_admin":false},"created_at":"2015-07-15T10:55:04Z","updated_at":"2015-07-15T10:55:04Z","body":"I am using this same syntax but it simply ignores numeric columns.\r\nWhat I want is force all cells to be string type when reading.\r\n\r\nI tried to implement this solution but it isn't working it simply skips all numeric columns"}}