IO ExcelFile New Method
…frame access

- [ ] closes #xxxx
- [ ] tests added / passed
- [ ] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit) for how to run them
- [ ] whatsnew Added method to ExcelFile class to read all the sheets. This allows the users to access a dictionary of all pd.DataFrames using the .sheets() method and access them more easily. Before, you would need to then call a pd.read_excel(ExcelFile, sheet_name) to access the data in that sheet. 

Thanks for the contribution, but it appears your diff includes many files which doesn't seem intended.

We recommend following this guide for contributing: https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#working-with-the-code

Also, is this feature associated with a reported issue in the tracker? We require an issue and discussion on feature requests before proceeding, so closing this for now.

Let us know if you need help Definitely some insights would be helpful! First time trying to do something like this so not surprised it didn't pan out. 


I added a method to the pd.ExcelFile class that reads all the sheets. I have found when I use this class, having this method helps my code be more succinct on the front end. I figured I would try and take a stab at making an update. 

It sounds like I need to:

Start an issue and have a discussion and then if there is support, submit my change according to more stringent guidelines. 

One quick question I hope can be answered: should I just fork the io.excel._base.py file or the entire package when making a small update?

Any help would be appreciated!


"""
def sheets(self):
        return {sheet: read_excel(self._io, sheet_name = sheet) for sheet in self._reader.sheet_names}
""" > One quick question I hope can be answered: should I just fork the io.excel._base.py file or the entire package when making a small update?

Yes please clone the entire repository as documentation and tests, which are in different locations, would need updating if this feature is accepted.