types-xlrd

import xlrd import os # Create a dummy .xls file for demonstration if it doesn't exist # In a real scenario, you would open an existing .xls file xls_file_path = 'example.xls' if not os.path.exists(xls_file_path): # This part requires an actual .xls file or a library to create one (e.g., xlwt) # For a runnable example without xlwt, we'll simulate opening. # In practice, ensure 'example.xls' is a valid Excel 97-2003 file. print(f"Please create a dummy Excel 97-2003 (.xls) file named '{xls_file_path}' with some data.") print("For example, put 'Hello' in A1 and 'World' in B1 of Sheet1.") # For this quickstart, we'll proceed assuming the file exists # and will raise an error if not, which is expected for `xlrd`. try: # Open the workbook (assumes example.xls exists and is an .xls file) book: xlrd.Book = xlrd.open_workbook(xls_file_path) # Get the first sheet by index sheet: xlrd.sheet.Sheet = book.sheet_by_index(0) # Read a cell value (e.g., A1, which is (0, 0)) cell_value: str = sheet.cell_value(0, 0) print(f"Value from cell A1: {cell_value}") # Iterate through rows and print values print("\nAll values in the first sheet:") for row_idx in range(sheet.nrows): for col_idx in range(sheet.ncols): cell = sheet.cell(row_idx, col_idx) print(f"({row_idx}, {col_idx}): {cell.value}", end="\t") print() except xlrd.biffh.XLRDError as e: print(f"Error opening Excel file: {e}") print("Make sure 'example.xls' is a valid Excel 97-2003 (.xls) file.") except FileNotFoundError: print(f"Error: The file '{xls_file_path}' was not found. Please create it.")