{"action":"created","issue":{"url":"https://api.github.com/repos/hadley/readxl/issues/194","repository_url":"https://api.github.com/repos/hadley/readxl","labels_url":"https://api.github.com/repos/hadley/readxl/issues/194/labels{/name}","comments_url":"https://api.github.com/repos/hadley/readxl/issues/194/comments","events_url":"https://api.github.com/repos/hadley/readxl/issues/194/events","html_url":"https://github.com/hadley/readxl/issues/194","id":168631688,"number":194,"title":"skip parameter to read_excel seems near random","user":{"login":"torbjorn","id":4111,"avatar_url":"https://avatars.githubusercontent.com/u/4111?v=3","gravatar_id":"","url":"https://api.github.com/users/torbjorn","html_url":"https://github.com/torbjorn","followers_url":"https://api.github.com/users/torbjorn/followers","following_url":"https://api.github.com/users/torbjorn/following{/other_user}","gists_url":"https://api.github.com/users/torbjorn/gists{/gist_id}","starred_url":"https://api.github.com/users/torbjorn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/torbjorn/subscriptions","organizations_url":"https://api.github.com/users/torbjorn/orgs","repos_url":"https://api.github.com/users/torbjorn/repos","events_url":"https://api.github.com/users/torbjorn/events{/privacy}","received_events_url":"https://api.github.com/users/torbjorn/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-08-01T12:13:01Z","updated_at":"2016-11-22T07:09:30Z","closed_at":null,"body":"Every time I use read_excel , the skip parameters is impossible to determine beforehand\n\nIe if I open the file in a spreadsheet application and check how many rows down before my data table starts, and then input that number into read_excel, it _never_ gets right.\n\nThe process of determining the correct skip number always ends up as follows:\n\n1) read_excel with what seems the right number\n2) head( ) the data to see how wrong it got\n3) Try to estimate new skip number from 2)\n4) Repeat until it gets right.\n\nThis is a small small issue yes, but having happened to me ~1000 times it has reached \"report-issue-on-github\" level.\n\nAlso knowing that I have to check something by hand >1 times when it _should_ be enough to check it only once, is surprisingly annoying.\n\nI dont have any good test-data to supply, if its not as easy to reproduce as the frequency of occurence should suggest, ill prepare something.\n\nT.\n"},"comment":{"url":"https://api.github.com/repos/hadley/readxl/issues/comments/262164392","html_url":"https://github.com/hadley/readxl/issues/194#issuecomment-262164392","issue_url":"https://api.github.com/repos/hadley/readxl/issues/194","id":262164392,"user":{"login":"DavoOZ","id":6334602,"avatar_url":"https://avatars.githubusercontent.com/u/6334602?v=3","gravatar_id":"","url":"https://api.github.com/users/DavoOZ","html_url":"https://github.com/DavoOZ","followers_url":"https://api.github.com/users/DavoOZ/followers","following_url":"https://api.github.com/users/DavoOZ/following{/other_user}","gists_url":"https://api.github.com/users/DavoOZ/gists{/gist_id}","starred_url":"https://api.github.com/users/DavoOZ/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DavoOZ/subscriptions","organizations_url":"https://api.github.com/users/DavoOZ/orgs","repos_url":"https://api.github.com/users/DavoOZ/repos","events_url":"https://api.github.com/users/DavoOZ/events{/privacy}","received_events_url":"https://api.github.com/users/DavoOZ/received_events","type":"User","site_admin":false},"created_at":"2016-11-22T07:09:30Z","updated_at":"2016-11-22T07:09:30Z","body":"My experience is as follows:\r\nIf the Excel file is in the older .xls format then the value of skip=n must be the total number of rows before the data (or header row).\r\nThe same file in .xlsx format requires that skip=n only includes the non-blank rows."}}
{"actor":{"display_login":"DavoOZ"}}