sn0rt

Hello

Question on writing excel interop automation plugins. I wrote a plugin which requires serialization/deserialization. When I attempt to deserialize an object, i get 'assembly not found' exception. From what I understand, the serializer embeds the assembly identification in the serialized file, and when i try to pull back the object it can not locate the definition.

Does anyone have a workaround on this the assembly is strong-named, and registered, all the functions of the plugin are working except this serialization issue.

Thanks!

-igor




Re: Visual Studio Tools for Office Excel Automation Plugins, Deserialization fails

OmegaMan

Are your sure this is related to VSTO/the plugin...(I know stupid question <g>) but can you do the same process outside the VSTO project say in a console application Serialization is a strange beast sometinmes....





Re: Visual Studio Tools for Office Excel Automation Plugins, Deserialization fails

sn0rt

The serialization works fine in a sandbox, but once the plugin gets hooked up to excel automation services - it fails to locate the proper assembly describing that class, even though it is in GAC.

Is there a way to force-load the assembly and somehow pass on to the desiarlization object






Re: Visual Studio Tools for Office Excel Automation Plugins, Deserialization fails

Andrew Whitechapel - MSFT

Please provide more detail. As OmegaMan points out, it is not at all clear that you're even building a VSTO solution here. Is this a VSTO solution What do you mean by "plug-in" Is this a managed automation add-in Or is it a managed COM add-in Are you building UDFs here Is it a document-level VSTO solution If it's an app-level add-in for Excel, using VSTO, you must be targeting Office 12 Or is this an Excel services question





Re: Visual Studio Tools for Office Excel Automation Plugins, Deserialization fails

Andrew Whitechapel - MSFT

It's been a while since my last post, and there's been no response. I'm guessing that's because you've found the answer elsewhere, so I'm closing this question now. If you did not get an answer elsewhere, please respond with answers to my previous questions, and we'll try to help you.





Re: Visual Studio Tools for Office Excel Automation Plugins, Deserialization fails

miker55

Hi Igor,

We are having the same problem with our Excel automation failing on deserializing a remote object, but the serialization works fine outside of Excel.

Did you ever find a solution

TIA,

Mike Rodriguez