from openpyxl import load_workbook
workbook=load_workbook('位置移动.xlsx')
sheet=workbook.active
sheet.move_range("G1:H2",rows=2,cols=-1)# 向下移动两行，向左移动一列
workbook.save(filename='test.xlsx')
print("输出成功！")
from openpyxl import load_workbook
workbook=load_workbook('位置移动.xlsx')
sheet=workbook.active
sheet.move_range("G1:H2",rows=2,cols=-1)# 向下移动两行，向左移动一列
workbook.save(filename='test.xlsx')
print("输出成功！")
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
