如何使用Python读取Excel文件（） _列标题中查找Excel列号

本文概述

Python3
Python3
Python3
Python3
Python3
Python3

使用xlrd模块, 可以从电子表格中检索信息。例如, 可以在Python中完成读取, 写入或修改数据的操作。此外, 用户可能必须浏览各种工作表并根据某些条件检索数据或修改某些行和列并进行大量工作。
rd模块用于从电子表格中提取数据。
安装xlrd模块的命令：

pip install xlrd

输入文件：

文章图片
代码1：提取特定的单元格
Python3

# Reading an excel file using Python import xlrd # Give the location of the file loc = ( "path of file" ) # To open Workbook wb = xlrd.open_workbook(loc) sheet = wb.sheet_by_index( 0 ) # For row 0 and column 0 print (sheet.cell_value( 0 , 0 ))

输出：

'NAME'

代码2：提取行数
Python3

# Program to extract number # of rows using Python import xlrd # Give the location of the file loc = ( "path of file" ) wb = xlrd.open_workbook(loc) sheet = wb.sheet_by_index( 0 ) sheet.cell_value( 0 , 0 ) # Extracting number of rows print (sheet.nrows)

输出：

4

代码3：提取列数
Python3

# Program to extract number of # columns in Python import xlrd loc = ( "path of file" ) wb = xlrd.open_workbook(loc) sheet = wb.sheet_by_index( 0 ) # For row 0 and column 0 sheet.cell_value( 0 , 0 ) # Extracting number of columns print (sheet.ncols)

输出：

3

代码4：提取所有列名称
Python3

# Program extracting all columns # name in Python import xlrd loc = ( "path of file" ) wb = xlrd.open_workbook(loc) sheet = wb.sheet_by_index( 0 ) # For row 0 and column 0 sheet.cell_value( 0 , 0 ) for i in range (sheet.ncols): print (sheet.cell_value( 0 , i))

输出：

NAME SEMESTER ROLL NO

代码5：提取第一列
Python3

# Program extracting first column import xlrd loc = ( "path of file" ) wb = xlrd.open_workbook(loc) sheet = wb.sheet_by_index( 0 ) sheet.cell_value( 0 , 0 ) for i in range (sheet.nrows): print (sheet.cell_value(i, 0 ))

输出：

NAME ALEX CLAY JUSTIN

代码6：提取特定的行值
Python3

# Program to extract a particular row value import xlrd loc = ( "path of file" ) wb = xlrd.open_workbook(loc) sheet = wb.sheet_by_index( 0 ) sheet.cell_value( 0 , 0 ) print (sheet.row_values( 1 ))

输出：