Thanks a lot Davis, there was also some earlier work:
https://github.com/tathamoddie/CypherExcel https://github.com/shaikatzir/xls-neo4j Cheers, Michael On Tue, Jan 16, 2018 at 2:59 PM, Davis Rogers <solidbuilder...@gmail.com> wrote: > https://www.easysoft.com/support/kb/kb01098.html > > > This example uses a Visual Basic for Applications (VBA) subroutine to > retrieve nodes from sample Neo4j graph Movies. Note that it is not possible > to use Excel's GUI tools (Data Connection Wizard / Microsoft > <http://www.microsoft.com/> Query) to work with Neo4j data. They are > SQL-based applications and are not compatible with a cypher-based graph > database. > > 1. Create a new Excel spreadsheet. > 2. Press ALT+F11 to start the Visual Basic Editor. > 3. In the Visual Basic Editor, in the Project Pane, double-click > Sheet1 in the list of Objects. > 4. In the Code Window, add the following VBA code: > > Option Explicit > Public Sub GraphNodesIntoExcel() > > Dim con As New ADODB.Connection > Dim rs As New ADODB.Recordset > Dim lngCounter As Long > Const strcQuery As String = "MATCH (people:Person) RETURN > people.name LIMIT 10" > > ' Replace Neo4j with the name of your ODBC data source. > con.Open "Neo4j" > rs.Open strcQuery, con > > If rs.EOF Then Exit Sub > > With rs > ActiveSheet.Range("A1").Offset(0, 0).Value = .Fields(0).Name > lngCounter = 1 > Do Until .EOF > ActiveSheet.Range("A1").Offset(lngCounter, 0).Value = > .Fields(0).Value > .MoveNext > lngCounter = lngCounter + 1 > Loop > End With > > rs.close > con.Close > > Set rs = nothing > Set con = nothing > End Sub > > 5. On the Run menu, choose Run Sub/UserForm to run the new subroutine. > > If you get the error "User Defined type not defined.", on the Run > menu, choose Reset. On the Tools menu, choose References. In the References > dialog box, choose Microsoft <http://www.microsoft.com/> Active X Data > Objects n Library, and then click OK. Run the subroutine again. > > > On Saturday, September 30, 2017 at 11:37:30 AM UTC-4, John Singer wrote: >> >> I would like to script the neo4j.driver dotnet library from excel VBA. >> My understanding is that dotnet dll's can be made com scriptable - has >> anyone worked out how to do this or will Neo4j need to provide this >> capabality? >> > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to neo4j+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
