Pandas: Looking up the list of sheets in an excel file

by

You can still use the ExcelFile class (and the sheet_names attribute):

xl = pd.ExcelFile('foo.xls')

xl.sheet_names  # see all sheet names

xl.parse(sheet_name)  # read a specific sheet to DataFrame

see docs for parse for more options…

More Related Contents:

  1. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  2. How to obtain sheet names from XLS files without loading the whole file?
  3. Insert row into Excel spreadsheet using openpyxl in Python
  4. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  5. How to write to an existing excel file without breaking formulas with openpyxl?
  6. Extract the data and modify an existing excel with openpyxl
  7. How to write to an existing excel file without overwriting data (using pandas)?
  8. Convert Excel style date with pandas
  9. Save list of DataFrames to multisheet Excel spreadsheet
  10. Editing workbooks with rich text in openpyxl
  11. How to concatenate three excels files xlsx using python?
  12. Get formula from Excel cell with python xlrd
  13. Error: Unsupported format, or corrupt file: Expected BOF record
  14. pandas xlsxwriter, format table header – not sheet header
  15. Refresh Excel External Data with Python
  16. How can I see the formulas of an excel spreadsheet in pandas / python?
  17. Copy pandas dataframe to excel using openpyxl
  18. How to find the last row in a column using openpyxl normal workbook?
  19. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  20. how to write to a new cell in python using openpyxl
  21. From password-protected Excel file to pandas DataFrame
  22. Leave dates as strings using read_excel function from pandas in python
  23. Putting many python pandas dataframes to one excel worksheet
  24. Python openpyxl data_only=True returning None
  25. Pandas: Reading Excel with merged cells
  26. Edit existing excel workbooks and sheets with xlrd and xlwt
  27. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  28. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  29. Get cell color from .xlsx
  30. Appending Pandas DataFrame to existing Excel document

Leave a Comment