Zaloguj
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Running a VSTO Excel workbook in HPC

问题 Running a VSTO Excel workbook in HPC

  • 28 lutego 2012 23:07
     
     
    Zarejestruj się, aby zagłosować
    0

    I have a Excel workbook VSTO application. I want to run this workbook in the HPC cluster. When I submit to HPC, the macro in the workbook is being called but call to .NET object within the macro is not happening. I would like to know if this is a supported scenario or not.

    Thanks


     

Wszystkie odpowiedzi

  • 29 lutego 2012 11:01
     
     
    Zarejestruj się, aby zagłosować
    0
    We haven't tested this pattern but it should work. Did you install the VSTO on all compute nodes?
     
  • 29 lutego 2012 20:24
     
     
    Zarejestruj się, aby zagłosować
    0

    I am testing this scenario with just one specific node (using a job template).

    Yes, it has VSTO installed properly. I am able to run the workbook macro manually in that node successfully.

    When the request goes from HPC the macro gets called but the .net object method calls are not going thru.

    When I load the excel workbook manually in that machine, i see that excel process is consuming 180MB but when the process gets activated from HPC, the memory stops at 110 MB.

    Since excel is running in the background, I am not able to debug the probelm. please advise.

    Thanks

     
  • 3 marca 2012 10:58
     
     
    Zarejestruj się, aby zagłosować
    0

    how do I debug this problem? Is there are way to bring the background running excel to front so that I can see what is happening? please advise.

     
  • 5 marca 2012 07:19
     
     
    Zarejestruj się, aby zagłosować
    0
    Hi, to debug this problem, I think you could try using HPC_ATTACHTOSESSION=true and watching what is happening on the compute nodes. For more details, please see http://technet.microsoft.com/en-us/library/gg315415%28WS.10%29.aspx
     
  • 12 marca 2012 15:35
     
     
    Zarejestruj się, aby zagłosować
    0

    Hi, setting this environment variable HPC_ATTACHTOSESSION=true helped me to see the excel application in the compute node.

    I see that macro is called even before loading VSTO customizations. Can you please let me know how to prevent this?

    I want the macro to be called only after the excel workbook is fully loaded with VSTO customization.

    Thanks