首先openpyxl庫(kù)沒有自帶的刪除行列的函數(shù)，網(wǎng)上搜到的如下函數(shù)是錯(cuò)的

ws.inster_row(1)
ws.delete_row(1)

因此我們自定義一個(gè)刪除行或列的函數(shù)，下面以刪除行為例，刪除列同理

import openpyxl
def deleterows(sheet,row_num):
  for row in range(row_num, sheet.max_row):
    for column in range(sheet.max_column):
      sheet[row][column].value = sheet[row + 1][column].value
  for cell in list(sheet.rows)[sheet.max_row - 1]:
    cell.value = None

if __name__=="__main__":
  wb = openpyxl.load_workbook('testbook1.xlsx')
  sheet =wb.active
  deleterows(sheet,1)
  wb.save('testbook2.xlsx')