FROM: https://stackoverflow.com/questions/27556751/unprotect-an-excel-file-programmatically
安装 pywin32
def Remove_password_xlsx(filename, pw_str): xcl = win32com.client.Dispatch("Excel.Application") # pw_str为打开密码, 若无 访问密码, 则设为 '' wb = xcl.Workbooks.Open(filename, False, False, None, pw_str) xcl.DisplayAlerts = False # 保存时可设置访问密码. wb.SaveAs(filename, None, '', '') xcl.Quit()