xlwings清理excel内容及设置sheet背景颜色

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)