Home › Forums › NodeXL Installation issues – first time install, moving NodeXL to a new machine and more › Error calculating metrics (any metrics)
Tagged: Error
- This topic has 0 replies, 1 voice, and was last updated 4 years ago by
matthew.cutler@noaa.gov.
- AuthorPosts
- September 26, 2019 at 11:43 am #8613
matthew.cutler@noaa.gov
ParticipantPlease help! I receive this error (see below) when I try to “Calculate metrics” under “Graph Metrics”. All of the metrics available return this error. My suspicion is I have an issue with the installation and back-end files, but I’ve tried uninstalling and reinstalling and it still gives this error. Any help would be greatly appreciated!
Thanks,
Matt—————————
NodeXL
—————————
An unexpected problem occurred. If it occurs again, please copy the details to the clipboard by typing Ctrl-C, then post the details to https://www.smrfoundation.org/forums/.Details:
[InvalidCastException]: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel._Workbook.get_Sheets()
at Smrf.AppLib.ExcelUtil.TryGetWorksheet(Workbook workbook, String worksheetName, Worksheet& worksheet)
at Smrf.AppLib.ExcelTableUtil.TryGetTable(Workbook workbook, String worksheetName, String tableName, ListObject& table)
at Smrf.NodeXL.ExcelTemplate.PerWorkbookSettings.TryGetPerWorkbookSettingsTable(ListObject& oPerWorkbookSettingsTable)
at Smrf.NodeXL.ExcelTemplate.PerWorkbookSettings.GetAllSettings()
at Smrf.NodeXL.ExcelTemplate.PerWorkbookSettings.TryGetValue(String settingName, Type valueType, Object& value)
at Smrf.NodeXL.ExcelTemplate.PerWorkbookSettings.get_WorkbookSettings()
at Smrf.NodeXL.ExcelTemplate.NodeXLApplicationSettingsBase.GetWorkbookSettings()
at Smrf.NodeXL.ExcelTemplate.NodeXLApplicationSettingsBase.CopyWorkbookSettingsToStandardSettings()
at Smrf.NodeXL.ExcelTemplate.NodeXLApplicationSettingsBase.get_Item(String propertyName)
at Smrf.NodeXL.ExcelTemplate.GraphMetricUserSettings.get_GraphMetricsToCalculate()
at Smrf.NodeXL.ExcelTemplate.GraphMetricUserSettings.ShouldCalculateGraphMetrics(GraphMetrics graphMetrics)
at Smrf.NodeXL.ExcelTemplate.CalculateGraphMetricsContext.ShouldCalculateGraphMetrics(GraphMetrics graphMetrics)
at Smrf.NodeXL.ExcelTemplate.GroupMetricCalculator2.TryCalculateGraphMetrics(IGraph graph, CalculateGraphMetricsContext calculateGraphMetricsContext, GraphMetricColumn[]& graphMetricColumns)
at Smrf.NodeXL.ExcelTemplate.GraphMetricCalculationManager.CalculateGraphMetricsAsyncInternal(CalculateGraphMetricsAsyncArgs oCalculateGraphMetricsAsyncArgs, BackgroundWorker oBackgroundWorker, DoWorkEventArgs oDoWorkEventArgs)
at Smrf.NodeXL.ExcelTemplate.GraphMetricCalculationManager.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
—————————
OK
————————— - AuthorPosts
- You must be logged in to reply to this topic.