Tagged: 

This topic contains 0 replies, has 1 voice, and was last updated by  matthew.cutler@noaa.gov 1 month, 3 weeks ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #8613

    Please 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 http://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
    —————————

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.