1
2
3
4
5
6
7
8
9
import pandas as pd
import xlwings as xw

app = xw.App(add_book=False)
wb = app.books.open(name+'\\Rshimmer\\制价\\规范\\表\\1-沪天.xlsx')
sht = wb.sheets.active
sht.range('A40').options(index=True).value = df
wb.save(name+'\\Rshimmer\\制价\\规范\\表\\1-沪天.xlsx')
app.quit()