Export Data to Excel/CSV
Soley Studio provides the option to export data of all your analyses directly to an Excel sheet or .csv file using the built in Export function. It can be used while a graph file is open. Just click on the Export data button in the toolbar, as shown below, and choose whether you want to save your data as a .xlsx file or .csv file.
For every graph visualization type except the Table and Matrix view, all data is exported. That means the exported table contains one row for each element in the graph with the columns representing the property values. This also includes the system-defined attributes, such as __guid.
As we can see in the image above, each Node and Edge Class is stored in a separate Sheet. This way it is possible to save all of the attributes of the respective classes, in comparison to the case where all of the nodes are displayed in one spreadsheet.
A Matrix view can be exported as displayed in the Soley software. That means that the export does not contain all the data but the layout and styling of the original Matrix view:
The corresponding graph visualization in Excel looks pretty much the same:
The export of a Table view also takes the layout but not the styling of the view into account. That means that the resulting Excel/CSV file will only contain the data points and columns shown in the Table view. That allows you to create a customized excerpt of the data in your graph and export only this section as a table.
When exported to Excel, the Table View will get adapted to a “typical” Excel sheet look: