python-excel文件读取
excel 文件读取
xlrd xlwt pandas openpyxl
openpyxl 操作excel
文件:bb.xlsx
import openpyxl # 加载工作簿 wb = openpyxl.load_workbook(r'./data/bb.xlsx') print(wb) # 指定sheet表单 sheet = wb['Sheet1'] print(sheet) # 拿单元格 值 id1=sheet['A1'].value print(id1) name = sheet.cell(row =1,column=2).value print(name) # 拿到所有值 如果没有值就会是none # 方法1 values = sheet.values for i in values: # 放在元组中 print(i) # 方法2 rows = sheet.max_row print(rows) for i in range(1,rows+1): id = sheet.cell(row =i,column=1).value name = sheet.cell(row =i,column=2).value age = sheet.cell(row =i,column=3).value sex = sheet.cell(row =i,column=4).value print(id,name,age,sex) # 读取所有的sheet sheets = wb.sheetnames print(sheets) # 读取所有的表单, for i in sheets: print(i) for j in wb[i].values: print(j) # 保存数据在表单 sheet.cell(row=1,column=5).value='结果' wb.save('./data/bb.xlsx')