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".
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".
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: 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".