{"action":"created","issue":{"url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/613","repository_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel","labels_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/613/labels{/name}","comments_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/613/comments","events_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/613/events","html_url":"https://github.com/Maatwebsite/Laravel-Excel/issues/613","id":120107492,"number":613,"title":"Laravel 4.2/Laravel-Excel 1.3: Numbers formatted as text still appearing as number","user":{"login":"lszanto","id":139145,"avatar_url":"https://avatars1.githubusercontent.com/u/139145?v=4","gravatar_id":"","url":"https://api.github.com/users/lszanto","html_url":"https://github.com/lszanto","followers_url":"https://api.github.com/users/lszanto/followers","following_url":"https://api.github.com/users/lszanto/following{/other_user}","gists_url":"https://api.github.com/users/lszanto/gists{/gist_id}","starred_url":"https://api.github.com/users/lszanto/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lszanto/subscriptions","organizations_url":"https://api.github.com/users/lszanto/orgs","repos_url":"https://api.github.com/users/lszanto/repos","events_url":"https://api.github.com/users/lszanto/events{/privacy}","received_events_url":"https://api.github.com/users/lszanto/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":31,"created_at":"2015-12-03T07:01:05Z","updated_at":"2017-07-28T08:29:08Z","closed_at":null,"body":"I've been playing around with this for a few days but simply cannot make it work. I have some long numbers(16 digits) stored in my database which I am then using the toArray() function to create my xlsx excel spreadsheet. The code i'm using to format the column: \n`$sheet->setColumnFormat(array( 'A' => '@' ));`\n\nHowever the numbers are being shown in excel as numbers and they are being shortened with scientific notation. \n\nIs there anything I can do about this outside of appending a space either side?\n\nI'm aware of excel's 15 digit limit however when formatting as text I was lead to believe this would not be a problem.\n"},"comment":{"url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/comments/318593757","html_url":"https://github.com/Maatwebsite/Laravel-Excel/issues/613#issuecomment-318593757","issue_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/613","id":318593757,"user":{"login":"Ra1da35ma","id":11582800,"avatar_url":"https://avatars1.githubusercontent.com/u/11582800?v=4","gravatar_id":"","url":"https://api.github.com/users/Ra1da35ma","html_url":"https://github.com/Ra1da35ma","followers_url":"https://api.github.com/users/Ra1da35ma/followers","following_url":"https://api.github.com/users/Ra1da35ma/following{/other_user}","gists_url":"https://api.github.com/users/Ra1da35ma/gists{/gist_id}","starred_url":"https://api.github.com/users/Ra1da35ma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ra1da35ma/subscriptions","organizations_url":"https://api.github.com/users/Ra1da35ma/orgs","repos_url":"https://api.github.com/users/Ra1da35ma/repos","events_url":"https://api.github.com/users/Ra1da35ma/events{/privacy}","received_events_url":"https://api.github.com/users/Ra1da35ma/received_events","type":"User","site_admin":false},"created_at":"2017-07-28T08:29:08Z","updated_at":"2017-07-28T08:29:08Z","body":"All samples here are talking about exporting to excel,\r\nhow about import from excel samples\r\n\r\n```\r\n$path = $request->file('excel')->getRealPath();\r\n$data = Excel::load($path, function ($reader) {\r\n})->get(['brand', 'model', 'batch', 'imei_1', 'imei_2']);\r\n\r\nif (!empty($data) && $total = $data->count()) {\r\n\tforeach ($data as $key => $value) {\r\n\t          $insert[] = ['brand' => $value->brand,\r\n                           'model' => $value->model,\r\n                           'batch' => $request->batch ? $request->batch : $value->batch,\r\n                           'imei_1' => strval($value->imei_1),\r\n                           'imei_2' => strval($value->imei_2),\r\n                           'created_at' => Carbon::now(),\r\n                           'updated_at' => Carbon::now()\r\n                         ];\r\n        }\r\n\t/*if (!empty($insert)) {\r\n\t\tDevice::insert($insert);\r\n\t\t// dd('Insert Record successfully.');\r\n\t}*/\r\n}\r\n```"}}
{"actor":{"display_login":"Ra1da35ma"}}