Re-ocurring error

Feb 8 at 8:23 PM

Can't Display a graph or do anything without this error popping up

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.codeplex.com/NodeXL/Thread/List.aspx.



Details:
[COMException]: Out of present range. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW))



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

at Microsoft.Office.Interop.Excel.Range.get_Value(Object RangeValueDataType)

at Smrf.AppLib.ExcelUtil.GetRangeValues(Range range)

at Smrf.AppLib.ExcelTableReader.<GetRows>d__0.MoveNext()

at Smrf.NodeXL.ExcelTemplate.VertexWorksheetReader.ReadVertexTable(ListObject oVertexTable, ReadWorkbookContext oReadWorkbookContext, IGraph oGraph, Boolean& bLayoutAndZOrderSet)

at Smrf.NodeXL.ExcelTemplate.VertexWorksheetReader.ReadWorksheet(Workbook workbook, ReadWorkbookContext readWorkbookContext, IGraph graph)

at Smrf.NodeXL.ExcelTemplate.WorkbookReader.ReadWorkbookInternal(Workbook workbook, ReadWorkbookContext readWorkbookContext)

at Smrf.NodeXL.ExcelTemplate.WorkbookReader.ReadWorkbook(Workbook workbook, ReadWorkbookContext readWorkbookContext)

at Smrf.NodeXL.ExcelTemplate.GraphMetricCalculationManager.ReadWorkbook(Workbook oWorkbook, IGraphMetricCalculator2[] oGraphMetricCalculators)

at Smrf.NodeXL.ExcelTemplate.GraphMetricCalculationManager.CalculateGraphMetricsAsync(IGraph graph, Workbook workbook, IGraphMetricCalculator2[] graphMetricCalculators)

at Smrf.NodeXL.ExcelTemplate.GraphMetricCalculationManager.CalculateGraphMetricsAsync(IGraph graph, Workbook workbook)

at Smrf.NodeXL.ExcelTemplate.CalculateGraphMetricsDialog.OnLoad(EventArgs e)

OK

Coordinator
Feb 10 at 1:44 PM
Hello,

according to this post https://connect.microsoft.com/VisualStudio/feedback/details/543802/excel-range-count-throws-exception-when-the-range-is-very-large , this problem happens when there are too many rows. Have you tried with a smaller network?

Regards,
Arber