例如,我想取表格中的2月和4月的数据,请问怎么用python提取呢?
谢谢各位大佬
使用循环判断日期并提起对应的数据
data_path = r'C:\Users\W\Desktop\豆瓣瓣\视频合成\输入小时分钟视频剪辑\裁剪工作表.xlsx'
data = xlrd.open_workbook(data_path)
wb = load_workbook(filename=data_path) ##读取路径
ws = wb["Sheet1"] ##读取名字为Sheet1的sheet表
ss = int(ws.max_row)##读取表格长度
print(ss)
sheet = data.sheet_by_index(0)
for i in range(2, ss):
A = sheet.cell_value(i, 0)
B = sheet.cell_value(i, 1)
print(int(A), int(B))