Grasshopper and Excel 2007

I watched the tutorial on Liquid Tectonics about making a connection between excel and grasshopper. I tried it myself but I can't get a connection from excel to grasshopper. I tried different OS (vista/xp) and different grasshopper versions. But i can't find the problem. Could excel 2007 be the problem? I can make a connection to excel 2007 with maxscript but not with VB.

Tags: Excel

▶ Reply to This

Replies to This Discussion

Permalink Reply by to] on May 30, 2009 at 11:29am

hi Bram

the problem is inside excel 2007. so if you try 2003 you will have no problem

to]

▶ Reply

Permalink Reply by Alexander Kalachev on June 11, 2009 at 12:03pm

Hi to]
is it possible that problem is OS- vista?

▶ Reply

Permalink Reply by Damien Alomar on May 30, 2009 at 11:32am

The connection to excel 2007 is something that I haven't gotten a chance to really investigate yet. I only have 2003 here, so any details you can give me about what you're seeing (or not seeing) and where any errors occur with 2007 would be helpful. My initial research into differences between excel 2003 and 2007 didn't really come up with much (this page http://technet.microsoft.com/en-us/library/cc179167.aspx#BKMK_Whats... was the best I found), so it looks like I need to get my hands on excel 2007 and see what needs to be updated.

▶ Reply

Permalink Reply by Bram Verbauwhede on May 30, 2009 at 11:47am

I tried your instant update with a point and that is working, if I change a value in excel rhino is redrawing. but grasshopper doesn't have anything to do with this interaction. In grasshopper I just get 1 NULL value and no errors...
I think the libraries are the problem, maybe grasshopper needs to import Microsoft.Office.Interop.Excel

http://vb.net-informations.com/excel-2007/vb.net_excel_2007_tutoria...

Thanks for the fast replies

▶ Reply

Permalink Reply by Damien Alomar on May 30, 2009 at 8:38pm

Thanks for the info Bram. I was actually more worried about the change event, so I'm glad that's not busted. I looked at that link you posted and there might be something in there that will help me track this down. From the initial looks of it, the connection does need to be done differently. Hopefully I'll get a chance to try this out next week and see if I can get to the bottom of it.