The server is a Windows server2008 64-bit system that requires Microsoft.Office.Interop components in your project, including Excel, Word, PPT, and so on.
Key one:
Steps
1. In Start, run, enter Dcomcnfg.exe to start the Component Services
2. Double-click "Computer", "Component Services", "My Computer", "DCOM Configuration"
3. In the DCOM configuration, locate the Microsoft Excel application (including Word and PowerPoint, of course), right-click on it, and then tap properties to pop up the Microsoft Excel Application Properties dialog box
4. Click on the "Logo" tab and select "Interactive User"
5. Click on the "Security" tab, click "Customize" on "Launch and activation Rights", then click on the corresponding "edit" button to add a "NETWORK SERVICE" user in the "Security" dialog box (note to select the computer name), and give it "local launch" and "Local activation" Permissions
6. Remain the "Security" tab, click "Customize" on "Access", then click "Edit" and add a "NETWORK SERVICE" user to the "Security" dialog box that appears, then give "Local access" permission.
And when on a 64-bit version of a machine, because after you open DCOMCNFG, you can't find the item "Microsoft Excel application (Word and PowerPoint, of course) ", the following is the way to resolve
1. Run: mmc-32
2. Open "File"-"Add or remove Snap-in"-Select Component Services-click Add-OK.
3. Microsoft Excel application can be found in the DCOM component (
< Span style= "color: #444444; line-height:25px; Font-family:verdana,arial,helvetica,sans-serif; font-size:14px; " >< Span style= "color: #444444;" >