赞
踩
import xlwings as xw
app = xw.App(visible=False, add_book=False)
wb = app.books.open('test.xlsx')
sht = wb.sheets[0]
清理内容,清理数据及格式
sht.range('A6:V10').clear()
设置背景色
sht.range('A6:V10').color = (255,0,255)
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。