Latest revision as of 10:06, 30 October 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

File:Modern.xlsx

AirRoutes

The UML diagram and excel table is not fully consistent with the graph. The graph can have contains edges between airport and country.

File:Air-routes.xlsx

@Test
  public void testCreateExcelAirRoutes() throws Exception {
    ExcelSystem es = new ExcelSystem();
    Graph graph = TestTinkerPop3.getAirRoutes();
    GraphTraversalSource g = graph.traversal();
    // es.setDebug(true);
    Workbook wb = es.createWorkBook(g);
    assertEquals(6, wb.getNumberOfSheets());
    es.save(wb, testAirRouteFileName);
}

Railway

Links

@@ Line 15: / Line 15: @@
 = 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>
    hide circle
+  package Excel {
    class Workbook {
      name
@@ Line 34: / Line 47: @@
    Sheet "1" -> "n" Row
    Row "1" -> "n" Cell
+ }
+ package TinkerPop {
+   class Property {
+     name
+     value
+   }
+   class Vertex {
+    id
+    label
+   }
+   class Edge {
+    id
+    label
+   }
+   Edge -> "1 in" Vertex
+   Edge -> "1 out" Vertex
+   Vertex -> "n properties" Property
+   Edge -> "n properties" Property
+   Edges -> "n edges" Edge
+   Vertices -> "n Vertices" Vertex
+ }
+ Cell - Property
+ Edge - Sheet
+ Vertex - Sheet
 </uml>
@@ Line 59: / Line 96: @@
    note on link: 4
 </uml>
+[[File:modern.xlsx]]
 == AirRoutes ==
+The UML diagram and excel table is not fully consistent with the graph. The graph can have contains edges between airport and country.
 <uml>
    hide circle
@@ Line 104: / Line 145: @@
    note on link: 6748
 </uml>
+[[File:air-routes.xlsx]]
+<source lang='java'>
+@Test
+  public void testCreateExcelAirRoutes() throws Exception {
+    ExcelSystem es = new ExcelSystem();
+    Graph graph = TestTinkerPop3.getAirRoutes();
+    GraphTraversalSource g = graph.traversal();
+    // es.setDebug(true);
+    Workbook wb = es.createWorkBook(g);
+    assertEquals(6, wb.getNumberOfSheets());
+    es.save(wb, testAirRouteFileName);
+}
+</source>
 == Railway ==

Difference between revisions of "SimpleGraph-Excel"