通过Python读取Excel表内容导入Neo4j数据库中

#!/usr/bin/python
# -*- coding:utf-8 -*-
from py2neo import Node, Relationship, Graph
import xlrd


#读取Excel表              路径       表名
def readExcelDataByName(fileName, sheetName):
    data = xlrd.open_workbook(fileName)
    table = data.sheet_by_name(sheetName)
    return table

#获取Excel列表名
def getColumnIndex(table, columnName):
    columnIndex = None 
    for i in range(table.ncols): 
        if(table.cell_value(0, i) == columnName):
            columnIndex = i
            break
    return columnIndex

#获取Excel行值
def getNrowValue(table, nrow, columnName):
    nrowsValue = table.cell_value(nrow, getColumnIndex(table, columnName))
    return nrowsValue

#创建节点        类别，名字，特征，位置，图片，视频，3D模型，id
def CreateNode(m_class, m_name, m_feature, m_location, m_img, m_video, m_model):
    m_node = Node(m_class, name=m_name, feature=m_feature, location=m_location, img=m_img, video=m_video, model=m_model)
    graph.create(m_node)

#创建关系 node_a-[m_relation]->node_b
def CreateRelationship(node_a, node_b, m_relation):
    relation = Relationship(node_a, m_relation, node_b)
    graph.create(relation)

#查询节点       类别，名字，特征，位置，图片，视频，3D模型，id
def MatchNode(m_class, m_name, m_feature, m_location, m_img, m_video, m_model):
    node = graph.nodes.match(m_class, name=m_name, feature=m_feature, location=m_location, img=m_img, video=m_video, model=m_model).first()
    return node


if __name__ == "__main__":
    graph = Graph('http://localhost:7474', username='neo4j', password='123456')  #连接数据库
    excelfile = r'E:\work\neo4j_python\'
    sheetname = 'Sheet1'
    table = readExcelDataByName(excelfile, sheetname)
    #Excel行数  
    nrows = table.nrows
    #创建节点
    for i in range(1, nrows):
        m_class = getNrowValue(table, i, 'Class')
        m_name = getNrowValue(table, i, 'Name')
        m_feature = getNrowValue(table, i, 'Feature')
        m_location = getNrowValue(table, i, 'Location')
        m_img = getNrowValue(table, i, 'Image')
        m_video = getNrowValue(table, i, 'Video')
        m_model = getNrowValue(table, i, 'Model')
        node = MatchNode(m_class, m_name, m_feature, m_location, m_img, m_video, m_model)
        #查询node是否存在
        if node == None:
            CreateNode(m_class, m_name, m_feature, m_location, m_img, m_video, m_model)
    #创建关系
    for i in range(1, nrows):

        #节点a 
        m_relationship = getNrowValue(table, i, 'Relationship') #关系 a-[r]->b
        m_name_a = getNrowValue(table, i, 'Name')
        m_class_a = getNrowValue(table, i, 'Class')
        m_feature_a = getNrowValue(table, i, 'Feature')
        m_location_a = getNrowValue(table, i, 'Location')
        m_img_a = getNrowValue(table, i, 'Image')
        m_video_a = getNrowValue(table, i, 'Video')
        m_model_a = getNrowValue(table, i, 'Model')
        node_a = MatchNode(m_class_a, m_name_a, m_feature_a, m_location_a, m_img_a, m_video_a, m_model_a)
        #node_a = graph.nodes.match(m_class_a, name=m_name_a).first()
        print(node_a)

        #节点b
        id_b = getNrowValue(table, i, 'IDB')
        #判断IDB是否为空
        if len(id_b) != 0:
            id_b = id_b.split(", ")  #以", " 分割 逗号+空格 
            id_b = list(map(int, id_b))
     
        for i in id_b:
            m_name_b = getNrowValue(table, i, 'Name')
            m_class_b = getNrowValue(table, i, 'Class')
            m_feature_b = getNrowValue(table, i, 'Feature')
            m_location_b = getNrowValue(table, i, 'Location')
            m_img_b = getNrowValue(table, i, 'Image')
            m_video_b = getNrowValue(table, i, 'Video')
            m_model_b = getNrowValue(table, i, 'Model')
            node_b = MatchNode(m_class_b, m_name_b, m_feature_b, m_location_b, m_img_b, m_video_b, m_model_b) 
            #node_b = graph.nodes.match(m_class_b, name=m_name_b).first()       
            print(node_b)
            CreateRelationship(node_a, node_b, m_relationship)

使用了xlrd、py2neo操控Excel的库和连接操作Neo4j的库

Excel表中关系填写如下：

IDA（数据序号） 类别 名称 特征 位置 图片 视频 模型  IDB（包含关系序号） 关系名称

IDB（数字通过填写英文逗号+空格来隔开 程序通过此分割每个数字）

IDB填写完后最好文本化（分列-->分隔符号-->下一步-->文本）