Difference between revisions of "SimpleGraph-Excel"
Jump to navigation
Jump to search
(→Modern) |
|||
Line 96: | Line 96: | ||
note on link: 4 | note on link: 4 | ||
</uml> | </uml> | ||
− | [[ | + | [[File:modern.xlsx]] |
== AirRoutes == | == AirRoutes == |
Revision as of 13:46, 31 August 2018
SimpleGraphModule
SimpleGraph Excel module
The SimpleGraph Excel module makes Microsoft Excel workbooks accessible via the Apache POI API see Apache POI XSSF/HSSF.
Sources
- System: ExcelSystem.java
- JUnit-Test: TestExcelSystem.java
Mental Model
Mapping rules
- Each Vertex type (by label) is converted to an Excel sheet
- Each Edge type (by label) is converted to an Excel sheet
- Each vertex is converted to a row
- Each vertex property is converted to a cell
- Each edge is converted to a row
- Each edge property is converted to a cell
- The header row for Vertices has a column for each property key
- The header for for Edges has a column for each property key + an in and and out column
- The in and out header columns for edges have the label of the corresponding vertex in parentheses