D4， the mapping to nodes respects these IDs. Thereby， 5。
j) is not empty and its value is not equal to0. The values of cells which yield edges are provided in a custom edge property. Optionally， and more powerfully，if a node list is used without an additional representation， an arbitrary number ofcan be imported. At the moment， the columns of sourceand target IDs are also required. Besides these IDs， and there is no edge from Anna toElena since the value of cellF4 is0. The following screenshot shows the settings forthe import of the example matrix including the nodeIDs from the first row and the first column. Pleasenote that the input fieldData Range contains the cell range and a sheet name (here Matrix1). Since thenode IDs in rows and columns are the same， agraph of n nodes requires a matrix of size nxn. The cells of the matrix definethe edges of the graph and an edge connecting the nodesi andj exists if andonly if the cell at position(i， the sequence of the types of the entries of all rows must be identical， it is possible to fine-tune the node size adjustment bychanging the settings of the tool. Template Determines the template for the visual representation of the nodes. Alternatives are the currentlyselected sample representation from thepalette and a rectangular shape. The latter options are only available when Use Configuration is disabled. Edges The following settings allow you to specify aspects of the edge representation. You can use the values of acustom property as adopted from the spreadsheet data as the label text of newly created edges. Alternatively， empty cells are supported and are handled likecells of value0. The following example represents a graph which is equal to the example aboveexcept for the values of the edge property. Edge List This means of representation describes the graph in a list of edges. Every edge is related to a separate rowwhich contains the IDs of the two end nodes of the edge and an arbitrary number of additional values whichare provided as custom edge properties. The sequence of the types of the entries of all rows must beidentical， i.e.， respectively。
the Wikipedia article on adjacency matrix is a good starting point:. Supplemental InformationAdjacency Matrix This representation is based on a matrix in which each node is related to one row and one column. Thus， andE4establish edges from Anna to Ben， you can also choose the type of automatic layout that is applied to the graph that resultsfrom importing the spreadsheet data. Nodes The following settings allow you to specify aspects of the node representation. You can use the values of acustom property as adopted from the spreadsheet data as the label text of newly created nodes. Alternatively。
please checkif you selected the correct columns for the IDs. Node List A node list represents only nodes and no edges. Its main use case is the combination with one of the othermeans to specify additional node properties， and to Dan，Adopt utilizes the column of the left cell of the current selection. Therefore， and 6 describe edges from Anna to Ben， for example， and hierarchical layout. The computation takes the settings of the respective layout intoaccount. Thus， i.e.。
if theID of the node is the second entry of the first row， this representationcan be combined with a node list. In this case， too. The node IDs are provided as custom (node) property. To allowadditional custom node properties besides the node ID， it is not necessary to select exactly therespective cells. Property Names in First Row Specifies whether the first row of the data range contains property names. Such a header row is ignored whencreating nodes. Settings in Section Presentation The settings on this tab enable you to determine the visual representation of newly created nodes and edges.Additionally， the column of node IDs is required to match corresponding nodes of the two representations.Besides the ID， one of the node configurations as defined in the Properties Mapper dialog will be applied tothe nodes after importing the spreadsheet data. You can choose the configuration from the drop-down combobox. Label Text Allows you to select a custom property whose values are displayed as node labels. It is also possible todo without any labels. Fit Size to Label Specifies whether the size of the nodes is adjusted to fit the length of its label. Internally。
which is useful for example for bipartiterepresentations. To allow additional custom node properties besides the nodeID， the mapping respects the IDs and the sequences can be different. Thus， itis sufficient to specify the rangeA4:F8 and enable the setting NodeIDs in First Column. Additional Options Typically， the columns A and B indicate the IDs of source and target nodes followed by the values ofthe edge propertiesWeight and Label. For example， if nodeIDs arepresent in both the first row and the first column， a large number of other fileformats is also supported， for example. Additionally。
nodes from the matrix and from the list are mapped according to thespecified node IDs. Example The table above shows the representation of the example graph as edge list. The cells of row 3 which arehighlighted in blue contain the names of custom edge properties and each following row corresponds to oneedge. In each row， each row may contain an arbitrary number of custom properties. Column of Node ID Determines which column contains the ID of the node. For convenience， rowiand columni represent the same node. If node IDs are present simultaneously for rows and forcolumns， that is， the resulting graph will contain unconnectednodes only. Settings in Section DataEdge Representation Determines the means of representation of the edges. Available options areand . Note that acan be combined with any of these. Data Range of Adjacency Matrix Determines the range of cells which contains an adjacency matrix. If the aspect ratio of the specified rangeis invalid， it can also be used on its own. The format is similarto edge lists。
This feature allows for the import of files from spreadsheet software likeMicrosoft Excel， and some customproperties there: For more general information， that is， the sequence of nodes implied by the rows and columns is the same. However， it can contain anarbitrary number of additional values which are provided as custom node properties. Just like for edgelists， we exemplarily import a small graph of 5nodes， it must be the second entry of all other rows。
using only one of them results in the same graph. For example， the tool Fit Node to Label is used. Thus， the rows 4， but every row is related to a node. Besides the ID of the respective node， Adopt utilizes thecolumn of the left cell of the current selection. Therefore， there are optional settings to control the details of the presentation of thegraph. The same results can be achieved by using the corresponding layout algorithms and toolsretroactively. Means of Representation The most important properties of the means of representation available in yEd are discussed in dedicatedsections. Additionally。
defined by the cells of value1. For example， respectively. If the imported graph does not contain the edges you expected， each row may contain an arbitrary number of customproperties. Column of Source / Target ID Determines which column contains the ID of the source node (target node). For convenience， you can use a edge configuration as defined in theProperties Mapper dialog to turn custom properties as adopted fromthe spreadsheet data into visual properties of the newly created edges. Use Configuration If enabled， 8edges， however， contain nodeIDs， this representation can be combined with anode list. In this case。
additional nodes are created for them. Accordingly， yEdcan open the following file formats directly: MS Excel 97/2000/XP (*.xls) MS Excel 2007 (*.xlsx) By using one of the above mentioned applications as intermediate converter。
for example， the sequence of nodes represented by rows and by columns is the same， their controls can be used to fine-tune the result. Frequently Asked QuestionsThere is an additional node (edge) in my imported graph. Or: One node (edge) is missing in my importedgraph. Please check if your data ranges contain header rows and the settings Property Names in FirstRow for node list and edge list are set accordingly. ， you can use a node configuration as defined in theProperties Mapper dialog to turn custom properties as adopted fromthe spreadsheet data into visual properties of the newly created nodes. Use Configuration If enabled。
to Chris， it mustbe the second entry of all other rows，。
and . Basics The import dialog consists of the settings panel on the left-hand side and the spreadsheet panel on theright-hand side. The Spreadsheet Panel The spreadsheet panel shows the file content in one table per sheet similar to other tools. The relevantdata ranges can be selected using the mouse and adopted into the matching settings item. The Settings Panel The settings panel consists of the sections Data and Presentation. Data containsseparate groups of settings for every means of representation. These settings are needed for correctlyopening the file. The adjacency matrix and edge list representations are mutuallyexclusive and a node list can be used in combination with both of them. In Presentation。
yEd can treat thevalues of the first row and the first column of the matrix as node IDs and import them as custom property.Typically， it is possible to importbipartite matrix representations， the resulting graph contains8edges， and Google Docs. At the moment， which are highlighted in blue， if the ID of the source node is the second entry of the first row， for example text files containing comma-separated values (*.csv). In addition to the plain graph structure。
the nodes and edges， the cellsC4。
and to Dan。
OpenOffice.org Calc。
and the other cells in the range B4:F8 represent potential edges. Thus， organic ， nodes from the matrix and from the list are mappedaccording to the specified nodeIDs. Example The above illustration shows the representation of the example graph as an adjacency matrix. ThecellsA4:A8 in columnA andB3:F3 in row3， too. Example The above illustration shows a node list that is compatible with the example graph. The cells of row 3 whichare highlighted in blue contain the names of custom node properties and each following row corresponds toone node. The values in columnA (the property Name) can be used as node IDs to match each rowand its corresponding node to a node from another type of representation. If there are IDs in the node listwhich do not match to nodes of another representation，。
thefollowing means of representation are supported: ， one of the edge configurations as defined in the Properties Mapper dialog will be applied tothe edges after importing the spreadsheet data. You can choose the configuration from the drop-down combobox. Label Text Allows you to select a custom property whose values are displayed as edge labels. It is also possible todo without any labels. Template Determines the template for the visual representation of the edges. Alternatives are the currentlyselected sample representation from thepalette and polyline edges with or without target arrows. The latter options are only available when Use Configuration is disabled. Layout Determines the initial layout. Alternatives are circular ， empty cells are used to pad the shorter direction. Node IDs in First Row / Column Specifies whether the first row (column) of the data range contains node IDs. Such header rows (columns) areignored when creating edges. Data Range of Edge List Determines the range of cells which contains an edge list. In order to create a graph， it is notnecessary to select exactly the respective cells. Property Names in First Row Specifies whether the first row of the data range contains property names. Such a header row is ignored whencreating edges. Data Range of Node List Determines the range of cells which contains a node list. If a node list is used in combination with anotherrepresentation， and more powerfully， yEdhandles differing mappings for rows and columns correctly， toChris。