1、安装xlrd模块
http://pypi.python.org/pypi/xlrd
2、使用介绍
(1)导入模块
import xlrd
(2)打开Excel,读取数据
workbook = xlrd.open_workbook("20142015.xls")
(3)获取工作表
table = workbook.sheets()[0]
table = data.sheet_by_index(0) #通过索引顺序获取
table = data.sheet_by_name(u'Sheet1')#通过名称获取
(4)获取行数和列数
rows = table.nrows # 行数
cols = table.ncols # 列数
(5)获取行列的值
table.row_values(i)
table.col_values(i)
(6)循环按行数据
for i in range(rows): # 按行遍历
print table.row_values(i)
(7)单元格
cell_A1 = table.cell(0,0).value
cell_C4 = table.cell(2,3).value
(8)使用行列索引
cell_A1 = table.row(0)[0].value
cell_A2 = table.col(1)[0].value
3、Demo
# -*- coding:UTF-8 -*-
import xlrd # 导入xlrd模块
def read_excel():
workbook = xlrd.open_workbook("20142015.xls") # 打开Excel文件读取数据
table = workbook.sheets()[0] # 获取一个工作表,通过索引顺序获取
rows = table.nrows # 获取工作表的行数和列数
cols = table.ncols
print "行×列:", rows, "×", cols
row = []
for i in range(rows): # 按行遍历
row.append(table.row_values(i))
print row
list = []
for i in range(len(row)): # 将Excel中的数据一个一个放入到list列表中
for j in range(cols):
list.append(row[i][j])
print list
if __name__ == "__main__":
read_excel()
4、单元格读取
# -*- coding:UTF-8 -*-
import xlrd
def read_excel():
workbook = xlrd.open_workbook("Friend.xls")
table = workbook.sheets()[0]
rows = table.nrows
cols = table.ncols
print "行×列:", rows, "×", cols
print
try:
row = []
for i in range(rows):
row.append(table.row_values[i])
print row
except Exception:
print "合并单元格读取失败!"
print
'''
合并单元格的读取不能直接使用循环来操作,只能通过索引来一个一个的读取
'''
print "采用索引读取:"
print table.col_values(4)[1]
print table.row_values(7)[2]
if __name__ == "__main__":
read_excel()
output:
行×列: 8 × 5
合并单元格读取失败!
采用索引读取:
好朋友
无