Mar 2, 2011 at 6:16 AM
Edited Mar 2, 2011 at 6:23 AM
NodeXL works with an edge list, where each edge has two vertices. So no, NodeXL can't handle your row of connected friends.
However, it can easily be done it VBA, the programming language built into Excel. Let's say you have a friend list that looks like this:
Anne Bob Cathy Derek
Mark Bill Sally
To convert this to an edge list that NodeXL can understand, do the following:
* Create an empty NodeXL workbook.
* From the NodeXL workbook, use Office Button, New, Blank Workbook to create an empty regular Excel workbook.
* Copy your friend list into Sheet1 of the regular Excel workbook. There can be a different number of friends in each row.
* Right-click the Sheet1 tab at the lower-left corner of Excel and select View Code. A "Microsoft Visual Basic" window will open.
* Copy and paste the entire contents of my next post into the big empty pane of the Microsoft Visual Basic window.
* In the Microsoft Visual Basic window, select Run, Run Sub/UserForm (or click F5).
* Close the Microsoft Visual Basic window. You'll see that your friend pairs have been copied to Sheet2 of the regular Excel workbook.
* Switch to the NodeXL workbook. You can use Ctrl-Tab to switch between workbooks.
* In the NodeXL workbook, select NodeXL, Data, Import, From Open Workbook.
* In the Import from Open Workbook dialog box, select the regular Excel workbook as the "open workbook to import from." Click Import.