NOTE: This page has been translated automatically from Russian to English. Original page.


Configuring components DCOM "Excel.Application" on a 64-bit application server 1C

Setting Description 64-bit server 1C applications allow you to create and use COMObekt "Excel.Application" on a server 1C.
This will help handle large excel files on the server, including through background jobs.
All these steps were born based on reading thousands of forums and was tested first on razrabotcheskom server, then to the battle.
Therefore, I decided to post it here, for sure will save you at least 1 day of life.
  1. Go to 1C application server under a local administrator
  2. Run DCOMCNFG (configuration console "Component Services")
    1. Open branch Console Root -> Component Services -> Computers -> My computer -> DCOM Config
    2. We are looking for "Microsoft Excel Application"
    3. If found, then we proceed to step 4 (Setting up the properties of DCOM component "Microsoft Excel Application")
    4. Close the "Component Services"
  3. Setting up the registry
    1. Run REGEDIT
    2. Open branch Computer \ HKEY_CLASSES_ROOT \ AppID \ EXCEL.EXE, if it does not exist, create it
    3. Create it a string parameter AppID = {00020812-0000-0000-C000-000000000046}
    4. Execute the command "mmc comexp.msc / 32", which does the same as the DCOMCONFIG, but allows you to see the 32-bit components.
    5. Thereafter Component Services should appear "Microsoft Excel Application"
  4. Custom properties DCOM component "Microsoft Excel Application"
    1. "Security" tab
      1. "Launch and Activation Permissions" - Customize - Edit
        1. Add the user that starts the server agent 1C
        2. Assign it only the following rights (allow):
          1. Local Launch
          2. Local Activation
      2. "Access Permissions" - Customize - Edit
        1. Add the user that starts the server agent 1C
        2. We assign only the following rights (allow):
          1. Local Access
    2. "Identity" tab
      1. It must be chosen "The launching user"
  5. System folders
    1. The folder "C: \ Windows \ SysWOW64 \ config \ systemprofile \ Desktop \"
      1. Check for the folder, if there is no -That create.
      2. Go to the properties of the folder.
      3. Security tab
      4. Adding, if not, the user under which the agent runs the server 1C
      5. Adding the right "Read" and "Write"
    2. The folder "C: \ Windows \ System32 \ config \ systemprofile \ Desktop \"
      1. Check for the folder, if there is no -That create.
      2. Go to the properties of the folder.
      3. Security tab
      4. Adding, if not, the user under which the agent runs the server 1C
      5. Adding the right "Read" and "Write"

PS: at the request of the yukon add the following disclaimer:

Questions Office https://support.microsoft.com/kb/257757 server automation

Microsoft Corp. today does not recommend or support the programs of the automation of the Microsoft Office suite with automated, non-interactive client application or component (including ASP, DCOM, and NT Services), because when run in this environment program of Office may become unstable or hang .

1C:Enterprise Developer's Community