Difference between revisions of "SimpleGraph-Excel"

From BITPlan Wiki
Jump to navigation Jump to search
Line 99: Line 99:
  
 
== AirRoutes ==
 
== AirRoutes ==
 +
=== UML diagramm ===
 
<uml>
 
<uml>
 
   hide circle
 
   hide circle

Revision as of 19:28, 31 August 2018

SimpleGraphModule

Microsoft Excel 2013-2019 logo.svg

SimpleGraph Excel module

The SimpleGraph Excel module makes Microsoft Excel workbooks accessible via the Apache POI API see Apache POI XSSF/HSSF.

Sources

Mental Model

Mapping rules

  1. Each Vertex type (by label) is converted to an Excel sheet
  2. Each Edge type (by label) is converted to an Excel sheet
  3. Each vertex is converted to a row
  4. Each vertex property is converted to a cell
  5. Each edge is converted to a row
  6. Each edge property is converted to a cell
  7. The header row for Vertices has a column for each property key
  8. The header for for Edges has a column for each property key + an in and and out column
  9. The in and out header columns for edges have the label of the corresponding vertex in parentheses

UML diagram

Examples

Modern

File:Modern.xlsx

AirRoutes

UML diagramm

Railway

Links