How do you read excel sheets using index instead of name with pandas.read_excel?

Question

I know this is easily done with pandas.io.parser ExcelFile but the documentation says that they are dropping ExcelFile from future versions of pandas so I was wondering how to do this with its replacement read_excel().

The documentation says that you can use a sheet index by doing the following:

read_excel('path_to_file.xls', 0, index_col=None, na_values=['NA'])

Every time I try this I get the following error:

XLRDError: No sheet named <0>

Answer 1

I think you're on the wrong version, this feature is new to version 0.13, which hasn't been released just yet.