PH-Tools Open Excel workbook error

Hello!

I’m having difficulty opening an Excel file by providing a link using PH-tools

The programs I am using are RH8 and PHPP V10.4.

First - I’m concerned because “OLD” is written next to “Open Excel workbook.”

Second - When trying to open the Excel file, it shows an error: “1. Solution exception: ‘Microsoft.Office.Interop.Excel’ object has no attribute ‘ApplicationClass’.”

I copied the Microsoft.Office.Interop.Excel file into the script RH8 folder.

I tried various ways to solve it, I changed the interop Excel file in the script map, I changed the Path. I don’t understand the reason for the error."

In Grasshopper Python Script Editor shows Runtime error -

Runtime error (MissingMemberException): ‘Microsoft.Office.Interop.Excel’ object has no attribute ‘ApplicationClass’

Traceback:
line 93, in start_new_instance, “C:\Users\User name\AppData\Roaming\McNeel\Rhinoceros\8.0\scripts\LBT2PH\xl_connect.py”
line 78, in RunScript, “”

Maybe someone can explain the reason for the error and how to fix it. Thank you!

Hello @Ervins ,

It looks from the screenshot there that you have the LBT2PH components. Those components are not supported anymore and do not work (as far as I know) with Rhino 8.

For all PHPP related work, the up-to-date plugin is the “Honeybee-PH” plugin. You can download the free installer here:

I would suggest going to your Grasshopper ‘User Objects’ first and deleting all of those old ‘LBT2PH’ components before you install this new "Honeybee-PH’ package.

Hopefully that new and updated pluing works for you?
best,
@edpmay