AnsweredAssumed Answered

vrf Using third party dot net controls and libraries

Question asked by nick on Apr 4, 2008
Hi Henrik

That seems to fix it!  Thanks for your help.

Best regards

Nick



       Hi Nick
 
Thats wierd!
 
The only thing i can come up with is that the dll is not in the assembly cache
 
Try to install it in the assembly cache with the gacutil tool
 
 
gacutil -i spreadsheetgear.dll
 
Hope this helps
 
Regards
 
Henrik Rune Jakobsen
 

From: HYPERLINK "mailto:nick@evanstest.co.uk"Nick Evans
Sent: Friday, April 04, 2008 2:20 PM
To: HYPERLINK "mailto:vrf@agilent.com"VRF
Subject: RE: [vrf] Using third party dot net controls and libraries


Hi Henrik

 

The product itself ships with one dll.  Spreadsheetgear.dll.   Using the .net reflector indicates that the iworkbook type is located within the spreadsheetgear.dll.

 

I have not used .net reflector before.  Is it supposed to show all links and dependencies for a particular assembly?  I guess from what you said that there may be another unspecified dll that is being called by the spreadsheetgear.dll.

 

Anyway, thanks for your input.

 

Best regards

 

Nick

  _____  

From: code cow [mailto:codecow_@hotmail.com]
Sent: 04 April 2008 11:59
To: Nick Evans; VRF
Subject: RE: [vrf] Using third party dot net controls and libraries

 

Hi Nick

I don't know the spreadsheetgear product, but the TypeLoadException indicates that it tries to load a object from a different dll, which it cant find.

Have you verified that you have referenced all the necessary dll's ?

Try to use the .NET reflector to find out in which dll the iworkbook type is situated


http://www.aisto.com/roeder/dotnet/


Regards

Henrik Rune Jakobsen

  _____  

From: nick@evanstest.co.uk
To: vrf@agilent.com
Subject: [vrf] Using third party dot net controls and libraries
Date: Fri, 4 Apr 2008 11:48:13 +0100

Hi All

 

I am currently trying to evaluate a third party dot net library/control called spreadsheetgear.  This library essentially provides excel like spreadsheet functionality including a workbook viewer component.

 

Unfortunately, the library seems to be incompatible with vee.

 

I have referenced the spreadsheetgear.dll assembly under .net assembly references and imported all of the namespaces for the library.  I can now see those namespaces from formula boxes and can see them under .net operation builder, etc.

 

However, even when I run the simplest of formula on the library I get an error 760 saying something like “Exception type: System.TypeLoadException  Failed to load type spreadsheetgear.iworkbook”

 

I am also evaluating a competing product “Farpoint Spread 4.0 .net” and that product seems to work ok within vee.

 

Does anyone have any insight, guidance, thoughts, etc about how to get third party dot net libraries working reliably in vee.  Should I expect all third party .net components to work ok with vee?

 

Thanks and regards

 

Nick

 


---
You are currently subscribed to vrf as: codecow_@hotmail.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

 

  _____  

Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! HYPERLINK "http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us"Try it!


---
You are currently subscribed to vrf as: codecow_@hotmail.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".

---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes