如何使用python打开受密码保护的excel文件? [英] How to open a password protected excel file using python?

问题描述

我查看了有关此主题的先前线程，但它们并没有帮助解决问题.

I looked at the previous threads regarding this topic, but they have not helped solve the problem.

• 如何在python中读取受密码保护的excel

如何打开写入使用win32com在python中保留excel文件?

我试图在没有任何用户交互的情况下在 excel 中打开受密码保护的文件.我在网上搜索，发现这段代码使用了 win32com.client当我运行这个时，我仍然得到输入密码的提示...

I'm trying to open a password protected file in excel without any user interaction. I searched online, and found this code which uses win32com.client When I run this, I still get the prompt to enter the password...

from xlrd import *
import win32com.client
import csv
import sys

xlApp = win32com.client.Dispatch("Excel.Application")
print "Excel library version:", xlApp.Version
filename,password = r"\HRAMyfile.xlsx", 'caa team'
xlwb = xlApp.Workbooks.Open(filename, Password=password)

推荐答案

我认为命名参数在这种情况下不起作用.因此，您必须执行以下操作:

I don't think that named parameters work in this case. So you'd have to do something like:

xlwb = xlApp.Workbooks.Open(filename, False, True, None, password)

请参阅 http://msdn.microsoft.com/en-us/library/office/ff194819.aspx 有关 Workbooks.Open 方法的详细信息.

See http://msdn.microsoft.com/en-us/library/office/ff194819.aspx for details on the Workbooks.Open method.

这篇关于如何使用python打开受密码保护的excel文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！