public void Initialize() { Logger.Provider.Info("WorkbookIntelliSenseProvider.Initialize"); _xmlProvider.Initialize(); // The events are just to keep track of the set of open workbooks, var xlApp = (Application)ExcelDnaUtil.Application; xlApp.WorkbookOpen += Excel_WorkbookOpen; xlApp.WorkbookBeforeClose += Excel_WorkbookBeforeClose; xlApp.WorkbookAddinInstall += Excel_WorkbookAddinInstall; xlApp.WorkbookAddinUninstall += Excel_WorkbookAddinUninstall; lock (_workbookRegistrationInfos) { foreach (Workbook wb in xlApp.Workbooks) { var name = wb.Name; if (!_workbookRegistrationInfos.ContainsKey(name)) { WorkbookRegistrationInfo regInfo = new WorkbookRegistrationInfo(name); _workbookRegistrationInfos[name] = regInfo; regInfo.Refresh(); RegisterWithXmlProvider(wb); } } if (ExcelDnaUtil.ExcelVersion >= 14.0) { foreach (AddIn addIn in xlApp.AddIns2) { if (addIn.IsOpen && Path.GetExtension(addIn.FullName) != ".xll") { // Can it be "Open" and not be loaded? var name = addIn.Name; Workbook wbAddIn; try { // TODO: Log wbAddIn = xlApp.Workbooks[name]; } catch { // TODO: Log continue; } WorkbookRegistrationInfo regInfo = new WorkbookRegistrationInfo(name); _workbookRegistrationInfos[name] = regInfo; regInfo.Refresh(); RegisterWithXmlProvider(wbAddIn); } } } } }
public void Initialize() { Logger.Provider.Info("WorkbookIntelliSenseProvider.Initialize"); _xmlProvider.Initialize(); // The events are just to keep track of the set of open workbooks, var xlApp = (Application)ExcelDnaUtil.Application; xlApp.WorkbookOpen += Excel_WorkbookOpen; xlApp.WorkbookBeforeClose += Excel_WorkbookBeforeClose; xlApp.WorkbookAddinInstall += Excel_WorkbookAddinInstall; xlApp.WorkbookAddinUninstall += Excel_WorkbookAddinUninstall; Logger.Provider.Verbose("WorkbookIntelliSenseProvider.Initialize - Installed event listeners"); lock (_workbookRegistrationInfos) { Logger.Provider.Verbose("WorkbookIntelliSenseProvider.Initialize - Starting Workbooks loop"); foreach (Workbook wb in xlApp.Workbooks) { var name = wb.Name; Logger.Provider.Verbose($"WorkbookIntelliSenseProvider.Initialize - Adding registration for {name}"); if (!_workbookRegistrationInfos.ContainsKey(name)) { WorkbookRegistrationInfo regInfo = new WorkbookRegistrationInfo(name); _workbookRegistrationInfos[name] = regInfo; regInfo.Refresh(); RegisterWithXmlProvider(wb); } } // NOTE: This access to AddIns2 might have caused long load delays //if (ExcelDnaUtil.ExcelVersion >= 14.0) //{ // foreach (AddIn addIn in xlApp.AddIns2) // { // if (addIn.IsOpen && Path.GetExtension(addIn.FullName) != ".xll") // { // // Can it be "Open" and not be loaded? // var name = addIn.Name; // Workbook wbAddIn; // try // { // // TODO: Log // wbAddIn = xlApp.Workbooks[name]; // } // catch // { // // TODO: Log // continue; // } // WorkbookRegistrationInfo regInfo = new WorkbookRegistrationInfo(name); // _workbookRegistrationInfos[name] = regInfo; // regInfo.Refresh(); // RegisterWithXmlProvider(wbAddIn); // } // } //} Logger.Provider.Verbose($"WorkbookIntelliSenseProvider.Initialize - Checking Add-Ins"); var loadedAddIns = Integration.XlCall.Excel(Integration.XlCall.xlfDocuments, 2) as object[, ]; if (loadedAddIns == null) { // This is normal if there are none Logger.Provider.Verbose($"WorkbookIntelliSenseProvider.Initialize - DOCUMENTS(2) returned null"); return; } for (int i = 0; i < loadedAddIns.GetLength(1); i++) { var addInName = loadedAddIns[0, i] as string; Logger.Provider.Verbose($"WorkbookIntelliSenseProvider.Initialize - Checking Add-In {addInName}"); if (addInName != null && Path.GetExtension(addInName) != ".xll") // We don't actually expect the .xll add-ins here - and they're taken care of elsewhere { // Can it be "Open" and not be loaded? var name = addInName; Workbook wbAddIn; try { // TODO: Log wbAddIn = xlApp.Workbooks[name]; } catch { // TODO: Log continue; } Logger.Provider.Verbose($"WorkbookIntelliSenseProvider.Initialize - Adding registration for add-in {name}"); WorkbookRegistrationInfo regInfo = new WorkbookRegistrationInfo(name); _workbookRegistrationInfos[name] = regInfo; regInfo.Refresh(); RegisterWithXmlProvider(wbAddIn); } } } }
public void Initialize() { Logger.Provider.Info("WorkbookIntelliSenseProvider.Initialize"); _xmlProvider.Initialize(); // The events are just to keep track of the set of open workbooks, var xlApp = (Application)ExcelDnaUtil.Application; xlApp.WorkbookOpen += Excel_WorkbookOpen; xlApp.WorkbookBeforeClose += Excel_WorkbookBeforeClose; xlApp.WorkbookAddinInstall += Excel_WorkbookAddinInstall; xlApp.WorkbookAddinUninstall += Excel_WorkbookAddinUninstall; lock (_workbookRegistrationInfos) { foreach (Workbook wb in xlApp.Workbooks) { var name = wb.Name; if (!_workbookRegistrationInfos.ContainsKey(name)) { WorkbookRegistrationInfo regInfo = new WorkbookRegistrationInfo(name); _workbookRegistrationInfos[name] = regInfo; regInfo.Refresh(); RegisterWithXmlProvider(wb); } } if (ExcelDnaUtil.ExcelVersion >= 14.0) { foreach (AddIn addIn in xlApp.AddIns2) { if (addIn.IsOpen && Path.GetExtension(addIn.FullName) != ".xll") { // Can it be "Open" and not be loaded? var name = addIn.Name; Workbook wbAddIn; try { // TODO: Log wbAddIn = xlApp.Workbooks[name]; } catch { // TODO: Log continue; } WorkbookRegistrationInfo regInfo = new WorkbookRegistrationInfo(name); _workbookRegistrationInfos[name] = regInfo; regInfo.Refresh(); RegisterWithXmlProvider(wbAddIn); } } } } }