Apoc.load.xls not registered?

Neo4j Graph Platform Procedures & APOC
1

I'm using Neo4j Desktop V1.5.8, with a V5.8 local database. I've installed the APOC plugin via the desktop as well as the additional plugins referenced in the V5 apoc documentation. I'm still getting the following error when trying to call the apoc.load.xls function:

There is no procedure with the name apoc.load.xls registered for this database instance. Please ensure you've spelled the procedure name correctly and that the procedure is properly deployed.

I've used the earlier version under V4 without any issues but since moving to a V5 database, I've been unable to get it to load & work. Any ideas? I've restarted the Neo4j Desktop multiple times after moving the jar files to the plugins directory.

2

In Neo4j 5, APOC was split into Core and Extended edition, with official support for the Core edition AFAIK. Unfortunately, the apoc.load.xls if part of the extended version, so you will have to manually install the extended version. See more here: What happened with APOC in Neo4j v5: Core and Extended edition | by Tomaz Bratanic | Towards Data Science

1 Like
3

Thanks for the reply. So what you are telling me is I need the extended APOC file and the current documentation is not correct? The reason I ask is my plugin directory looks like this:

image

I have everything the V5 documentation states I should have for the apoc.load.xls procedure to work (and then some), and I was still getting the error.

4

That did the trick! I was able to run a quick test (load the xlsx file and count the rows returned) and it worked as expected!

1 Like