Difference between revisions of "SimpleGraph-Excel"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
= Mental Model = | = 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 | ||
| + | == UML diagram == | ||
<uml> | <uml> | ||
Revision as of 13:44, 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
UML diagram
Examples
Modern
AirRoutes
Railway