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 Ivan Kiryakov on April 21, 2010 at 7:24am

Hi I'm having same problems (old format or the library type is not valide. (exception HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) trying to work with this def here http://lmnts.lmnarchitects.com/?p=375
any ideas how to solve the problem.must be something about the language settings from windows..?I'cant write script components, i just use them :) so I'm stuck

Permalink Reply by lmnts on April 22, 2010 at 11:46am