{"action":"closed","issue":{"url":"https://api.github.com/repos/wireservice/csvkit/issues/887","repository_url":"https://api.github.com/repos/wireservice/csvkit","labels_url":"https://api.github.com/repos/wireservice/csvkit/issues/887/labels{/name}","comments_url":"https://api.github.com/repos/wireservice/csvkit/issues/887/comments","events_url":"https://api.github.com/repos/wireservice/csvkit/issues/887/events","html_url":"https://github.com/wireservice/csvkit/issues/887","id":256504655,"number":887,"title":"in2csv option  --write-sheets \"-\" fails","user":{"login":"raveslave","id":1734770,"avatar_url":"https://avatars3.githubusercontent.com/u/1734770?v=4","gravatar_id":"","url":"https://api.github.com/users/raveslave","html_url":"https://github.com/raveslave","followers_url":"https://api.github.com/users/raveslave/followers","following_url":"https://api.github.com/users/raveslave/following{/other_user}","gists_url":"https://api.github.com/users/raveslave/gists{/gist_id}","starred_url":"https://api.github.com/users/raveslave/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raveslave/subscriptions","organizations_url":"https://api.github.com/users/raveslave/orgs","repos_url":"https://api.github.com/users/raveslave/repos","events_url":"https://api.github.com/users/raveslave/events{/privacy}","received_events_url":"https://api.github.com/users/raveslave/received_events","type":"User","site_admin":false},"labels":[{"id":315350593,"url":"https://api.github.com/repos/wireservice/csvkit/labels/question","name":"question","color":"c7def8","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2017-09-10T11:51:03Z","updated_at":"2017-10-26T00:58:43Z","closed_at":"2017-10-26T00:58:43Z","author_association":"NONE","body":"Getting an exception using the all sheets argument on 1.0.2\r\n_Python 2.7.13_\r\n\r\n```\r\n --write-sheets WRITE_SHEETS\r\n                        The names of the Excel sheets to write to files, or\r\n                        \"-\" to write all sheets.\r\n\r\nusing\r\nin2csv filewithmanysheets.xls --write-sheets \"-\"\r\n```\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"/usr/local/bin/in2csv\", line 11, in <module>\r\n    sys.exit(launch_new_instance())\r\n  File \"/usr/local/lib/python2.7/site-packages/csvkit/utilities/in2csv.py\", line 180, in launch_new_instance\r\n    utility.run()\r\n  File \"/usr/local/lib/python2.7/site-packages/csvkit/cli.py\", line 114, in run\r\n    self.main()\r\n  File \"/usr/local/lib/python2.7/site-packages/csvkit/utilities/in2csv.py\", line 163, in main\r\n    tables = agate.Table.from_xls(self.input_file, sheet=sheets, **kwargs)\r\n  File \"/usr/local/lib/python2.7/site-packages/agateexcel/table_xls.py\", line 30, in from_xls\r\n    book = xlrd.open_workbook(file_contents=path.read())\r\n  File \"/usr/local/lib/python2.7/site-packages/xlrd/__init__.py\", line 116, in open_workbook\r\n    with open(filename, \"rb\") as f:\r\nTypeError: coercing to Unicode: need string or buffer, NoneType found\r\n```\r\n\r\nTesting with --names on the same file works fine and outputs 13 sheet names, no blanks no unicode."}}
{"actor":{"display_login":"jpmckinney"}}