当我运行以下代码时,会收到如下异常:
请帮助我诊断和克服这个错误。
''# NOTE: ExcelApp is a Private main form variable
Dim ReportBooks As Excel.Workbooks = ExcelApp.Workbooks
Dim ReportBook As Excel.Workbook = ReportBooks.Open(localFilename)
Dim ReportSheet As Excel.Worksheet = ReportBook.Sheets("Report")
''# Retreive data from sheet
ReleaseCOM(ReportSheet)
ReportBook.Close(True) ''# Error raised here
ReleaseCOM(ReportBook)
ReleaseCOM(ReportBooks)
注意:所有数据似乎已经被正确地检索出来。ERROR: COMException was unhandled The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))
请帮助我诊断和克服这个错误。
ReportBook.Close(True)
时,Excel 不再管理 ReportBook - 有些东西正在释放它 - 因此会出现错误。你是否尝试过在调试中添加观察器来步进代码并观察 ReportBook? - Todd Main