{"action":"created","issue":{"url":"https://api.github.com/repos/guardian/gudocs/issues/5","repository_url":"https://api.github.com/repos/guardian/gudocs","labels_url":"https://api.github.com/repos/guardian/gudocs/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/guardian/gudocs/issues/5/comments","events_url":"https://api.github.com/repos/guardian/gudocs/issues/5/events","html_url":"https://github.com/guardian/gudocs/pull/5","id":139953880,"number":5,"title":"Use XLSX export for Google Sheets","user":{"login":"wpf500","id":2084823,"avatar_url":"https://avatars.githubusercontent.com/u/2084823?v=3","gravatar_id":"","url":"https://api.github.com/users/wpf500","html_url":"https://github.com/wpf500","followers_url":"https://api.github.com/users/wpf500/followers","following_url":"https://api.github.com/users/wpf500/following{/other_user}","gists_url":"https://api.github.com/users/wpf500/gists{/gist_id}","starred_url":"https://api.github.com/users/wpf500/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wpf500/subscriptions","organizations_url":"https://api.github.com/users/wpf500/orgs","repos_url":"https://api.github.com/users/wpf500/repos","events_url":"https://api.github.com/users/wpf500/events{/privacy}","received_events_url":"https://api.github.com/users/wpf500/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-03-10T17:09:17Z","updated_at":"2016-03-14T10:43:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/guardian/gudocs/pulls/5","html_url":"https://github.com/guardian/gudocs/pull/5","diff_url":"https://github.com/guardian/gudocs/pull/5.diff","patch_url":"https://github.com/guardian/gudocs/pull/5.patch"},"body":"I've switched the export type for Sheets from `text/csv` to XLSX (known as `application/vnd.openxmlformats-officedocument.spreadsheetml.sheet` to you and me)\r\n\r\nI've had to copy the `sheet_to_json` util from https://github.com/SheetJS/js-xlsx and modify it a bit, it didn't allow for having empty column names (doubt we need this anyway), empty values (almost certainly needed). I also added HTML entity decoding to match our current output\r\n```\r\n{\r\n  \"\": \"blah\",\r\n  \"foo\": \"\",\r\n  \"bar\": \"value &\"\r\n}\r\n```\r\ninstead of:\r\n```\r\n{\r\n  \"undefined\": \"blah\",\r\n  \"bar\": \"value &amp;\"\r\n}\r\n```\r\n#### Benefits\r\n- More resilient, e.g. allows spaces in tab names\r\n- No more rate limiting on large spreadsheets\r\n\r\n#### Possible benefits\r\nThe world is now our oyster, spreadsheet wise\r\n\r\n- Use the spreadsheet data type, e.g. express numbers as numbers in JSON, no more `parseInt` everywhere\r\n- Use spreadsheet formatting, background colours etc.?"},"comment":{"url":"https://api.github.com/repos/guardian/gudocs/issues/comments/196249729","html_url":"https://github.com/guardian/gudocs/pull/5#issuecomment-196249729","issue_url":"https://api.github.com/repos/guardian/gudocs/issues/5","id":196249729,"user":{"login":"andymason","id":11013,"avatar_url":"https://avatars.githubusercontent.com/u/11013?v=3","gravatar_id":"","url":"https://api.github.com/users/andymason","html_url":"https://github.com/andymason","followers_url":"https://api.github.com/users/andymason/followers","following_url":"https://api.github.com/users/andymason/following{/other_user}","gists_url":"https://api.github.com/users/andymason/gists{/gist_id}","starred_url":"https://api.github.com/users/andymason/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andymason/subscriptions","organizations_url":"https://api.github.com/users/andymason/orgs","repos_url":"https://api.github.com/users/andymason/repos","events_url":"https://api.github.com/users/andymason/events{/privacy}","received_events_url":"https://api.github.com/users/andymason/received_events","type":"User","site_admin":false},"created_at":"2016-03-14T10:43:24Z","updated_at":"2016-03-14T10:43:24Z","body":"Is there any risk of the new format breaking existing interactives?\r\n\r\nAside from that it looks good."}}