python里openpyxl的基本使用

wb = openpyxl.load_workbook('xls名字')   |       wb = Workbook()
sheet = wb.active | sheet = wb['sheet名']    |     sheet= wb.create_sheet(sheetName,0)
max_row = sheet.max_row
row_datas = sheet[5:max_row]
for row_data in row_datas:
       if row_data[5].value == 'xxx':
            print(row_data[4])

 maxRow = sheet.max_row
 maxColumn = sheet.max_column
 for i in range(1,maxRow+1):
      for j in range(1,maxColumn+1):
          sheet.cell(row=i,column=j).value = random.choice(['a','b','c','d','e'])