Cannot import from excel

Revit
,
1

Hi,

I am a complete beginner with Dynamo and have fallen at the first hurdle… I am trying to import some coordinates from excel, but keep getting an error when I try to run the Data.ImportExcel node. I have tried moving the file location, shortening the file path, repairing MS office and reinstalling Revit with no success - can anyone see if I am missing something?

image
image1338×667 211 KB

2

@eddie.keegan

Welcome to the forum. :slight_smile:

Did you check the SheetName for spelling errors?
Or click the sheet name in Excel and copy it, then paste the name in your codeblock.

Marcel

3

Thanks Marcel :slight_smile: ,

I have tried that with no luck, have also tried with a new spreadsheet importing from “Sheet1” with no luck.

4

Hi eddie…can you export ?

6

HI Sovitek, exporting doesn’t seem to work either, I get the same error:

image
image851×502 53.1 KB

7

then it sounds of the good old excel issue…try to search here many have and had the same issue…