如何使用xlrd读取Excel文件中'Student Name'列的数据？

Hey there! Let's walk through exactly how to use xlrd to extract data from the 'Student Name' column in your Excel file. I'll break it down step by step so it's easy to follow.

Step 1: Install xlrd (if you haven't already) #

First, make sure you have the library installed. Open your terminal or command prompt and run this command:

pip install xlrd

Quick heads up: xlrd versions 2.0 and above only support older .xls files. If you're working with a .xlsx file, you'll need to install version 1.2.0 instead:

pip install xlrd==1.2.0

Step 2: Write the code to extract the column data #

Here's a complete, ready-to-use example that loads your Excel file, locates the 'Student Name' column, and pulls all its values:

import xlrd

# Replace 'your_file.xls' with the actual path to your Excel file
workbook = xlrd.open_workbook('your_file.xls')

# Select the worksheet you want to use—either by index or name
# For index: worksheet = workbook.sheet_by_index(0) (first sheet)
# For name: worksheet = workbook.sheet_by_name('Sheet1')
worksheet = workbook.sheet_by_index(0)

# Find which column has the 'Student Name' header (assuming header is in row 0)
header_row = worksheet.row_values(0)
student_name_col_idx = header_row.index('Student Name')

# Extract all student names, skipping the header row
student_names = []
for row_num in range(1, worksheet.nrows):
    name = worksheet.cell_value(row_num, student_name_col_idx)
    student_names.append(name)

# Print the result to check it works
print("Student Names:", student_names)

What each part does: #

• We start by importing xlrd and opening your Excel file with xlrd.open_workbook().
• We pick the worksheet you need—use sheet_by_index() if you know the position, or sheet_by_name() if you know the sheet's exact name.
• We grab the header row to find the index of the 'Student Name' column using index()—this way we don't have to hardcode the column number.
• We loop through every row starting from 1 (skipping the header), pull the value from the correct column, and add it to our list of student names.

Reference Image #

(Swap the URL above with your actual image link if you have one)

内容的提问来源于stack exchange，提问作者deepakbhavale67