Exporting Graph Data to Another Workbook

NodeXL will export selected edges and vertices to a new NodeXL workbook. It will also export the entire graph to a new Excel workbook as an adjacency matrix.

To export selected graph data from the NodeXL workbook to a new NodeXL workbook:
  1. Select the edges and vertices you want to export.
  2. In the Ribbon, select NodeXL, Data, Export, Selection to New NodeXL Workbook. This creates a new NodeXL workbook, copies the selected edges and vertices into it, and switches to the new workbook. All edge and vertex columns are copied.
To export the graph data from the NodeXL workbook to a new Excel workbook as an adjacency matrix:
  1. In the Ribbon, select NodeXL, Data, Export, To New Matrix Workbook. This creates a new Excel workbook (not a NodeXL workbook), fills the new workbook with an adjacency matrix whose elements are the graph's edge weights, and switches to the new workbook.

Note that a graph's adjacency matrix has V rows and V columns, where V is the number of vertices in the graph. A graph with a large number of vertices will result in a huge workbook, one that Excel may not be able to handle without running out of memory. Therefore, the Export to New Matrix Workbook feature should be used only with smaller graphs.


More Information