Good morning Zach. I have asked in the office and the IT department assured me that there hasn’t been any updates and that we have been using Office 2010 for a very long time.
So, we have unistalled all Dynamo versions from my PC, and reinstalled only 0.9.2 and 1.0.1 but I still cannot make the Excel.ReadFromFile node work. It keeps on stating that the File Path was not found, and opens Excel without any file. It does not matter where the Excel file is located. The same issue keeps on showing up.
While installing the 1.0.1 and the 0.9.2 versions, using the IT admin’s credential, a message popped out on the screen, which I could not make a screen shot because it was remotely done, and it stated that the IT did not have rights to create a new Key for the software (HKEY Error 5). So, the IT staff had to use another type of admin credentials in order to be able to make the installation. Would this have any connection with the issue that I am having?
Just as a test, I have also included 3 extra nodes to test if they would read the File Path. The nodes are the following: ReadExcel (by Hot Gear), Excel.GetExcelWorksheetData (by LunchBox) and Excel.GetExcelWorksheetDataByRange (by LunchBox). They all find the File Path but generate Empty Lists or errors (crashes) Please, see images below:
The first one is just to show that the Excel file contains data and it is not empty.
I have just followed a colleagues suggestion which was to start a new file and check if the first sequence to read from Excel would work, and it did. It is quite funny to see the “same” node coexisting in the same file but only the ones created in the latest version work. I will probably need to do the same with the other nodes that are not working as well. Please, see images below: