import xlwt import xlrd excel = xlrd.open_workbook("1实时数据-2022-05-17.xls") #打开excel表 sheet1_name= excel.sheet_names()[0] #列表形式存储每个sheet的名称,这里选择对sheet1进行操作 sheet1 = excel.sheet_by_name(sheet1_name) #通过sheet的名称获取sheet的内容 cols1 = sheet1.col_values(0) # 获取第1列内容list # one = [] one_1 = [] for index, name in enumerate(cols1): if name == 'F12-3.6': # one.append(name) one_1.append(index) elif name == 'F12-4.0': one_1.append(index) # print(one_1) wbk = xlwt.Workbook(encoding='utf-8') sheet = wbk.add_sheet('Sheet1', cell_overwrite_ok=True) i= 0 for y in one_1: y = sheet1.row_values(y) # print(y) for j in range(0,len(y)): sheet.write(i,j,y[j]) i = i + 1 wbk.save('12号风机.xls')
python提取excel内容
最新推荐文章于 2024-07-01 09:17:46 发布