{"action":"created","issue":{"url":"https://api.github.com/repos/jennybc/sanesheets/issues/3","repository_url":"https://api.github.com/repos/jennybc/sanesheets","labels_url":"https://api.github.com/repos/jennybc/sanesheets/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/jennybc/sanesheets/issues/3/comments","events_url":"https://api.github.com/repos/jennybc/sanesheets/issues/3/events","html_url":"https://github.com/jennybc/sanesheets/issues/3","id":177477708,"number":3,"title":"Multiple sheets in one file","user":{"login":"sjackman","id":291551,"avatar_url":"https://avatars.githubusercontent.com/u/291551?v=3","gravatar_id":"","url":"https://api.github.com/users/sjackman","html_url":"https://github.com/sjackman","followers_url":"https://api.github.com/users/sjackman/followers","following_url":"https://api.github.com/users/sjackman/following{/other_user}","gists_url":"https://api.github.com/users/sjackman/gists{/gist_id}","starred_url":"https://api.github.com/users/sjackman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sjackman/subscriptions","organizations_url":"https://api.github.com/users/sjackman/orgs","repos_url":"https://api.github.com/users/sjackman/repos","events_url":"https://api.github.com/users/sjackman/events{/privacy}","received_events_url":"https://api.github.com/users/sjackman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":37,"created_at":"2016-09-16T17:23:41Z","updated_at":"2016-09-21T18:46:22Z","closed_at":null,"body":"I'd like to have multiple sheets in one file to keep data and metadata together in one file. This suggests that we need a container format to keep multiple TSV files together in one file. We could use an off-the-shelf container format, such as tar or zip. I would like however for the container format to be a plain text format to enable editing the entire document in a text editor and checking it into version control. I'm going to some requirements below, and then a random assortment of formats that came to mind.\r\n\r\n1. A plain text container file format that contains multiple plain text files\r\n2. Can contain TSV, CSV and Markdown PSV (pipe-separated values)\r\n3. Can contain any plain text file, particularly Markdown (and RMarkdown)\r\n4. Each embedded plain text file has a name (like a sheet name or file name)\r\n5. Editable by a human with a plain text editor\r\n6. Aesthetically pleasing"},"comment":{"url":"https://api.github.com/repos/jennybc/sanesheets/issues/comments/248705480","html_url":"https://github.com/jennybc/sanesheets/issues/3#issuecomment-248705480","issue_url":"https://api.github.com/repos/jennybc/sanesheets/issues/3","id":248705480,"user":{"login":"sjackman","id":291551,"avatar_url":"https://avatars.githubusercontent.com/u/291551?v=3","gravatar_id":"","url":"https://api.github.com/users/sjackman","html_url":"https://github.com/sjackman","followers_url":"https://api.github.com/users/sjackman/followers","following_url":"https://api.github.com/users/sjackman/following{/other_user}","gists_url":"https://api.github.com/users/sjackman/gists{/gist_id}","starred_url":"https://api.github.com/users/sjackman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sjackman/subscriptions","organizations_url":"https://api.github.com/users/sjackman/orgs","repos_url":"https://api.github.com/users/sjackman/repos","events_url":"https://api.github.com/users/sjackman/events{/privacy}","received_events_url":"https://api.github.com/users/sjackman/received_events","type":"User","site_admin":false},"created_at":"2016-09-21T18:46:21Z","updated_at":"2016-09-21T18:46:21Z","body":"> Also for anything other than trivial data, you'll need to compress the contents in order to email, so that means you'll need a layer on top of mime.\r\n\r\nGmail's file size attachment limit is 25 MB. That's good enough I would hazard for many typical Excel spreadsheets without being compressed (though XLSX is compressed). Larger files can be transferred via a link on Dropbox, same for any data file larger than the e-mail attachment limit."}}
{"actor":{"display_login":"sjackman"}}