none
Deployment of Excel 2007 Custom Excel Workbook using VS 2010 RRS feed

  • Question

  • I am attempting to deploy an Excel workbook application, with a custom ribbon tab and action pane, written in VS 2010.  I am using a setup and deployment project in my solution, *not* Click Once deployment via the publish option of the project properties. 

    I manually added the .vsto file to the application folder of the setup and deployment project and still I see this exception. 

    Here is more information about the exception:

    System.Deployment.Application.DeploymentDownloadException: Downloading file:///C:/Program Files (x86)/IIS/IIS Reporting Excel Interop/ExcelWorkbookEx1.dll.manifest did not succeed. ---> System.Net.WebException: Could not find file 'C:\Program Files (x86)\IIS\IIS Reporting Excel Interop\ExcelWorkbookEx1.dll.manifest'. ---> System.Net.WebException: Could not find file 'C:\Program Files (x86)\IIS\IIS Reporting Excel Interop\ExcelWorkbookEx1.dll.manifest'. ---> System.IO.FileNotFoundException: Could not find file 'C:\Program Files (x86)\IIS\IIS Reporting Excel Interop\ExcelWorkbookEx1.dll.manifest'.

    Here are the files in the installation folder:

    AssignedPointsHostedWPFUserControl.dll
    DefaultWorkbook.xlsx
    ExcelWorkbookEx1.dll
    ExcelWorkbookEx1.dll.config
    ExcelWorkbookEx1.vsto
    Microsoft.Office.Tools.Common.dll
    Microsoft.Office.Tools.Common.v4.0.Utilities.dll
    Microsoft.Office.Tools.dll
    Microsoft.Office.Tools.Excel.dll
    Microsoft.Office.Tools.Excel.v4.0.Utilities.dll
    Microsoft.Office.Tools.v4.0.Framework.dll
    Microsoft.VisualStudio.Tools.Applications.Runtime.dll
                  12 File(s)        947,979 bytes

    Thanks for any input, or thoughtful response!

    Dan


    -DK
    Thursday, June 17, 2010 3:44 PM

Answers

  • I was able to solve this problem by including the manifest files for the dll and vsto prerequisites, and the .xml files that correspond to the xxx.Utilities.dll files.  Here is the new folder listing for the working application installation folder.  As you can see, I saved the custom workbook under a different name, and verified that I could open it and see the new data I had previously added.

    AssignedPointsHostedWPFUserControl.dll
    DefaultWorkbook.xlsx
    DefaultWorkbook2.xlsx
    ExcelWorkbookEx1.dll
    ExcelWorkbookEx1.dll.config
    ExcelWorkbookEx1.dll.manifest
    ExcelWorkbookEx1.vsto
    Microsoft.Office.Tools.Common.dll
    Microsoft.Office.Tools.Common.v4.0.Utilities.dll
    Microsoft.Office.Tools.Common.v4.0.Utilities.xml
    Microsoft.Office.Tools.dll
    Microsoft.Office.Tools.Excel.dll
    Microsoft.Office.Tools.Excel.v4.0.Utilities.dll
    Microsoft.Office.Tools.Excel.v4.0.Utilities.xml
    Microsoft.Office.Tools.v4.0.Framework.dll
    Microsoft.VisualStudio.Tools.Applications.Runtime.dll
                  16 File(s)      1,718,792 bytes

    Thanks, and I hope this helps some people.

    Dan


    -DK
    • Marked as answer by eryang Tuesday, June 22, 2010 7:10 AM
    Thursday, June 17, 2010 6:06 PM

All replies

  • I was able to solve this problem by including the manifest files for the dll and vsto prerequisites, and the .xml files that correspond to the xxx.Utilities.dll files.  Here is the new folder listing for the working application installation folder.  As you can see, I saved the custom workbook under a different name, and verified that I could open it and see the new data I had previously added.

    AssignedPointsHostedWPFUserControl.dll
    DefaultWorkbook.xlsx
    DefaultWorkbook2.xlsx
    ExcelWorkbookEx1.dll
    ExcelWorkbookEx1.dll.config
    ExcelWorkbookEx1.dll.manifest
    ExcelWorkbookEx1.vsto
    Microsoft.Office.Tools.Common.dll
    Microsoft.Office.Tools.Common.v4.0.Utilities.dll
    Microsoft.Office.Tools.Common.v4.0.Utilities.xml
    Microsoft.Office.Tools.dll
    Microsoft.Office.Tools.Excel.dll
    Microsoft.Office.Tools.Excel.v4.0.Utilities.dll
    Microsoft.Office.Tools.Excel.v4.0.Utilities.xml
    Microsoft.Office.Tools.v4.0.Framework.dll
    Microsoft.VisualStudio.Tools.Applications.Runtime.dll
                  16 File(s)      1,718,792 bytes

    Thanks, and I hope this helps some people.

    Dan


    -DK
    • Marked as answer by eryang Tuesday, June 22, 2010 7:10 AM
    Thursday, June 17, 2010 6:06 PM
  • Correction; upon second look the .vsto file doesn't seem to have or require a manifest, just the ExcelWorkbookEx1.dll requires the manifest.  In fact, the .vsto file requires registry entries in HKCU to function correctly. 
    -DK
    Thursday, June 17, 2010 6:09 PM
  •  

    Hi Dan,

     

    Glad to see that you got it resolved, anyway, this forum is dedicate for CLR questions, you may consider posting VSTO related issue at Visual Studio Tools for Office forum for quicker and better support.


    Sincerely,
    Eric
    MSDN Subscriber Support in Forum
    If you have any feedback of our support, please contact msdnmg@microsoft.com.
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Friday, June 18, 2010 5:38 AM