#7794
estephe2
Participant

I used NVivo’s Ncapture tool to capture tweets based on hashtags (as part of larger digital ethnography) and now I’m having trouble manually importing the excel worksheet into NodeXL. Is there any sort of guide you can point me to on how to do this correctly? I keep getting an error message and I’m not sure if it’s because I’m making a mistake on the import or has something to do with my data. The error message I’m getting is below– Thanks!

—————————
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:

[COMException]: PivotFields method of PivotTable class failed

at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)

at Microsoft.Office.Interop.Excel.PivotTable.PivotFields(Object Index)

at Smrf.NodeXL.ExcelTemplate.TimeSeriesCalculator2.CreatePivotTableAndChart(Worksheet dataWorksheet)

at Smrf.NodeXL.ExcelTemplate.TimeSeriesCalculator2.TryCalculateGraphMetrics(GraphMetricUserSettings graphMetricUserSettings)

at Smrf.NodeXL.ExcelTemplate.TaskAutomator.TryCalculateGraphMetrics(Workbook oWorkbook)

at Smrf.NodeXL.ExcelTemplate.TaskAutomator.AutomateOneWorkbook(ThisWorkbook thisWorkbook, NodeXLControl nodeXLControl, AutomationTasks tasksToRun, String folderToSaveWorkbookTo)

at Smrf.NodeXL.ExcelTemplate.TaskPane.AutomateThisWorkbook()

at Smrf.NodeXL.ExcelTemplate.TaskPane.CommandDispatcher_CommandSent(Object sender, RunCommandEventArgs e)

at Smrf.NodeXL.ExcelTemplate.RunCommandEventHandler.Invoke(Object sender, RunCommandEventArgs e)

at Smrf.NodeXL.ExcelTemplate.CommandDispatcher.SendCommand(Object sender, RunCommandEventArgs runCommandEventArgs)

at Smrf.NodeXL.ExcelTemplate.CommandDispatcher.SendNoParamCommand(Object sender, NoParamCommand noParamCommand)

at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.AutomateThisWorkbook()

at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.AutomateTasksAfterImport()
—————————
OK
—————————