{"action":"created","issue":{"url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/72","labels_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/72/labels{/name}","comments_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/72/comments","events_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/72/events","html_url":"https://github.com/theoephraim/node-google-spreadsheet/issues/72","id":126045608,"number":72,"title":"rowCount length","user":{"login":"karlstanton","id":302968,"avatar_url":"https://avatars.githubusercontent.com/u/302968?v=3","gravatar_id":"","url":"https://api.github.com/users/karlstanton","html_url":"https://github.com/karlstanton","followers_url":"https://api.github.com/users/karlstanton/followers","following_url":"https://api.github.com/users/karlstanton/following{/other_user}","gists_url":"https://api.github.com/users/karlstanton/gists{/gist_id}","starred_url":"https://api.github.com/users/karlstanton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlstanton/subscriptions","organizations_url":"https://api.github.com/users/karlstanton/orgs","repos_url":"https://api.github.com/users/karlstanton/repos","events_url":"https://api.github.com/users/karlstanton/events{/privacy}","received_events_url":"https://api.github.com/users/karlstanton/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-11T21:54:49Z","updated_at":"2016-01-12T16:51:17Z","closed_at":null,"body":"Hi there,\r\n\r\nNoticing that the rows returned from the worksheet.getRows is different to the value returned from logging the worksheet object.\r\n\r\n```\r\nspreadsheet.useServiceAccountAuth(creds, function (err) {\r\n\t\t// Return the spreadsheet\r\n\t\tspreadsheet.getInfo(function (err, info) {\r\n\t\t\t// Loop through all the worksheets\r\n\t\t\tasync.eachSeries(info.worksheets, function (worksheet, cb) {\r\n\r\n\t\t\t\tconsole.log(worksheet);\r\n\t\t\t\t// ... worksheet.rowCount = 49 here ...\r\n\r\n\t\t\t\t// Loop through the rows\r\n\t\t\t\tworksheet.getRows({'max-results': 300}, function (err, rowData) {\r\n\t\t\t\t\tif (err) return next(err);\r\n\r\n\t\t\t\t\tconsole.log(rowData.length);\r\n\t\t\t\t\t// ... rowData.length = 16 here ...\r\n\r\n\t\t\t\t\tcb();\r\n\t\t\t\t});\r\n\t\t\t}, function (err) {\r\n\t\t\t\tdb.end(function(err) {\r\n\t\t\t\t\treturn next(null, sheetData);\r\n\t\t\t\t});\r\n\t\t\t});\r\n\t\t});\r\n\t});\r\n```\r\n\r\nAny thoughts?"},"comment":{"url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/comments/170972249","html_url":"https://github.com/theoephraim/node-google-spreadsheet/issues/72#issuecomment-170972249","issue_url":"https://api.github.com/repos/theoephraim/node-google-spreadsheet/issues/72","id":170972249,"user":{"login":"karlstanton","id":302968,"avatar_url":"https://avatars.githubusercontent.com/u/302968?v=3","gravatar_id":"","url":"https://api.github.com/users/karlstanton","html_url":"https://github.com/karlstanton","followers_url":"https://api.github.com/users/karlstanton/followers","following_url":"https://api.github.com/users/karlstanton/following{/other_user}","gists_url":"https://api.github.com/users/karlstanton/gists{/gist_id}","starred_url":"https://api.github.com/users/karlstanton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlstanton/subscriptions","organizations_url":"https://api.github.com/users/karlstanton/orgs","repos_url":"https://api.github.com/users/karlstanton/repos","events_url":"https://api.github.com/users/karlstanton/events{/privacy}","received_events_url":"https://api.github.com/users/karlstanton/received_events","type":"User","site_admin":false},"created_at":"2016-01-12T16:51:17Z","updated_at":"2016-01-12T16:51:17Z","body":"I dug into this more. The getRows method (or somewhere within) halts when it finds a row that is empty. Since my sheet has empty rows (to help format visually), this breaks. Looking into it and may have a PR soon."}}