APOC load xls range problem with columns after Z

[thomasf]

I am trying to use apoc.load.xls to import from a large spreadsheet. It seems as if the range has to be between A and Z. But this spreadsheet goes all the way to AY.
Here is an example that works:

And here is an example that does not work:

Neo4j Browser version: 3.2.24

Neo4j Server version: 3.5.8 (enterprise)

The Apache libraries were downloaded a couple of weeks ago.

The spreadsheet can be found here: https://docs.google.com/spreadsheets/d/1zpLDPWQYwACgphPz8MxcKvtbOjF3Ye-z5d2jSnNa1GI/edit#gid=1358645...

Best regards

Thomas

[stefan_armbrust]

Please add a github issue for this. It would be helpful to have the queries and error messages in plain text.

[thomasf]

github.com/neo4j-contrib/neo4j-apoc-procedures

APOC load xls range problem with columns after Z

opened 09:16AM - 11 Nov 19 UTC

ThomasFrisendal

I am trying to use apoc.load.xls to import from a large spreadsheet. It seems as if the range has to be...

[michael_hunger]

Perhaps it's due to the grouped headers?

Can you try to start at A3 instead of A1 ?

Michael

[thomasf]

Good idea, but, no: