Cakephp Excel cannot be opened

Asked 2 years ago, Updated 2 years ago, 85 views

I am outputting Excel forms on the CakePHP system.
I'm having trouble opening the Excel file from which to output the business form.

The business form output itself is a shell script for PHP.
Run the command to create a business form file in the background.
Direct command creates a file, but PHP creates a file.

$hoge->Workbooks->Open($filepath)

Timeout occurs when you run the .

The server I'm running is Windows 7, but
If you check the process with a timeout,
When the Excel process remains running and you exit the process,

Error Code: -2147023170

Error Message:Error [0x800706be] Remote procedure call failed.

appears.

Previously, if the Excel file could not be opened for another reason and the business form could not be output,
By creating a "Desktop" folder on C:\Windows\System32\config\systemprofile\
The output of the business form was completed without any problems, but

This situation happened while I was making another correction.
(The situation did not change when I returned another fix.)

To be honest, I'm at a standstill.

If anyone knows anything about the cause of the situation and how to deal with it,
May I speak to you?

Thank you for your cooperation.

php cakephp excel com

2022-09-30 19:10

1 Answers

I don't think you're expecting a reply because I'm only doing multi-posting...

Office is designed to operate interactive and not run unattended.If it doesn't work, please give up.Also, be aware that there is a possibility of a license violation if a third party becomes accessible on the web system.

About Office Server Side Automation

All current versions of Microsoft Office are designed, tested, and configured to run as end-user products on client workstations.These products are intended for interactive desktop and user profiles and do not provide a level of re-entry or security to meet the needs of server-side components designed to run unattended.

Microsoft currently does not recommend or support automation of Microsoft Office applications from unattended, non-interactive client applications or components (including ASP, ASP.NET, DCOM, and NT services).This is because running Office in such an environment can cause unstable operation or deadlock in Office.

About the dangers of Office Server Side Automation

Microsoft does not support Office server-side automation.

Automation using Office client applications installed on the server without installing Office products on the client side, centralizing client-side operations, or providing end users with a similar solution, is also a license violation for Microsoft products.
Also, from a technical standpoint, these implementations are dangerous and should not be implemented.


2022-09-30 19:10

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.