Microsoft Office Excel cannot access files or com

Microsoft Office Excel cannot access files or com, Microsoft Office Excel cannot access files "*. xls ". Possible causes: 1. The file name or path does not exist. 2 files are being used by other programs. 3. The workbook you want to save has the same name as the one currently opened.

An inexplicable error occurs. debugging on the local machine is normal, but once deployed on the server, it cannot be accessed ......

I checked some information and found that everyone encountered this problem.

Solution

In c: \ windows \ system32 \ config \ systemprofile and C: \ windows \ syswow64 \ config \ systemprofile create a directory named desktop to solve the problem that cannot be accessed by COM components. Solution: 1. 1 ). add the simulation in webconfig and add the Administrator permission. <identity impersonate = "true" username = "System Administrator" Password = "system administrator password"/> 2 ). in this way, you can start the application process, operate on Excel, and create and export Excel files. However, you still cannot open Excel files on the server.
2. in the component service, docm sets the properties of Microsoft Excel application. Because the operation is performed on a 64-bit system, docom does not exist in the component service by default, because Microsoft Excel application is a 32 DCOM configuration, you can solve it as follows (refer to Step 3. 1 ). start --> Run --> cmd 2) Enter comexp at the command prompt. MSC-32, open the 32 console 3 ). in the File menu, add or delete a management unit --> component service 4 ). in "DCOM configuration", find "Microsoft Excel application", right-click it, and then click "properties". The "Microsoft Excel application properties" dialog box is displayed. 5 ). click the "ID" tab and select "Interactive User" 6 ). click the "Security" tab, click "Custom" on "Start and activate Permissions", and then click the corresponding "edit" button, in the pop-up "security" dialog box, add a "Network Service" user (Be sure to select the computer name ), and grant it the "local startup" and "Local activation" permissions 7 ). still "security" label, click "Custom" on "Access Permissions", and then click "edit ", in the pop-up "security" dialog box, add a "Network Service" user and grant "local access" permission.

4. Restart IIS and pass the test.

For iis7 + win2008 R2, modify the preceding attributes in the Excel application of the component service.

Microsoft Office Excel cannot access files or com