API: default value for read_excel sheet
closes #6573

Implements a default sheetname of 0 for `read_excel` #6573. 

Before: `read_excel(io, sheetname, **kwds)`

After: `read_excel(io, sheetname=0, **kwds)`

can u add a test to validate this?
eg write a frame to a workbook with the name Sheet1 and another with the name 0
read back should work
pls follow the examples in the test_excel
 Sure, will do.

On Sat, Mar 8, 2014 at 3:49 AM, jreback notifications@github.com wrote:

> can u add a test to validate this?
> eg write a frame to a workbook with the name Sheet1 and another with the
> name 0
> read back should work
> pls follow the examples in the test_excel
> 
> ## 
> 
> Reply to this email directly or view it on GitHubhttps://github.com/pydata/pandas/pull/6576#issuecomment-37095732
> .
 @jreback Added this within the `roundtrip` test.
 @jreback Docs revised.
 all for clarity in the docs....but have to squeeze lots of things into a limited number of examples.

If you can make it more clear, by all means (but at the same time try to show as much as possible)

you can squash down  to 1 commit right before we merge
 @jreback Ok, I changed those examples back to how they were.
 ok...pls squash....

you can look at the built docs (now and a few minutes after the merged)

http://pandas-docs.github.io/pandas-docs-travis/

if you want to do a follow-up PR to fix/clarify docs...ok by me

the excel sectino COULD use some TLC!
 That's good to know about the built docs. Could we put that link in this page - http://pandas.pydata.org/developers.html#contributing-to-the-documentation

I'll squash when I get home tonight. Should I be using `rebase -i`? I don't want to make a mess for the maintainers to clean up like [last time](https://github.com/pydata/pandas/pull/6008)...
 yeh....theirs been some work on add all of this info to the main docs, see here: http://pandas.pydata.org/pandas-docs/stable/contributing.html#contributing-to-the-documentation

interactive rebase `-i` is usually best
 @jreback how does this rebase look?
 looks good!

thanks...excellent PRing!

do some more
 Glad to hear! I've got a much better handle on how to PR. Thanks @jreback for walking me through it.
