Import big Excel pivot table to Neo4j

[bent_s_lund]

I need to import a Excel-file that seems to be a "pivot-table" of sort.
It contains 6.000 rows representing objects (products), and the columns holds the properties for all types of objects.

call apoc.load.xls('file:///export.xlsx','Sheet1') yield map return * lists 1000 columns.

I am looking for a way to import this without explicitly listing all columns/properties if tis is possible?

Something like this:
call apoc.load.xls...
yield... something
create 'product' set properties = xls columns

Thanks in advance!
Regards,
Bent

[mckenzma]

Are you attempting to import each row and just create nodes for each row? Or are you trying to create nodes and relationships?

Just adding a link to the documentation in case. I think using a mapping might help solve the issue.

[dana_canzano]

@bent.s.lund

see also SET - Neo4j Cypher Manual and where apoc.load.xls yields a map you could do similar to

call apoc.load.xls('file:///export.xlsx','Sheet1') yield map  create (n:Product) set n += map;