Read from excel - TT Toolbox Not working

Hi,

The read from excel component of the TT toolbox (2.0.3 GHA 2022-11-16) does not work.

I get this error: 1. Solution exception:Method not found: ‘System.Object System.Runtime.InteropServices.Marshal.GetActiveObject(System.String)’.

Start with disconnecting the true toggle then make sure the Ws input is written correctly.
I use it all the time with no problems at all.
BTW: there is TT2 available on F4R, worth checking out.

1 Like

Still does not work:

File:

image

Can you, please, send me that excel file? I can test it here.

ReadReactions.zip (7.7 KB)

Thanks for your help, I really appreciate :slight_smile:

@tommasovidali94 what version of Rhino are you running?

Version 8
(8.1.23325.13001, 2023-11-21)

No problem reading it V7:

but V8 struggles:


If you have valid licence, maybe you should, for this particular task, use V7.

1 Like

Thanks Piotr. I will let the topic open maybe someone knows what is going on in Rhino8 :slight_smile:

I’m glad this came out. I will be switching to V8 and this is one of a key features I am relying on.

1 Like

@tommasovidali94 can you try starting Rhino with .NET Framework described here:

  1. Create a new shortcut for Rhino in Windows
  2. Edit the shortcut
  3. Add command line argument /netfx (see here)
  4. Double click on the shortcut
  5. Test the Excel-plugin

Does that make a difference?

1 Like

Same here

It worked for me. Thanks for the tip. This should be more exposed to the users with a question at the start to which version we would like to work, and option: don’t ask again

Thanks for confirming @Piotr. There is a way to always start Rhino 8 with .NET Framework, but you most likey don’t want that…

@stevebaer @curtisw any recommendations how we (authors of TT Toolbox) can interop with Excel from Rhino 8? :thinking:

I am surprised this hasn’t been announced widely.
The message: hey, we are switching from Net to Core tells me nothing, but if you say: your old plugin will stop working - it is a red sign for me.

You need to avoid any of the methods/classes that are no longer in .NET. Namely, System.Runtime.InteropServices.Marshal.GetActiveObject. You can replace it with something like this.

I’ve checked your plugin with our compat tool and it appears that is the only one that needs fixing up.

Hope this helps!

1 Like

What do we gain from switching between these two systems?

Thanks Curtis! We’ll look into it.

1 Like

There is some explanation here

2 Likes

Hey All,
Just released a new patch (version 2.0.5) of TT Toolbox that should work in Rhino 8 and Rhino 7.

4 Likes