
Hi! This is my first time using NodeXL, but I'm really excited about what you all have created here. Capabilities look amazing. One question. I have a 600x600 node network dataset (in regular excel) that has 1s denoting ties and 0s denoting absence
of ties. I'm curious, is there a way to upload this matrix directly into NodeXL without transforming it into dyadic edgelists? As you can imagine, that would save me a lot of time if it were possible... Thanks!


Jan 20, 2012 at 5:23 PM
Edited Jan 20, 2012 at 6:12 PM

Yes, you can do that via the following steps:
1. Open your matrix workbook in Excel.
2. Create a new NodeXL workbook in Excel.
3. In the NodeXL workbook, go to NodeXL, Data, Import, From Open Matrix Workbook in the ribbon.
 Tony



Hi Tony,
I'm new to NodeXL as well, and am doing what I can to get up to speed! Is there a way to do the matrix import from the NodeXL workbook file itself? I've made a new tab in the NodeXL workbook (which if I'm correct is just a standard Excel tab), and have placed
the adjacency matrix there. I'd like to import the matrix from there to the edge list. I'm hoping to ultimately create a selfcontained NodeXL workbook, such that a user can change things in an Excel tab that then update the network visualization...
Thanks!



Hello, Central:
No, I'm afraid there is no way to do that. NodeXL can only import an adjacency matrix from a separate Excel workbook. It can't import directly from an extra worksheet in the NodeXL workbook itself.
 Tony

