DOC: Improve excel docs
I simply updated the docs to reflect that `xlrd` handles reading of both `.xls` and `.xlsx` files, and I updated docstrings affected functions by #4131 so that their docstrings stand on their own.  
