Excel opens when the script runs, but it does not open the excel file. The error note in Dynamo reads “Warning: Excel.ReadFromFile operation failed. File path not found.”
Things I have already tried:
It fails with the excel file on a mapped drive, or a local drive
It fails with *.xls, *.xlxs and *.csv
It fails with, and without, the File.FromPath node
If relevant, this is Dynamo1.2.1.3083, running in Revit 2017.
On further testing, I found i was getting a similar error with reading text files, so I changed the path of the files from
C:\Users\cprettyman.CERAMI\Desktop\Dynamo Scripts
to
C:\Temp
and now its working, so I seem to have been wrong about where the problem was.
Does Dynamo1.2 have issues with paths that have spaces?
The script itself is sitting in the same desktop folder. I’ll check with IT to see if they somehow limited access to desktop folders from applications, but I doubt they would restricted it so that Dynamo could open the script, but not the excel file
I’ve had a similar issue with the excel nodes. I too thought it was the spaces as it seemed to work when I moved the data file to another location that didn’t have spaces in the folder name.
Same issue here. A file location with spaces in the folder name does work, a mapped drive results in a failed Excel.ReadFromFile. Also a direct approach (for instance: \\Networkfolder\etcetera\ doesn’t work either.
I have the same issue. Using a path without spaces doesn’t work either.
Started after installing Office 2016. I will try installing the 64bit package and see if that resolves it.
After a bunch of testing, I finally concluded that this was unrelated to the version of excel I was using. Instead, it seems to be related to file location. It reads local files fine, but cannot read anything on a network path.
Charles Prettyman
Senior Associate
[cid:image85128b.JPG@fe76e06e.4a9257cd]
Consultants in Acoustics, AV, IT & Security
I am still running into this issue with both the dyn file and the excel file located on my desktop. I even tried saving the excel file down to 2003 .xls format and still no dice. I don’t think it is a location or format issue at this point. I am not sure what it might be. I am using Dynamo version 1.3.2. When I look at the Notifications I am seeing about a dozen of System.IO.FileLoadException warnings
We had issues when upgrading our Office package, we installed 64 bit (x64) but realised Dynamo would only work with 32 bit (x86) version of office. Not sure if this will help anyone, but thought i would share this regardless.
I believe there is a bug in the file path node - please use a string instead. This should be fixed in dynamo 2.x - alternatively someone could provide a ui node in a package that fixes the issue as a workaround, or perhaps use something like data shapes (if that has a file path node).
We found when upgrading our office suite that the OOTB excel nodes stopped working with the x64 install. We installed the x86 install and it was working fine. This wasn’t on just one machine, but several.
Do you know why this might be the case as it was puzzling as to why this was happening?
