Read from Excel

1

Hello every one

I’m trying to load a Excel file into dynamo with the node Excel.ReadFromFile. but when i try, it comes up with this error.

blob.jpg1317×560 177 KB

do any of you, have an idea how to fix that ?

Thanks in advance

1 Like
2

this is what is in the Excel file

Pasted image719×905 13.5 KB

3

try to place in excel the cursor on cell A1, but make sure not to be in the cell directly. Quit all active commands in excel. Make sure the file path is correct. Maybe the name of the file is too long. Try to restart Dynamo.

4

Hallo,

here is the solution Excel read

5

Pasted image1058×732 61.9 KB

6

i’m already using the File.FromPath node

blob.jpg848×422 90.9 KB

7

Okay new qustion why dos it work when the document is on the desktop, and not in a folder ?

blob.jpg866×403 84.1 KB

8

How long is the file path? i.e. are there many folders before that file? try moving the file a folder deeper every dynamo run to test if the file path length is the problem.

9

Are there any special characters in the file path ? Folder names with accents etc. i’be had problems with that before .