I had a Dynamo file where Excel.ReadFromFile was working OK. I use Revit 2018.2 at Win 10 and Dynamo 220.127.116.110. After several weeks of doing nothing with Dynamo and Excel files it does not working. I run it at other PC where is Revit 2018.2 at Win 7 and it is working OK. Do you know where can be a problem and how can it be solved?
Here is picture about that https://forums.autodesk.com/t5/revit-api-forum/excel-readfromfile-in-dynamo-on-revit-does-not-working/m-p/7708971/highlight/false#M28032
have you try to set readAsString to True value ?
It was working without that but I tried function Boolean set up to True value but it does not help.
Can you post the error you’re seeing?
Actually it do not show error message. Only in box of Excel.ReadFromFile is information that operation failed.
Reset the path. Send a screenshot of what you’re seeing as well.
btw I have MS Excel 2016. I found this https://github.com/DynamoDS/Dynamo/issues/6505 so I will try delete registry
I have now same problem at other notebook where is excel 2010 on win 7 and Dynamo 1.3 on Revit 2018.2. I deleted there that registry and then I reinstalled (repair) MS Office but it does not help to solve problem with Excel.ReadFromFile.
I found this Excel.ReadFromFile failing with Excel2016 but although I moved files to C:\ it does not solve it.
So I did update at Excel version 1712 and it does help. It is working again !!! Here are helpful information https://www.tenforums.com/tutorials/44833-check-updates-office-2016-windows.html and https://support.office.com/en-us/article/what-s-new-in-office-365-95c8d81d-08ba-42c1-914f-bca4603e1426?ui=en-US&rs=en-US&ad=US and https://github.com/DynamoDS/Dynamo/issues/7488
Thx for help.