python 获取 excel表格

mport xlrd as xr
import datetime
import xlrd as xr
import datetime
1.获取工作簿 2.通过工作薄获取工作表 3.读取行列数据

book=xr.open_workbook(“weather_expectation.xlsx”)
book
<xlrd.book.Book at 0x57cc490>
book.nsheets #获取工作表的个数
book.nsheets #获取工作表的个数
2
book.sheet_names() #获取工作表名字
[‘资源描述信息’, ‘数据集1’]
book.sheets()[1] #通过索引获取工作表
​
<xlrd.sheet.Sheet at 0x57cc550>
sheet_two=book.sheet_by_name(‘数据集1’) #通过工作表名获取工作表
sheet_two
<xlrd.sheet.Sheet at 0x57cc550>
book.sheet_loaded(‘数据集1’) #判断工作表是否存在，返回值取布尔值
True
python读取行列数据
sheet_two=book.sheet_by_index(1)
sheet_two
<xlrd.sheet.Sheet at 0x57cc550>
sheet_two.nrows #获取工作表有效总行数
7626
#第7行
sheet_two.row(6)# 获取第几行，注意 索引从0开始
sheet_two.row(6)[6:]
#运行结果
[text:‘12.png’,
text:‘27’,
text:‘33’,
text:‘0.0’,
text:‘2’,
text:‘西’,
text:‘60.0’,
text:‘85.0’,
text:’-’,
text:’-’,
text:’-’,
text:‘27’,
text:‘33’,
text:‘02_2.png’,
text:’-’,
text:‘1’,
text:‘1’,
text:‘1’,
text:‘287894’,
text:‘20150711035856’,
text:’-’,
text:’-’,
text:’-’]
sheet_two.row_slice(6,6) ## 获取第6行第6列后面的数据，注意 索引从0开始
[text:‘12.png’,
text:‘27’,
text:‘33’,
text:‘0.0’,
text:‘2’,
text:‘西’,
text:‘60.0’,
text:‘85.0’,
text:’-’,
text:’-’,
text:’-’,
text:‘27’,
text:‘33’,
text:‘02_2.png’,
text:’-’,
text:‘1’,
text:‘1’,
text:‘1’,
text:‘287894’,
text:‘20150711035856’,
text:’-’,
text:’-’,
text:’-’]
excel 中数据类型对照

ctype(类型)

