通过python读取Outlook共享日历时出现问题

Question

我尝试创建一个应用程序来从Outlook共享日历中读取事件。我在win10上使用Python 3.8.0。这是我执行此操作的功能。

 def getSharedCalendarEntries(TS_name, days=1000): #TS_name is name of shared calendar
        MailboxToAccess = '[e-mail]'
        Outlook = win32com.client.Dispatch("Outlook.Application")
        namespace = Outlook.GetNamespace("MAPI")
        recipient = namespace.createRecipient(MailboxToAccess)
        resolved = recipient.Resolve()
        sharedCalendar = namespace.GetSharedDefaultFolder(recipient, 9).Folders(TS_name).Items 
        sharedCalendar.Sort("[Start]")
        sharedCalendar.IncludeRecurrences = 'True'
        today = datetime.datetime(2019,1,1)
        begin = today.date().strftime('%d/%m/%Y')
        tomorrow = datetime.timedelta(days=days)+today
        end = tomorrow.date().strftime('%d/%m/%Y')
        sharedCalendar = sharedCalendar.Restrict("[Start] >= '" +begin+ "' AND [END] <= '" +end+ "'")
        events = {'Start':[],'End':[],'Subject':[],'Duration':[]}
        mEv = []
        for app in sharedCalendar: #petla po rezerwacjach
            adate = datetime.datetime(app.Start.year, app.Start.month, app.Start.day).date()
            events['Start'].append(adate)
            aend = datetime.datetime(app.End.year, app.End.month, app.End.day).date()
            events['End'].append(aend)
            events['Duration'].append(int(app.Duration/1440))
            events['Subject'].append(app.Subject)
            mEvent = Event(adate, aend, int(app.Duration/1440), app.Subject)
            mEv.append(mEvent)
        return mEv

一切正常，我能够读取事件，但是突然发生了一些事情(我没有更改代码中的任何内容(，并且我有这样的错误：

文件 "C：\Users\user_catalog\Desktop\outread.py"，第 60 行，位于 获取共享日历条目 共享日历 = 命名空间。GetSharedDefaultFolder(收件人，9(。文件夹(TS_name(。项目

文件 "C：\Users\user_catalog\AppData\Local\Programs\Python\Python38\lib\site-packages\win32com\client\dynamic.py"， 第 197 行，在呼叫返回self._get_good_object_(self.奥利奥布。Invoke(*allArgs(，self.olerepr.defaultDispatchName，None( pywintypes.com_error： (-2147352567， 'Exception happen.'， (4096， "Microsoft Outlook"、" 尝试执行操作失败。 2147221233找不到对象。

我对共享日历具有只读访问权限。共享日历的所有者说她注销了网络，注销的时间与我的应用程序停止工作的时间相同。

你们中有人遇到过这样的问题或对我有一些提示吗？ 提前谢谢你！

皮奥

Answer 1

你介意试试下面的代码吗？它将为您提供一个包含主题、会议发生次数、开始时间和结束时间的数据帧。

import win32com.client, datetime
import pandas as pd
from datetime import time, timedelta
#connect to outlook
outlook = win32com.client.Dispatch("Outlook.Application").GetNamespace("MAPI")
appointments  = outlook.GetDefaultFolder(9).Items #Calendário
#use these 2 lines to short the list
appointments.Sort('[Start]')
#Recurrent events  only show the first start date, use the following to get the REAL occurrence of the event.
appointments.IncludeRecurrences = 'True'
#Beginning of the week(monday) to end of week(friday)
today = datetime.date.today()
start = today - timedelta(days=today.weekday())
end = start + timedelta(days=5)
#String of restriction time that will be used to filter dates on outlook
restriction = "[Start] >= '" + start.strftime("%d/%m/%Y") + "' AND [End] < '" +end.strftime("%d/%m/%Y") + "'"
print(restriction)
restrictedItems = appointments.Restrict(restriction)

#create empty data frame with columns to be fetched
i = 0
calendario = pd.DataFrame(columns=['Subject', 'When', 'Start Time','End Time'])

#Loop on items to fill the dataframe
for appointmentItem in restrictedItems:
    
    calendario.loc[i] = [appointmentItem.Subject,appointmentItem.Start.strftime("%m/%d/%Y"),appointmentItem.Start.strftime("%H:%M"),appointmentItem.End.strftime("%H:%M")] 
    i = i + 1
#display dataframe   
calendario