os.system(r"taskkill /f /im excel.exe & taskkill /f /im wps.exe")
app = xw.App(visible=False, add_book=False)
wb = app.books.add()
for i in range(3):
sht = wb.sheets.add(str(i)) # 工作表名为字符串
sht.range('A1').value = i
print(wb.sheets[0].name) # 第一个工作表为最新插入的工作表
wb.save(r'd:\test.xlsx')
wb.close()
app.kill()
ser_记录错误的卷号 = df_clean.set_index('索引').loc[
df_dup_计数.pivot_table(
index=['索引', '时间值', '料温值'],
values=['料温计数'],
aggfunc='count'
).query("料温计数<2").reset_index()['索引']
]['卷号']
import xlwings as xw
app = xw.App(visible=False, add_book=False)
wb = app.books.add()
for i, j in dict_df.items():
if '卷号' not in j.columns:
df_i = j.query("K34 in @ser_记录错误的卷号")
sht = wb.sheets.add(i)
sht.range('A1').value = df_i
else:
df_i = j.query("卷号 in @ser_记录错误的卷号")
sht = wb.sheets.add(i)
sht.range('A1').value = df_i
wb.save(r'd:\test.xlsx')
wb.close()
app.kill()