1 # -*- coding: utf-8 -*-
2 import xlrd
3 def read_excel():
4 # 打开文件
5 workbook = xlrd.open_workbook(r'E:\pycharm project\movies.xls')
6 # 获取所有sheet
7 print workbook.sheet_names() # [u'sheet1', u'sheet2']
8 #获取sheet2
9 sheet2_name= workbook.sheet_names()[1]
10 print sheet2_name
11 # 根据sheet索引或者名称获取sheet内容
12 sheet2 = workbook.sheet_by_name('Sheet2')
13 # sheet的名称，行数，列数
14 print sheet2.name,sheet2.nrows,sheet2.ncols
15 rows = sheet2.row_values(3) # 获取第四行内容
16 cols = sheet2.col_values(2) # 获取第三列内容
17 print rows
18 print cols
19 #获取单元格内容的三种方法
20 print sheet2.cell(1,0).value.encode('utf-8')
21 print sheet2.cell_value(1,0).encode('utf-8')
22 print sheet2.row(1)[0].value.encode('utf-8')
23 # 获取单元格内容的数据类型
24 print sheet2.cell(1,3).ctype
25 if __name__ == '__main__':
26 read_excel()
