{"action":"opened","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/9208","labels_url":"https://api.github.com/repos/pydata/pandas/issues/9208/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/9208/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/9208/events","html_url":"https://github.com/pydata/pandas/issues/9208","id":53684841,"number":9208,"title":"read_excel drops columns when reading a one row file with a MultiIndex","user":{"login":"maxgrenderjones","id":6059365,"avatar_url":"https://avatars.githubusercontent.com/u/6059365?v=3","gravatar_id":"","url":"https://api.github.com/users/maxgrenderjones","html_url":"https://github.com/maxgrenderjones","followers_url":"https://api.github.com/users/maxgrenderjones/followers","following_url":"https://api.github.com/users/maxgrenderjones/following{/other_user}","gists_url":"https://api.github.com/users/maxgrenderjones/gists{/gist_id}","starred_url":"https://api.github.com/users/maxgrenderjones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maxgrenderjones/subscriptions","organizations_url":"https://api.github.com/users/maxgrenderjones/orgs","repos_url":"https://api.github.com/users/maxgrenderjones/repos","events_url":"https://api.github.com/users/maxgrenderjones/events{/privacy}","received_events_url":"https://api.github.com/users/maxgrenderjones/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-01-07T21:32:12Z","updated_at":"2015-01-07T21:32:12Z","closed_at":null,"body":"I'm seeing the weirdest error.\r\n\r\nWhen I read an excel file with only one row (example below)...\r\n![image](https://cloud.githubusercontent.com/assets/6059365/5653615/b8ae57ca-96b3-11e4-8a9d-25e716d2a122.png)\r\n... and try to set the `index_col`, then pandas incorrectly reads the columns:\r\n\r\nI.e. for a file with only one row, column headers A, B, C, D, E, F\r\n\r\n```python \r\npandas.read_excel(filename, 'Sheet1', index_col=['A', 'B', 'C'])\r\n```\r\nYields\r\n![image](https://cloud.githubusercontent.com/assets/6059365/5653647/0f8f049a-96b4-11e4-89bc-6d5d355dbde8.png)\r\n(I get an index with columns A, B, C, and a dataframe with columns B, D, F - what happened to E?)\r\n\r\nRelevant versions:\r\n`pandas version 0.15.1 running on 2.7.7 |Anaconda 2.0.1 (64-bit)| (default, Jun 11 2014, 10:40:02) [MSC v.1500 64 bit (AMD64)]`\r\n`xlrd.__VERSION__`=0.9.3"}}