问题描述
我正在为python学习win32com，但遇到了一个奇怪的问题.
i'm learning win32com for python and I've got a strange problem.
我正在尝试在词典列表中导出Outlook联系人.我的代码与win32com.client.Dispatch("Outlook.Application)完美配合.但是，它与win32com.client.gencache.EnsureDispatch(" Outlook.Application)返回0个联系人，该联系人应该更快，更安全".这是我的代码:
I'e trying to export Outlook Contacts in a List of Dictionnary. My code works perfectly with win32com.client.Dispatch("Outlook.Application). But it returns 0 contacts with win32com.client.gencache.EnsureDispatch("Outlook.Application) that is supposed to be faster and "safer". Here's my code :
class MapiImport():
def __init__(self):
self.olApp = win32com.client.Dispatch("Outlook.Application")
self.namespace = self.olApp.GetNamespace(u"MAPI")
# olFolderContacts = 10 :
self.mapiContacts = self.namespace.GetDefaultFolder(10).Items
def getContacts(self, *fields):
contacts = []
# Class == 40 is ContactItem
# Class == 69 is DistListItem
# Exclude ditribution list and others objects != ContactItem
for contact in filter(lambda x: x.Class == 40,self.mapiContacts) :
if not fields :
ctact = dict((x.Name,x.Value) for x in contact.ItemProperties)
else :
ctact = {}
for field in fields :
itemProp = contact.itemProperties[field]
ctact[field] = itemProp.Value
contacts.append(ctact)
return contacts
#====TEST SCRIPT====
myMAPI = MapiImport()
fields = (u"LastName",u"FirstName",u"Companies",
u"HomeTelephoneNumber",u"Home2TelephoneNumber",
u"MobileTelephoneNumber",
u"BusinessTelephoneNumber",u"Business2TelephoneNumber",
u"Email1Address",u"Email2Address",u"Email3Address",
u"HomeAddress",u"BusinessAddress",
u"Birthday",u"Anniversary",
u"Body")
print(myMAPI.getContacts(*fields))
所以当我替换时:
olApp = win32com.client.Dispatch("Outlook.Application")
使用:
olApp = win32com.client.gencache.EnsureDispatch("Outlook.Application")
它返回此错误:
Traceback (most recent call last):
File "D:\Documents and Settings\da7950\Mes documents\Dropbox\cheetahImporter\mapiImport.py", line 42, in <module>
print(myMAPI.getContacts(*fields))
File "D:\Documents and Settings\da7950\Mes documents\Dropbox\cheetahImporter\mapiImport.py", line 19, in getContacts
for contact in filter(lambda x: x.Class == 40,self.mapiContacts) :
File "D:\Documents and Settings\da7950\Mes documents\Python27\lib\site-packages\win32com\gen_py\00062FFF-0000-0000-C000-000000000046x0x9x2\_Items.py", line 122, in __getitem__
return self._get_good_object_(self._oleobj_.Invoke(*(81, LCID, 1, 1, item)), "Item")
com_error: (-2147352567, "Une exception s'est produite.", (4096, u'Microsoft Office Outlook', u'Index de la matrice en dehors des limites.', None, 0, -2147352567), None)
该消息表示矩阵索引超出范围".最令人头疼的是，在我调用了suredispatch之后，win32com.client.Dispatch不再起作用.我必须卸载pywin32并重新安装...
The message means "Matrix index out of bounds". The strangiest thing is that after I called EnsureDispatch, win32com.client.Dispatch doesn't works anymore. I have to uninstall pywin32 and reinstall it...
我正在使用32位版本的Python2.7.3和Outlook 2007 32位版本
I'm running with Python2.7.3 64-bit with Outlook 2007 32-bit
谢谢
推荐答案
我找到了解决方案.这是win32com makepy的错误...
I found a solution. It's a bug win32com makepy...
主要问题是Outlook是基于olContactItem的基于1的索引(相对于python的基于0的索引)
The main problem is that Outlook is 1-based indexed for olContactItem (as opposed to 0-based index for python)
olApp = win32com.client.gencache.EnsureDispatch("Outlook.Application")
namespace = olApp.GetNamespace(u"MAPI")
# olFolderContacts = 10 :
mapiContacts = namespace.GetDefaultFolder(10).Items
for i in range(1,len(mapiContacts)+1) :
contact = self.mapiContacts[i]
...
contact.itemProperties还有另一个问题.所有属性都使用EnsureDispatch区分大小写，因此:
There is another problem with contact.itemProperties. All properties are case sensitive with EnsureDispatch, so :
contact.ItemProperties("FullName").Value
# ^
有效，但无效:
contact.itemProperties("FullName").Value
# ^
要正确使用名称，请咨询: Microsoft Outlook ContactItem MSDN上的参考模型
To get the names right, consult: Microsoft Outlook ContactItem reference model on MSDN
这篇关于win32com.client.Dispatch有效，但win32com.client.gencache.EnsureDispatch不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！