Excel Addin - ClickOnce无法找到部署后操作 | ClickOnce无法找到部署后操作

本文介绍了Excel Addin - ClickOnce无法找到部署后操作的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述 29岁程序员，3月因学历无情被辞！我有一个Excel插件，由clickonce部署和更新。有一些支持文件，我需要这些文件来添加（模板，.xlam等），我使用部署后的程序将这些文件复制到正确的位置。名称：PwC Analytics工具栏来自：file：/// H：/ 4_Resources / Modeling Toolbar / ModellingToolbar.vsto ******* *******异常文本************** Microsoft.VisualStudio.Tools.Applications.Deployment.InstallAddInFailedException：以下用于部署后操作的程序集不能是发现："FileCopyPDA，Version = 1.0.0.0，Culture = neutral，ProcessorArchitecture = msil"。 at Microsoft.VisualStudio.Tools.Applications.Deployment.PostDeploymentActionsHost.Execute（Int32& lastExecutedPostAction，Uri deployManifestUri，AddInInstallationStatus installStatus，String deployManifestXml，String appManifestXml，String hostManifestXml，String [] postActionDataXmls，String productName，String version，String applicationBase，String [] assemblyClassNames，String [] assemblyNames，String [] assemblyFullNames） at Microsoft.VisualStudio.Tools.Applications.Deployment.PostDeploymentActionsHost.Execute（Int32& lastExecutedPostAction，Uri deployManifestUri，AddInInstallationStatus installStatus，String deployManifestXml，String appManifestXml，String hostManifestXml，String [] postActionDataXmls，String productName，String version，String applicationBase，String [] assemblyClassNames，String [] assemblyNames，String [] assemblyFullNames） at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager .InvokePostActions（Uri部署mentUri，AddInInalallationStatus installStatus，String deployManifestXml，String appManifestXml，ApplicationManifest manifest，String productName，String version，AppDomainSetup appDomainSetup） at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn（） at Microsoft。 VisualStudio.Tools.Office.Runtime.SolutionInstaller。<> c__DisplayClass7。< Install> b__0（）该库明显存在于正确的位置：我已更新清单以包含帖子部署例程：<？xml版本= QUOT; 1.0"编码= QUOT; UTF-8英寸;？> < asmv1：assembly xsi：schemaLocation =" urn：schemas-microsoft-com：asm.v1 assembly.adaptive.xsd" manifestVersion = QUOT; 1.0"的xmlns：asmv1 = QUOT;瓮：架构 - 微软-COM：asm.v1"的xmlns = QUOT;瓮：架构 - 微软-COM：asm.v2"的xmlns：asmv2 = QUOT;瓮：架构 - 微软-COM：asm.v2"的xmlns：的xsi = QUOT; HTTP：//www.w3.org/2001/XMLSchema-instance"的xmlns：co.v1 = QUOT;瓮：架构 - 微软-COM：clickonce.v1"的xmlns：asmv3 = QUOT;瓮：架构 - 微软-COM：asm.v3"的xmlns：DSIG = QUOT; HTTP：//www.w3.org/2000/09/xmldsig#"的xmlns：co.v2 = QUOT;瓮：架构 - 微软-COM：clickonce.v2"> < asmv1：assemblyIdentity name =" ModellingToolbar.dll"版本= QUOT; 0.8.2.36"公钥=" 62c614bc780ff547"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL"类型= QUOT; win32的" /> < description xmlns =" urn：schemas-microsoft-com：asm.v1"> ModellingToolbar< / description> < application /> < entryPoint> < co.v1：customHostSpecified /> < / entryPoint> < trustInfo> < security> < applicationRequestMinimum> < PermissionSet Unrestricted =" true" ID = QUOT;定制" SameSite = QUOT;位点QUOT; /> < defaultAssemblyRequest permissionSetReference =" Custom" /> < / applicationRequestMinimum> < requestedPrivileges xmlns =" urn：schemas-microsoft-com：asm.v3"> <！ - UAC清单选项如果要更改Windows用户帐户控制级别，请使用以下方法之一替换 requestedExecutionLevel节点。 < requestedExecutionLevel level =" asInvoker" uiAccess = QUOT假QUOT; /> < requestedExecutionLevel level =" requireAdministrator" uiAccess = QUOT假QUOT; /> < requestedExecutionLevel level =" highestAvailable" uiAccess = QUOT假QUOT; /> 如果要将文件和注册表虚拟化用于向后兼容性，则删除requestedExecutionLevel节点。 - > < requestedExecutionLevel level =" asInvoker" uiAccess = QUOT假QUOT; /> < / requestedPrivileges> < / security> < / trustInfo> <依赖> < dependentOS> < osVersionInfo> < os majorVersion =" 5" minorVersion = QUOT 1 QUOT; buildNumber = QUOT; 2600" servicePackMajor = QUOT; 0" /> < / osVersionInfo> < / dependentOS> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" Microsoft.Windows.CommonLanguageRuntime"版本= QUOT; 4.0.30319.0" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" Microsoft.Office.Tools"版本= QUOT; 10.0.0.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" Microsoft.Office.Tools.Common"版本= QUOT; 10.0.0.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" Microsoft.Office.Tools.Excel"版本= QUOT; 10.0.0.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" Microsoft.Office.Tools.v4.0.Framework"版本= QUOT; 10.0.0.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" Microsoft.VisualStudio.Tools.Applications.Runtime"版本= QUOT; 10.0.0.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0"版本= QUOT; 10.0.0.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" preRequisite" allowDelayedBinding = QUOT;真"> < assemblyIdentity name =" stdole"版本= QUOT; 7.0.3300.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" /> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" install" allowDelayedBinding = QUOT;真"基本代码= QUOT; FileCopyPDA.dll"大小= QUOT; 14848"> < assemblyIdentity name =" FileCopyPDA"版本= QUOT; 1.0.0.0"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < hash> < dsig：Transforms> < dsig：Transform Algorithm =" urn：schemas-microsoft-com：HashTransforms.Identity" /> < / dsig：Transforms> < dsig：DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /> < dsig：DigestValue> 1M / Gb + dT4e7kH1jJZBx0rTWPS64 =< / dsig：DigestValue> < / hash> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" install" allowDelayedBinding = QUOT;真"基本代码= QUOT; Microsoft.Office.Tools.Common.v4.0.Utilities.dll"大小= QUOT; 32664"> < assemblyIdentity name =" Microsoft.Office.Tools.Common.v4.0.Utilities"版本= QUOT; 10.0.0.0"公钥=" B03F5F7F11D50A3A"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < hash> < dsig：Transforms> < dsig：Transform Algorithm =" urn：schemas-microsoft-com：HashTransforms.Identity" /> < / dsig：Transforms> < dsig：DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /> < dsig：DigestValue> CtnCtseaMyfROIGe0ENdGO6arHg =< / dsig：DigestValue> < / hash> < / dependentAssembly> < / dependency> <依赖> < dependentAssembly dependencyType =" install" allowDelayedBinding = QUOT;真"基本代码= QUOT; ModellingToolbar.dll"大小= QUOT; 211968"> < assemblyIdentity name =" ModellingToolbar"版本= QUOT; 1.0.0.0"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < hash> < dsig：Transforms> < dsig：Transform Algorithm =" urn：schemas-microsoft-com：HashTransforms.Identity" /> < / dsig：Transforms> < dsig：DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /> < dsig：DigestValue> cnK0qN + IfRY + e6zF61Xal3JVguY =< / dsig：DigestValue> < / hash> < / dependentAssembly> < / dependency> < file name =" Data \ Analytics VBA.xlam"大小= QUOT; 483169"> < hash> < dsig：Transforms> < dsig：Transform Algorithm =" urn：schemas-microsoft-com：HashTransforms.Identity" /> < / dsig：Transforms> < dsig：DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /> < dsig：DigestValue> uyz3vgCL4Et5AIyCaVJ4m86ovl4 =< / dsig：DigestValue> < / hash> < / file> < file name =" Data \Table Library.xlsx"大小= QUOT; 40619"> < hash> < dsig：Transforms> < dsig：Transform Algorithm =" urn：schemas-microsoft-com：HashTransforms.Identity" /> < / dsig：Transforms> < dsig：DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /> < dsig：DigestValue> uuqAOxczZml8Izm / RXtPhBuMhO4 =< / dsig：DigestValue> < / hash> < / file> < file name =" ModellingToolbar.dll.config"大小= QUOT; 2035"> < hash> < dsig：Transforms> < dsig：Transform Algorithm =" urn：schemas-microsoft-com：HashTransforms.Identity" /> < / dsig：Transforms> < dsig：DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /> < dsig：DigestValue> mLXELhKdDKTy6lHpMDKThMfGV8o =< / dsig：DigestValue> < / hash> < / file> < vstav3：addIn xmlns：vstav3 =" urn：schemas-microsoft-com：vsta.v3"> < vstav3：entryPointsCollection> < vstav3：entryPoints> < vstav3：entryPoint class =" AnalyticsToolbar.ThisAddIn"> < assemblyIdentity name =" ModellingToolbar"版本= QUOT; 1.0.0.0"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / vstav3：entryPoint> < / vstav3：entryPoints> < / vstav3：entryPointsCollection> < vstav3：update enabled =" true" /> < vstav3：postActions> < vstav3：postAction> < vstav3：entryPoint class =" FileCopyPDA.FileCopyPDA"> < assemblyIdentity name =" FileCopyPDA"版本= QUOT; 1.0.0.0"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL" /> < / vstav3：entryPoint> < vstav3：postActionData> < / vstav3：postActionData> < / vstav3：postAction> < / vstav3：postActions> < vstav3：application> < vstov4：customizations xmlns：vstov4 =" urn：schemas-microsoft-com：vsto.v4"> < vstov4：customization> < vstov4：appAddIn application =" Excel" LoadBehavior的= QUOT; 3英寸的keyName = QUOT; ModellingToolbar"> < vstov4：friendlyName> AnalyticsToolbar< / vstov4：friendlyName> < vstov4：description> ModellingToolbar< / vstov4：description> < vstov4.1：ribbonTypes xmlns：vstov4.1 =" urn：schemas-microsoft-com：vsto.v4.1"> < vstov4.1：ribbonType name =" AnalyticsToolbar.AnalyticsToolbar，ModellingToolbar，Version = 1.0.0.0，Culture = neutral，PublicKeyToken = null" /> < /vstov4.1：ribbonTypes> < / vstov4：appAddIn> < / vstov4：customization> < / vstov4：自定义> < / vstav3：application> < / vstav3：addIn> < publisherIdentity name =" CN = PWCAU \Carl Gabel" issuerKeyHash = QUOT; 44fc7b7d4e21f7f9cc5d017925abeb59f4a78bc2" />< Signature Id =" StrongNameSignature" xmlns =" http：//www.w3.org/2000/09/xmldsig#">< SignedInfo>< CanonicalizationMethod Algorithm =" http：//www.w3.org/2001/10/xml -EXC-C14N＃" />< SignatureMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#rsa-sha1" />< Reference URI ="">< Transforms>< Transform Algorithm =" http：//www.w3.org/2000/09/xmldsig#enveloped-signature" />< Transform Algorithm =" http：//www.w3.org/2001/10/xml-exc-c14n#" />< / Transforms>< DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /><的DigestValue> opzHoPo7dXCZr6V377pR04PKyUE = LT; /的DigestValue>< /参考和GT;< /的SignedInfo><的SignatureValue> gNkVsa1lwvv6QxPQoTa / YumEQ2SfUxuqFC6DzavZCsaythQCVyaWJyOvWx23JbaVbufX1gBm / GlaMLCvBLbQH6tsg3jCXSJdOeVrjL5mctOdG8qHC7bR / lmBvxxA4ZEiA3gl + pdygPa8kVpxHtH2piCplNj5UaM2 / hfKbnPyAlM = LT; /的SignatureValue><密钥信息标识= " StrongNameKeyInfo">< KEYVALUE>< RSAKeyValue><模量> xIizsL + NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV ++ 1Lan7AAQsmKWE3Jpff0 = LT; /模量><指数> AQAB< /指数>< / RSAKeyValue>< / KEYVALUE>< ; msrel：RelData xmlns：msrel =" http://schemas.microsoft.com/windows/rel/2005/reldata">< r：license xmlns：r =" urn：mpeg：mpeg21：2003：01 -rel-R-NS" xmlns：as =" http：//schemas.microsoft.com/windows/pki/2005/Authenticode">< r：grant>< as：ManifestInformation Hash =" 41c9ca83d351baef77a5af9970753bfaa0c79ca2"描述= QUOT;" Url ="">< as：assemblyIdentity name =" ModellingToolbar.dll"版本= QUOT; 0.8.2.36"公钥=" 62c614bc780ff547"语言= QUOT;中性" ProcessorArchitecture用于= QUOT; MSIL"类型= QUOT; win32的" />< / as：ManifestInformation>< as：SignedBy />< as：AuthenticodePublisher>< as：X509SubjectName> CN = PWCAU \Carl Gabel< / as：X509SubjectName>< / as：AuthenticodePublisher> < / r：grant>< r：issuer>< Signature Id =" AuthenticodeSignature" xmlns =" http：//www.w3.org/2000/09/xmldsig#">< SignedInfo>< CanonicalizationMethod Algorithm =" http：//www.w3.org/2001/10/xml -EXC-C14N＃" />< SignatureMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#rsa-sha1" />< Reference URI ="">< Transforms>< Transform Algorithm =" http：//www.w3.org/2000/09/xmldsig#enveloped-signature" />< Transform Algorithm =" http：//www.w3.org/2001/10/xml-exc-c14n#" />< / Transforms>< DigestMethod Algorithm =" http：//www.w3.org/2000/09/xmldsig#sha1" /><的DigestValue> 2xMGBuysB39GSTThonM9Ybf3vw8 = LT; /的DigestValue>< /参考和GT;< /的SignedInfo><的SignatureValue> ugsaiD7DK5KgULmz7xQSSQhWVo1kmnxXPAar6XBRiqGs6kkSaiNAcDLIp9e59jRj5fLrPIldPVXVd5PFbYLGCP + wxt9NF3CmG3PUoMt6jAqQrIFczQfAxbQGBLatPgqs0qJyIJHP9IcqzDwc5odQWEkm6L4oD / eO13L3gbLpwME = LT; /的SignatureValue><密钥信息>< KEYVALUE>< RSAKeyValue> ;<模量> xIizsL + NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV ++ 1Lan7AAQsmKWE3Jpff0 = LT; /模量><指数> AQAB< /指数>< / RSAKeyValue>< / KEYVALUE>< X509Data>< x509证书> MIIB2TCCAUKgAwIBAgIQF2tBiDEQk59Hb2 / VpAmPszANBgkqhkiG9w0BAQUFADArMSkwJwYDVQQDHiAAUABXAEMAQQBVAFwAQwBhAHIAbAAgAEcAYQBiAGUAbDAeFw0xMzAyMTMyMzM4NTNaFw0xNDAyMTQwNTM4NTNaMCsxKTAnBgNVBAMeIABQAFcAQwBBAFUAXABDAGEAcgBsACAARwBhAGIAZQBsMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEiLOwv42Ii1m9MNEsDa + K2lCTqX1AFjRVQ8yCbRtfS2 / Ë 16yQrahbhvlKMYtUobwjSDu2FxFJYBimCeO3cpIJiNnrXcs1GzJSveZm1pa3YbRHK99olHtf2uUPXq5wJyveyXlUGDb2cEDHOEIPeMMZX77UtqfsABCyYpYTcml9 / QIDAQABMA0GCSqGSIb3DQEBBQUAA4GBADCjJbyqFb8aoolbfMrWqO7Gad8VG4Wz1hFgRvdSUXfOB4L6qQ5HO + XRgI3cqIeYWWrdJkHEUcFGXGAbhfFB8Tvrfsw7G1y5XHY6gqDEniT19WtIVuhlKFh3RAegE8cHUnUF1SQMJmaA1FVvPwDpb + 3U6kphBw0Wv9MaNFnxxGDC< / x509证书>< / X509Data>< /密钥信息>< /签名及GT;< / R：发行人>< / R：许可证>< / msrel：RelData>< /密钥信息>< /签名及GT;< / asmv1：组件> 我已根据演练。这工作我只是不确定我做了什么来打破它。解决方案嗨QuinRiva，感谢您在MSDN论坛上发帖。我会就你的问题咨询我的同事。如果有任何更新，我们会通知您。感谢您的耐心和理解。祝你好运， I have an Excel addin that is deployed and updated by clickonce. There are some supporting files that files that I need for the addin (templates, .xlam, etc.) and I use a Post-Deployment procedure to copy those files to the correct location.After mucking about with an unrelated problem, I screwed up the deployment procedure and now it errors out whenever I attempt to Install/or update the app, stating that the post deployment file cannot be found:Name: PwC Analytics ToolbarFrom: file:///H:/4_Resources/Modelling Toolbar/ModellingToolbar.vsto************** Exception Text **************Microsoft.VisualStudio.Tools.Applications.Deployment.InstallAddInFailedException: The following assembly for a post-deployment action cannot be found: "FileCopyPDA, Version=1.0.0.0, Culture=neutral, ProcessorArchitecture=msil". at Microsoft.VisualStudio.Tools.Applications.Deployment.PostDeploymentActionsHost.Execute(Int32& lastExecutedPostAction, Uri deployManifestUri, AddInInstallationStatus installStatus, String deployManifestXml, String appManifestXml, String hostManifestXml, String[] postActionDataXmls, String productName, String version, String applicationBase, String[] assemblyClassNames, String[] assemblyNames, String[] assemblyFullNames) at Microsoft.VisualStudio.Tools.Applications.Deployment.PostDeploymentActionsHost.Execute(Int32& lastExecutedPostAction, Uri deployManifestUri, AddInInstallationStatus installStatus, String deployManifestXml, String appManifestXml, String hostManifestXml, String[] postActionDataXmls, String productName, String version, String applicationBase, String[] assemblyClassNames, String[] assemblyNames, String[] assemblyFullNames) at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InvokePostActions(Uri deploymentUri, AddInInstallationStatus installStatus, String deployManifestXml, String appManifestXml, ApplicationManifest manifest, String productName, String version, AppDomainSetup appDomainSetup) at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn() at Microsoft.VisualStudio.Tools.Office.Runtime.SolutionInstaller.<>c__DisplayClass7.<Install>b__0()The library clearly exists in the correct location:I have updated the manifest to include the post deployment routine:<?xml version="1.0" encoding="utf-8"?><asmv1:assembly xsi:schemaLocation="urn:schemas-microsoft-com:asm.v1 assembly.adaptive.xsd" manifestVersion="1.0" xmlns:asmv1="urn:schemas-microsoft-com:asm.v1" xmlns="urn:schemas-microsoft-com:asm.v2" xmlns:asmv2="urn:schemas-microsoft-com:asm.v2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:co.v1="urn:schemas-microsoft-com:clickonce.v1" xmlns:asmv3="urn:schemas-microsoft-com:asm.v3" xmlns:dsig="http://www.w3.org/2000/09/xmldsig#" xmlns:co.v2="urn:schemas-microsoft-com:clickonce.v2"> <asmv1:assemblyIdentity name="ModellingToolbar.dll" version="0.8.2.36" publicKeyToken="62c614bc780ff547" language="neutral" processorArchitecture="msil" type="win32" /> <description xmlns="urn:schemas-microsoft-com:asm.v1">ModellingToolbar</description> <application /> <entryPoint> <co.v1:customHostSpecified /> </entryPoint> <trustInfo> <security> <applicationRequestMinimum> <PermissionSet Unrestricted="true" ID="Custom" SameSite="site" /> <defaultAssemblyRequest permissionSetReference="Custom" /> </applicationRequestMinimum> <requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">  <requestedExecutionLevel level="asInvoker" uiAccess="false" /> </requestedPrivileges> </security> </trustInfo> <dependency> <dependentOS> <osVersionInfo> <os majorVersion="5" minorVersion="1" buildNumber="2600" servicePackMajor="0" /> </osVersionInfo> </dependentOS> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="Microsoft.Windows.CommonLanguageRuntime" version="4.0.30319.0" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="Microsoft.Office.Tools" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="Microsoft.Office.Tools.Common" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="Microsoft.Office.Tools.Excel" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="Microsoft.Office.Tools.v4.0.Framework" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="Microsoft.VisualStudio.Tools.Applications.Runtime" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="preRequisite" allowDelayedBinding="true"> <assemblyIdentity name="stdole" version="7.0.3300.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" /> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="FileCopyPDA.dll" size="14848"> <assemblyIdentity name="FileCopyPDA" version="1.0.0.0" language="neutral" processorArchitecture="msil" /> <hash> <dsig:Transforms> <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" /> </dsig:Transforms> <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /> <dsig:DigestValue>1M/Gb+dT4e7kH1jJZBx0rTWPS64=</dsig:DigestValue> </hash> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="Microsoft.Office.Tools.Common.v4.0.Utilities.dll" size="32664"> <assemblyIdentity name="Microsoft.Office.Tools.Common.v4.0.Utilities" version="10.0.0.0" publicKeyToken="B03F5F7F11D50A3A" language="neutral" processorArchitecture="msil" /> <hash> <dsig:Transforms> <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" /> </dsig:Transforms> <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /> <dsig:DigestValue>CtnCtseaMyfROIGe0ENdGO6arHg=</dsig:DigestValue> </hash> </dependentAssembly> </dependency> <dependency> <dependentAssembly dependencyType="install" allowDelayedBinding="true" codebase="ModellingToolbar.dll" size="211968"> <assemblyIdentity name="ModellingToolbar" version="1.0.0.0" language="neutral" processorArchitecture="msil" /> <hash> <dsig:Transforms> <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" /> </dsig:Transforms> <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /> <dsig:DigestValue>cnK0qN+IfRY+e6zF61Xal3JVguY=</dsig:DigestValue> </hash> </dependentAssembly> </dependency> <file name="Data\Analytics VBA.xlam" size="483169"> <hash> <dsig:Transforms> <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" /> </dsig:Transforms> <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /> <dsig:DigestValue>uyz3vgCL4Et5AIyCaVJ4m86ovl4=</dsig:DigestValue> </hash> </file> <file name="Data\Table Library.xlsx" size="40619"> <hash> <dsig:Transforms> <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" /> </dsig:Transforms> <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /> <dsig:DigestValue>uuqAOxczZml8Izm/RXtPhBuMhO4=</dsig:DigestValue> </hash> </file> <file name="ModellingToolbar.dll.config" size="2035"> <hash> <dsig:Transforms> <dsig:Transform Algorithm="urn:schemas-microsoft-com:HashTransforms.Identity" /> </dsig:Transforms> <dsig:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /> <dsig:DigestValue>mLXELhKdDKTy6lHpMDKThMfGV8o=</dsig:DigestValue> </hash> </file> <vstav3:addIn xmlns:vstav3="urn:schemas-microsoft-com:vsta.v3"> <vstav3:entryPointsCollection> <vstav3:entryPoints> <vstav3:entryPoint class="AnalyticsToolbar.ThisAddIn"> <assemblyIdentity name="ModellingToolbar" version="1.0.0.0" language="neutral" processorArchitecture="msil" /> </vstav3:entryPoint> </vstav3:entryPoints> </vstav3:entryPointsCollection> <vstav3:update enabled="true" /> <vstav3:postActions> <vstav3:postAction> <vstav3:entryPoint class="FileCopyPDA.FileCopyPDA"> <assemblyIdentity name="FileCopyPDA" version="1.0.0.0" language="neutral" processorArchitecture="msil" /> </vstav3:entryPoint> <vstav3:postActionData> </vstav3:postActionData> </vstav3:postAction> </vstav3:postActions> <vstav3:application> <vstov4:customizations xmlns:vstov4="urn:schemas-microsoft-com:vsto.v4"> <vstov4:customization> <vstov4:appAddIn application="Excel" loadBehavior="3" keyName="ModellingToolbar"> <vstov4:friendlyName>AnalyticsToolbar</vstov4:friendlyName> <vstov4:description>ModellingToolbar</vstov4:description> <vstov4.1:ribbonTypes xmlns:vstov4.1="urn:schemas-microsoft-com:vsto.v4.1"> <vstov4.1:ribbonType name="AnalyticsToolbar.AnalyticsToolbar, ModellingToolbar, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" /> </vstov4.1:ribbonTypes> </vstov4:appAddIn> </vstov4:customization> </vstov4:customizations> </vstav3:application> </vstav3:addIn><publisherIdentity name="CN=PWCAU\Carl Gabel" issuerKeyHash="44fc7b7d4e21f7f9cc5d017925abeb59f4a78bc2" /><Signature Id="StrongNameSignature" xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" /><Reference URI=""><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" /><Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /><DigestValue>opzHoPo7dXCZr6V377pR04PKyUE=</DigestValue></Reference></SignedInfo><SignatureValue>gNkVsa1lwvv6QxPQoTa/YumEQ2SfUxuqFC6DzavZCsaythQCVyaWJyOvWx23JbaVbufX1gBm/GlaMLCvBLbQH6tsg3jCXSJdOeVrjL5mctOdG8qHC7bR/lmBvxxA4ZEiA3gl+pdygPa8kVpxHtH2piCplNj5UaM2/hfKbnPyAlM=</SignatureValue><KeyInfo Id="StrongNameKeyInfo"><KeyValue><RSAKeyValue><Modulus>xIizsL+NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV++1Lan7AAQsmKWE3Jpff0=</Modulus><Exponent>AQAB</Exponent></RSAKeyValue></KeyValue><msrel:RelData xmlns:msrel="http://schemas.microsoft.com/windows/rel/2005/reldata"><r:license xmlns:r="urn:mpeg:mpeg21:2003:01-REL-R-NS" xmlns:as="http://schemas.microsoft.com/windows/pki/2005/Authenticode"><r:grant><as:ManifestInformation Hash="41c9ca83d351baef77a5af9970753bfaa0c79ca2" Description="" Url=""><as:assemblyIdentity name="ModellingToolbar.dll" version="0.8.2.36" publicKeyToken="62c614bc780ff547" language="neutral" processorArchitecture="msil" type="win32" /></as:ManifestInformation><as:SignedBy /><as:AuthenticodePublisher><as:X509SubjectName>CN=PWCAU\Carl Gabel</as:X509SubjectName></as:AuthenticodePublisher></r:grant><r:issuer><Signature Id="AuthenticodeSignature" xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" /><Reference URI=""><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" /><Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#" /></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /><DigestValue>2xMGBuysB39GSTThonM9Ybf3vw8=</DigestValue></Reference></SignedInfo><SignatureValue>ugsaiD7DK5KgULmz7xQSSQhWVo1kmnxXPAar6XBRiqGs6kkSaiNAcDLIp9e59jRj5fLrPIldPVXVd5PFbYLGCP+wxt9NF3CmG3PUoMt6jAqQrIFczQfAxbQGBLatPgqs0qJyIJHP9IcqzDwc5odQWEkm6L4oD/eO13L3gbLpwME=</SignatureValue><KeyInfo><KeyValue><RSAKeyValue><Modulus>xIizsL+NiItZvTDRLA2vitpQk6l9QBY0VUPMgm0bX0tvxNeskK2oW4b5SjGLVKG8I0g7thcRSWAYpgnjt3KSCYjZ613LNRsyUr3mZtaWt2G0RyvfaJR7X9rlD16ucCcr3sl5VBg29nBAxzhCD3jDGV++1Lan7AAQsmKWE3Jpff0=</Modulus><Exponent>AQAB</Exponent></RSAKeyValue></KeyValue><X509Data><X509Certificate>MIIB2TCCAUKgAwIBAgIQF2tBiDEQk59Hb2/VpAmPszANBgkqhkiG9w0BAQUFADArMSkwJwYDVQQDHiAAUABXAEMAQQBVAFwAQwBhAHIAbAAgAEcAYQBiAGUAbDAeFw0xMzAyMTMyMzM4NTNaFw0xNDAyMTQwNTM4NTNaMCsxKTAnBgNVBAMeIABQAFcAQwBBAFUAXABDAGEAcgBsACAARwBhAGIAZQBsMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEiLOwv42Ii1m9MNEsDa+K2lCTqX1AFjRVQ8yCbRtfS2/E16yQrahbhvlKMYtUobwjSDu2FxFJYBimCeO3cpIJiNnrXcs1GzJSveZm1pa3YbRHK99olHtf2uUPXq5wJyveyXlUGDb2cEDHOEIPeMMZX77UtqfsABCyYpYTcml9/QIDAQABMA0GCSqGSIb3DQEBBQUAA4GBADCjJbyqFb8aoolbfMrWqO7Gad8VG4Wz1hFgRvdSUXfOB4L6qQ5HO+XRgI3cqIeYWWrdJkHEUcFGXGAbhfFB8Tvrfsw7G1y5XHY6gqDEniT19WtIVuhlKFh3RAegE8cHUnUF1SQMJmaA1FVvPwDpb+3U6kphBw0Wv9MaNFnxxGDC</X509Certificate></X509Data></KeyInfo></Signature></r:issuer></r:license></msrel:RelData></KeyInfo></Signature></asmv1:assembly>And I have signed the manifest as described in thewalkthrough. This was working I'm just not sure what I've done to break it. 解决方案 Hi QuinRiva,Thank you for posting in the MSDN Forum.I'll consult my colleague on your issue. You'll be informed if there's any update.Thank you for your patience and understanding.Best regards, 这篇关于Excel Addin - ClickOnce无法找到部署后操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！上岸，阿里云！