{"action":"created","issue":{"url":"https://api.github.com/repos/hadley/readxl/issues/8","labels_url":"https://api.github.com/repos/hadley/readxl/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/hadley/readxl/issues/8/comments","events_url":"https://api.github.com/repos/hadley/readxl/issues/8/events","html_url":"https://github.com/hadley/readxl/issues/8","id":62906294,"number":8,"title":"Optional anchor and ncol","user":{"login":"smbache","id":6285210,"avatar_url":"https://avatars.githubusercontent.com/u/6285210?v=3","gravatar_id":"","url":"https://api.github.com/users/smbache","html_url":"https://github.com/smbache","followers_url":"https://api.github.com/users/smbache/followers","following_url":"https://api.github.com/users/smbache/following{/other_user}","gists_url":"https://api.github.com/users/smbache/gists{/gist_id}","starred_url":"https://api.github.com/users/smbache/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smbache/subscriptions","organizations_url":"https://api.github.com/users/smbache/orgs","repos_url":"https://api.github.com/users/smbache/repos","events_url":"https://api.github.com/users/smbache/events{/privacy}","received_events_url":"https://api.github.com/users/smbache/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":18,"created_at":"2015-03-19T07:42:08Z","updated_at":"2015-04-02T05:56:51Z","closed_at":null,"body":"It would be nice to be able to specify where the rectangular data part is located within a sheet (some people like to have \"non-data\" related things in their sheets too). One way could be to specify the top-left anchor cell, say \"D5\", and optionally the number of columns to use."},"comment":{"url":"https://api.github.com/repos/hadley/readxl/issues/comments/88751806","html_url":"https://github.com/hadley/readxl/issues/8#issuecomment-88751806","issue_url":"https://api.github.com/repos/hadley/readxl/issues/8","id":88751806,"user":{"login":"jennybc","id":599454,"avatar_url":"https://avatars.githubusercontent.com/u/599454?v=3","gravatar_id":"","url":"https://api.github.com/users/jennybc","html_url":"https://github.com/jennybc","followers_url":"https://api.github.com/users/jennybc/followers","following_url":"https://api.github.com/users/jennybc/following{/other_user}","gists_url":"https://api.github.com/users/jennybc/gists{/gist_id}","starred_url":"https://api.github.com/users/jennybc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jennybc/subscriptions","organizations_url":"https://api.github.com/users/jennybc/orgs","repos_url":"https://api.github.com/users/jennybc/repos","events_url":"https://api.github.com/users/jennybc/events{/privacy}","received_events_url":"https://api.github.com/users/jennybc/received_events","type":"User","site_admin":false},"created_at":"2015-04-02T05:56:51Z","updated_at":"2015-04-02T05:56:51Z","body":"@hadley \r\n\r\nIn a branch, I isolated the the cell specification functions and refactored them to have no dependencies:\r\n\r\nhttps://github.com/jennybc/googlesheets/blob/cell-range-specification/R/cell-specification.R\r\n\r\nIt's basically 3 pairs of functions:\r\n\r\n  * `letter_to_num()` <--> `num_to_letter()` for converting column IDs, e.g., `ABD` <--> 732\r\n  * `A1_to_RC()` <--> `RC_to_A1()` for converting between positioning notation, e.g, `AB10` <--> `R10C28`\r\n  * `convert_range_to_limit_list()` <--> `convert_limit_list_to_range()` for, e.g., `A1:C4` <--> `list(`min-row` = 1, `min-col` = 1, `max-row` = 4, `max-col` = 3)`\r\n\r\nI wanted to check back in before going further. Hopefully this get things rolling, to settle on user-facing bits. I don't export any of the above.\r\n\r\nTests are here:\r\n\r\nhttps://github.com/jennybc/googlesheets/blob/cell-range-specification/tests/testthat/test-cell-specification.R"}}