Importing node tables together with edge tables

Mar 10, 2010 at 10:23 PM

The networks that I am displaying contain attributes in the nodes as well as in the edges. While it is painless to import edges from an open workbook, importing nodes from another sheet in the same workbook requires two additional copy-paste operations. I realize that this is no great price to pay, but it would be even easier if the "From open edge workbook" were extended to allow the specification of a node sheet (and its node-id attribute column) within the same workbook.

Mar 11, 2010 at 1:38 AM

That turns out to be tricky to do, due to all the options, cross-worksheet matching, and error handling that would have to be implemented.

I don't know where your graph data is originating -- any chance you could get it in GraphML format?  Our Import From GraphML File feature supports all attributes on both edges and vertices.

You might also consider recording a macro in Excel if this is a frequent operation.

-- Tony