Storing/Using sheet name when reading excel #756
Description
At present (0.37.3), when we read excel the name associated with table object is the file name. Can we change this behavior and instead save the sheet name (atleast when reading multi sheet excel)?
I had a use case to search by sheet name and had to make changes in the current XlsxReader for this.
Current
book1.xlsx
A | B |
-------------
1 | 56 |
2 | 78 |
3 | 100 |
4 | 122 |
5 | 144 |
6 | 166 |
book1.xlsx
C | D |
------------
4 | 12 |
5 | 32 |
6 | 52 |
7 | 72 |
Proposed
sheet1
A | B |
-------------
1 | 56 |
2 | 78 |
3 | 100 |
4 | 122 |
5 | 144 |
6 | 166 |
sheet2
C | D |
------------
4 | 12 |
5 | 32 |
6 | 52 |
7 | 72 |