Read from excel - TT Toolbox Not working

Grasshopper
1

Hi,

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

image
image804×385 24 KB

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

2

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
3

Still does not work:

image
image1068×253 19.9 KB

File:

image

image
image1079×392 27 KB

4

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

5

ReadReactions.zip (7.7 KB)

Thanks for your help, I really appreciate :slight_smile:

6

@tommasovidali94 what version of Rhino are you running?

7

Version 8
(8.1.23325.13001, 2023-11-21)

8

No problem reading it V7:

image
image1617×996 80.4 KB

but V8 struggles:

image
image1493×1009 50.6 KB

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

1 Like
9

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

10

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
11

@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
12

Same here

13

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

14

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:

15

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.

16

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
17

What do we gain from switching between these two systems?

18

Thanks Curtis! We’ll look into it.

1 Like
19

There is some explanation here

2 Likes
20

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

5 Likes