Connection with excel 2007

Hi everybody,

With a friend, we are trying to deal with the connection between excel and GH.

We followed this tutorial on youtube: https://www.youtube.com/watch?v=7Cb4NuF2wcw

(thx Damien)

When we tried at home it worked with excel 2003. Unfortunatly, at my office we only have excel 2007 and we get the following result:

Error: old format or the library type is not valide. (exception HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) (line:0)

(I tranlsated from french)

We tried to change :

xlApp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application")

xlApp = Marshal.GetActiveObject("Excel.Application")

But it doesn't work

It seems that it comes from the region setting and the language used by the software. This explanation was found on microsoft forum but we did not find the solution.

Does anybody has a clue to solve this problem but still in GH?

thx in advance

Replies to This Discussion

Permalink Reply by to] on January 26, 2010 at 8:49am

hi suryansh

with the file parser i can only read but with the excel linkage i can build up a more interactive solution
sure if i only have to read data the file parser is the best solution (gsa data or ecotec..etc) but if i want to read and write it offers much more possibilities with excel or with the open office version from luis

Permalink Reply by Suryansh Chandra on January 27, 2010 at 5:40am

Hmm.. I see. I haven't tried that script yet, but now that you mentioned about the interactivity, I am going to give it a try.

Thanks!

Permalink Reply by Sarah Neault on April 21, 2010 at 7:16am

i want to read gps data! i've managed to get the coordinates (lat, long, ele) out of a kml file, but i'd like to read time into GH as well. can anyone one help with the vb script for this?

the code which gets me coodinates from my kml file (yay!) via the "read file" component (no useful time data available in this file):

Dim parts As String() = data.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries)

Dim x As Double = Double.Parse(parts(1))
Dim y As Double = Double.Parse(parts(2))
Dim z As Double = Double.Parse(parts(3))

Return New On3dPoint(x, y, z)

the gpx file i would like to read (lat, long, ele, date/time) is attached (i need to generate a list of points, and times)

Attachments:

WACmap Path 1.txt, 7 KB

Permalink Reply by Jeff Ponitz on June 17, 2010 at 10:00am

Hi Sarah,

I'm also trying to read GPS in GH...I'm fairly new to GH though, and am having trouble understanding the code in your post. Can you explain what you're doing, or upload a definition file? I'd greatly appreciate it!

Permalink Reply by Alpha222 on February 4, 2010 at 3:35am

Hi GrassHoppers,
would anybody tell me about the URL of Damien'blog?? I am looking for an article about Excel2GH at Demien's blog,but I just cannot find it. Thanks in advance.

Permalink Reply by Minh on February 4, 2010 at 3:41am

http://liquidtectonics.blogspot.com/

here it is

Permalink Reply by Alpha222 on February 4, 2010 at 4:21am

Thank you Minh~~

Permalink Reply by wing yun on February 6, 2010 at 7:47pm

i have the same problem encountered... is there anyone can provide the solution ?

Permalink Reply by Ben Fortunato on February 16, 2010 at 7:13pm

I was trying to follow the video above but I can't read any of the code. I'm trying to understand all the ins and outs of getting data from GH into a workbook and then back into GH. Is it possible for someone to post a GHX definition where they used this vb script component in it so I can work it out from there?

Permalink Reply by Damien Alomar on February 16, 2010 at 9:13pm

If you look at the other Excel posts on the site, you'll see I posted one after it with all the code from the video. The code previous has a few lines that takes care of the COM connection to a running instance of excel. Beyond both of those snippets, its standard excel coding and there's plenty of resources out there on the web for that.

Permalink Reply by Ben Fortunato on February 19, 2010 at 2:15pm

Thanks! I found a ghx file and some info on the LiquidTectomics page. I'm getting a handle on the excel scripting which is straight foward. What I'm having a problem with is finding out how to get data FROM to excel. This script seems to take values from excel and then put them out as an array. i need to grab data from the vb component, insert the array into the cells, manipulate thoose cells through excel code or via the user interface and then grap this information in rhino.

Permalink Reply by Ben Fortunato on February 19, 2010 at 2:18pm

sorry that should read: getting data FROM a rhino array (in actuality a datatree, but I think this is really just an array) to an excel worksheet/range