Importing Data from Excel

Oct 28, 2011 at 12:28 AM

The data that I have gathered is not consistent in terms of upper and lower case. As a result, nodexl is reading the vertices as independent nodes, but there are far too many to manually change. What do you suggest I do? Thanks

 

Daniel  

Oct 28, 2011 at 12:52 AM
Edited Oct 28, 2011 at 12:53 AM

Daniel:

You'll have to convert your edge list to all lower case or upper case before using it in NodeXL.  You can use Excel's LOWER or UPPER functions to do this (http://support.microsoft.com/kb/263580), although that's a bit involved.  Here is another technique.  (This takes longer to read than it takes to do.)

1. Enter your inconsistent edge list into the Edges worksheet of a new NodeXL workbook.  Don't show the graph yet, because that will copy the inconsistent vertex names to the Vertices worksheet and you don't want that.

2. Select and copy the edge list in columns A and B, not including the column headers.

3. Paste the edge list into a new Word document.

4. Select the edge list in the Word document.

5. In Word, use Home, Font, Change Case to make the edge list have consistent case.

6. Copy the edge list from the Word document.

7. Select cell A3 in the Edges worksheet in the NodeXL workbook, then paste the consistent edge list back into the worksheet.

-- Tony

 

Oct 28, 2011 at 1:07 AM
That is a brilliantly easy solution. Thanks for the help, Tony.

Daniel

On Thu, Oct 27, 2011 at 4:52 PM, tcap479 <notifications@codeplex.com> wrote:

From: tcap479

Daniel:

You'll have to convert your edge list to all lower case or upper case before using it in NodeXL. You can use Excel's LOWER or UPPER functions to do this (http://support.microsoft.com/kb/263580), although that's a bit involved. Here is another technique. (This takes longer to read than it takes to do.)

1. Enter your inconsistent edge list into the Edges worksheet of a new NodeXL workbook. Don't show the graph yet, because that will copy the inconsistent vertex names to the Vertices worksheet and you don't want that.

2. Highlight and copy the edge list in columns A and B, not including the column headers.

3. Paste the edge list into a new Word document.

4. Select the edge list in the Word document.

5. In Word, use Home, Font, Change Case to make the edge list have consistent case.

6. Copy the edge list from the Word document.

7. Select cell A3 in the Edges worksheet in the NodeXL workbook, then paste the consistent edge list back into the worksheet.

-- Tony

Read the full discussion online.

To add a post to this discussion, reply to this email (NodeXL@discussions.codeplex.com)

To start a new discussion for this project, email NodeXL@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com