0 empty(空值）

1 string(字符串）

2 number(数字）

3 date(日期）

4 boolean（布尔）

5 error(错误）

sheet_two.row_types(6,6)
array(‘B’, [1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1])
sheet_two.row_values(6,6)
[‘12.png’,
‘27’,
‘33’,
‘0.0’,
‘2’,
‘西’,
‘60.0’,
‘85.0’,
‘-’,
‘-’,
‘-’,
‘27’,
‘33’,
‘02_2.png’,
‘-’,
‘1’,
‘1’,
‘1’,
‘287894’,
‘20150711035856’,
‘-’,
‘-’,
‘-’]
python读取excel列数据
sheet_two.ncols #获取该工作表有效列
29
sheet_two.col(6,6) #获取该工作表的第6列
[text:‘12.png’,
text:‘16.png’,
text:‘02_2.png’,
text:‘16.png’,
text:‘12.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘06.png’,
text:‘09.png’,
text:‘09.png’,
text:‘09.png’,
text:‘06.png’,
text:‘06.png’,
text:‘06.png’,
text:‘06.png’,
text:‘06.png’,
text:‘06.png’,
text:‘12_2.png’,
text:‘06.png’,
text:‘06.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘16.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘06.png’,
text:‘05.png’,
text:‘05.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘07.png’,
text:‘03.png’,
text:‘13.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘03.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘05.png’,
text:‘04.png’,
text:‘02.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘12.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘09.png’,
text:‘16.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘16.png’,
text:‘13.png’,
text:‘16.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘03.png’,
text:‘12.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘05.png’,
text:‘02_2.png’,
text:‘05.png’,
text:‘06.png’,
text:‘03.png’,
text:‘03.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘04.png’,
text:‘05.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘07.png’,
text:‘07.png’,
text:‘07.png’,
text:‘03.png’,
text:‘06.png’,
text:‘04.png’,
text:‘06.png’,
text:‘09.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘06.png’,
text:‘04.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘06.png’,
text:‘14.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘07.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘06.png’,
text:‘02_2.png’,
text:‘07.png’,
text:‘06.png’,
text:‘07.png’,
text:‘06.png’,
text:‘04.png’,
text:‘06.png’,
text:‘04.png’,
text:‘06.png’,
text:‘12_2.png’,
text:‘03.png’,
text:‘03.png’,
text:‘03.png’,
text:‘03.png’,
text:‘03.png’,
text:‘03.png’,
text:‘05.png’,
text:‘07.png’,
text:‘03.png’,
text:‘07.png’,
text:‘13.png’,
text:‘06.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘06.png’,
text:‘06.png’,
text:‘06.png’,
text:‘07.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘07.png’,
text:‘07.png’,
text:‘03.png’,
text:‘03.png’,
text:‘07.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘03.png’,
text:‘02_2.png’,
text:‘03.png’,
text:‘06.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘05.png’,
text:‘05.png’,
text:‘02_2.png’,
text:‘01.png’,
text:‘01.png’,
text:‘02.png’,
text:‘12.png’,
text:‘12.png’,
text:‘01.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘07.png’,
text:‘02_2.png’,
text:‘07.png’,
text:‘07.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘12.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘13.png’,
text:‘03.png’,
text:‘03.png’,
text:‘06.png’,
text:‘03.png’,
text:‘03.png’,
text:‘02_2.png’,
text:‘03.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘06.png’,
text:‘09.png’,
text:‘09.png’,
text:‘12_2.png’,
text:‘13.png’,
text:‘07.png’,
text:‘02_2.png’,
text:‘07.png’,
text:‘12_2.png’,
text:‘03.png’,
text:‘07.png’,
text:‘07.png’,
text:‘06.png’,
text:‘07.png’,
text:‘03.png’,
text:‘05.png’,
text:‘03.png’,
text:‘04.png’,
text:‘07.png’,
text:‘03.png’,
text:‘12_2.png’,
text:‘03.png’,
text:‘02.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘04.png’,
text:‘07.png’,
text:‘04.png’,
text:‘16.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12.png’,
text:‘16.png’,
text:‘13.png’,
text:‘16.png’,
text:‘16.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘06.png’,
text:‘04.png’,
text:‘02.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘13.png’,
text:‘12.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘16.png’,
text:‘04.png’,
text:‘04.png’,
text:‘16.png’,
text:‘04.png’,
text:‘04.png’,
text:‘05.png’,
text:‘05.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘13.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘13.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘13.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘05.png’,
text:‘02_2.png’,
text:‘16.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘04.png’,
text:‘09.png’,
text:‘10.png’,
text:‘10.png’,
text:‘06.png’,
text:‘04.png’,
text:‘05.png’,
text:‘06.png’,
text:‘09.png’,
text:‘09.png’,
text:‘08.png’,
text:‘13.png’,
text:‘13.png’,
text:‘04.png’,
text:‘05.png’,
text:‘10.png’,
text:‘09.png’,
text:‘05.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘02_2.png’,
text:‘16.png’,
text:‘16.png’,
text:‘09.png’,
text:‘09.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘12.png’,
text:‘16.png’,
text:‘06.png’,
text:‘04.png’,
text:‘09.png’,
text:‘02_2.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12_2.png’,
text:‘05.png’,
text:‘10.png’,
text:‘04.png’,
text:‘13.png’,
text:‘16.png’,
text:‘12.png’,
text:‘04.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘05.png’,
text:‘13.png’,
text:‘07.png’,
text:‘04.png’,
text:‘13.png’,
text:‘05.png’,
text:‘04.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘13.png’,
text:‘07.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘07.png’,
text:‘07.png’,
text:‘08.png’,
text:‘08.png’,
text:‘07.png’,
text:‘12.png’,
text:‘01.png’,
text:‘01.png’,
text:‘11.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘01.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘11.png’,
text:‘01.png’,
text:‘01.png’,
text:‘01.png’,
text:‘01.png’,
text:‘11.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘11.png’,
text:‘02.png’,
text:‘02.png’,
text:‘16.png’,
text:‘12.png’,
text:‘04.png’,
text:‘16.png’,
text:‘05.png’,
text:‘04.png’,
text:‘12.png’,
text:‘11.png’,
text:‘02.png’,
text:‘16.png’,
text:‘04.png’,
text:‘13.png’,
text:‘16.png’,
text:‘16.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘04.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘13.png’,
text:‘01.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘01.png’,
text:‘01.png’,
text:‘11.png’,
text:‘01.png’,
text:‘01.png’,
text:‘11.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘14.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘12.png’,
text:‘01.png’,
text:‘01.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘07.png’,
text:‘03.png’,
text:‘03.png’,
text:‘03.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘03.png’,
text:‘17.png’,
text:‘17.png’,
text:‘17.png’,
text:‘17.png’,
text:‘17.png’,
text:‘17.png’,
text:‘17.png’,
text:‘01.png’,
text:‘17.png’,
text:‘01.png’,
text:‘01.png’,
text:‘17.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘05.png’,
text:‘13.png’,
text:‘05.png’,
text:‘06.png’,
text:‘06.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘07.png’,
text:‘09.png’,
text:‘08.png’,
text:‘08.png’,
text:‘08.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12.png’,
text:‘02.png’,
text:‘04.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘14.png’,
text:‘14.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘03.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘04.png’,
text:‘04.png’,
text:‘06.png’,
text:‘16.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘13.png’,
text:‘16.png’,
text:‘05.png’,
text:‘13.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘06.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘13.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘06.png’,
text:‘04.png’,
text:‘04.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘13.png’,
text:‘16.png’,
text:‘06.png’,
text:‘04.png’,
text:‘13.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘05.png’,
text:‘05.png’,
text:‘13.png’,
text:‘05.png’,
text:‘04.png’,
text:‘04.png’,
text:‘04.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘07.png’,
text:‘16.png’,
text:‘13.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘05.png’,
text:‘13.png’,
text:‘05.png’,
text:‘04.png’,
text:‘06.png’,
text:‘08.png’,
text:‘08.png’,
text:‘06.png’,
text:‘06.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12_2.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02_2.png’,
text:‘07.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12_2.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘09.png’,
text:‘02.png’,
text:‘04.png’,
text:‘02.png’,
text:‘04.png’,
text:‘12.png’,
text:‘13.png’,
text:‘05.png’,
text:‘05.png’,
text:‘08.png’,
text:‘05.png’,
text:‘06.png’,
text:‘06.png’,
text:‘04.png’,
text:‘06.png’,
text:‘02.png’,
text:‘13.png’,
text:‘06.png’,
text:‘06.png’,
text:‘13.png’,
text:‘02_2.png’,
text:‘05.png’,
text:‘05.png’,
text:‘05.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘01.png’,
text:‘12.png’,
text:‘09.png’,
text:‘08.png’,
text:‘09.png’,
text:‘09.png’,
text:‘08.png’,
text:‘08.png’,
text:‘06.png’,
text:‘09.png’,
text:‘02_2.png’,
text:‘04.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘04.png’,
text:‘09.png’,
text:‘09.png’,
text:‘04.png’,
text:‘13.png’,
text:‘13.png’,
text:‘04.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘02.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘11.png’,
text:‘12.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘13.png’,
text:‘04.png’,
text:‘04.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘11.png’,
text:‘13.png’,
text:‘16.png’,
text:‘12.png’,
text:‘11.png’,
text:‘16.png’,
text:‘16.png’,
text:‘16.png’,
text:‘12.png’,
text:‘05.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘12.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘06.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘10.png’,
text:‘06.png’,
text:‘02_2.png’,
text:‘02.png’,
text:‘12.png’,
text:‘02.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘13.png’,
text:‘04.png’,
text:‘05.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘02_2.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘10.png’,
text:‘10.png’,
text:‘06.png’,
text:‘06.png’,
text:‘09.png’,
text:‘02_2.png’,
text:‘06.png’,
text:‘07.png’,
text:‘07.png’,
text:‘13.png’,
text:‘04.png’,
text:‘02_2.png’,
text:‘12_2.png’,
text:‘04.png’,
text:‘02.png’,
text:‘04.png’,
text:‘12_2.png’,
text:‘17.png’,
text:‘07.png’,
text:‘17.png’,
…]
​
#读取当前行了行列单元格数据

table.cell(rowx.colx)#返回当前行列单元格内容

table.cell_value(rowx,colx)#返回当前行列单元格数值

table.cell_type(rowx,colx) #返回当前行列单元格的类型

table.merged_cells #返回所有合并后的单元格的缩影

table.merged_cell

NameError Traceback (most recent call last)
in
----> 1 table.merged_cell

NameError: name ‘table’ is not defined

import xlrd as xr
import datetime
book=xr.open_workbook(‘class_info.xls’)
table=book.sheet_by_index(0)
row_num=table.nrows
col_num=table.ncols
key=table.row_values(0)
key
[‘姓名’, ‘年龄’, ‘语言’, ‘考试时间’]
for i in range(1,row_num):
for j in range(col_num):
c_value=table.cell(i,j).value
# print(c_value)
c_type=table.cell_type(i,j)
print(c_value,c_type)

张三 1
22.0 2
Python 1
43907.0 3
李四 1
21.0 2
Python 1
43908.0 3
王五 1
20.0 2
Python 1
43907.0 3
刘六 1
18.0 2
Python 1
43908.0 3
for i in range(1,row_num):
table_date={} #空字典
for j in range(col_num):
c_value=table.cell(i,j).value
# print(c_value)
c_type=table.cell_type(i,j)
# print(c_value,c_type)
if c_type == 2 and c_value%1==0:
c_value=int(c_value)
#print(c_value)
elif c_type == 3:
#print(c_value)
year,moutb,day,hour,minute,second = xr.xldate_as_tuple(c_value,1)
c_value=datetime.datetime(year,moutb,day,hour,minute,second)
print(c_value)

2024-03-18 00:00:00
2024-03-19 00:00:00
2024-03-18 00:00:00
2024-03-19 00:00:00
​

​