import xlwings as xw
import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
workbook = excel.Workbooks.Open(r'E:\Config\demo.xlsx')
# Set a password for the workbook
workbook.Password = password
# Save and close the workbook
workbook.Save()
workbook.Close()
方法2:
# book = xw.Book()
# book.api.SaveAs(r'E:\b.xlsx',Password = password )
# book.close()