How to obtain sheet names from XLS files without loading the whole file?

by

you can use the xlrd library and open the workbook with the “on_demand=True” flag, so that the sheets won’t be loaded automaticaly.

Than you can retrieve the sheet names in a similar way to pandas:

import xlrd
xls = xlrd.open_workbook(r'<path_to_your_excel_file>', on_demand=True)
print xls.sheet_names() # <- remeber: xlrd sheet_names is a function, not a property

More Related Contents:

  1. Pandas: Looking up the list of sheets in an excel file
  2. How to write to an existing excel file without overwriting data (using pandas)?
  3. Append existing excel sheet with new dataframe using python pandas
  4. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  5. GroupBy results to dictionary of lists
  6. Convert Excel style date with pandas
  7. Pandas cannot open an Excel (.xlsx) file
  8. Import multiple excel files into python pandas and concatenate them into one dataframe
  9. Could pandas use column as index?
  10. python xlrd unsupported format, or corrupt file.
  11. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  12. append dataframe to excel with pandas
  13. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  14. Convert date from excel in number format to date format python [duplicate]
  15. drop_duplicates not working in pandas?
  16. How can I see the formulas of an excel spreadsheet in pandas / python?
  17. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  18. Merge rows based on value (pandas to excel – xlsxwriter)
  19. xlrd.biffh.XLRDError: Excel xlsx file; not supported [duplicate]
  20. Write to StringIO object using Pandas Excelwriter?
  21. Putting many python pandas dataframes to one excel worksheet
  22. Insert row into Excel spreadsheet using openpyxl in Python
  23. Pandas: Reading Excel with merged cells
  24. Identifying Excel Sheet cell color code using XLRD package
  25. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  26. Pandas: parse merged header columns from Excel
  27. Python Pandas – Read csv file containing multiple tables
  28. python: update dataframe to existing excel sheet without overwriting contents on the same sheet and other sheets
  29. How to write to an existing excel file without breaking formulas with openpyxl?
  30. Appending Pandas DataFrame to existing Excel document

Leave a Comment