Creating an Excel OLE Automation Object using CreateObject("EXCEL.APPLICATION") while running on a server then encountered an issue.
Microsoft responded:
First, Office desktop applications (including Excel, Word, and PowerPoint) do not support non-interactive execution or Automation calls on a server or in a background service.
Office is designed as a desktop application for user interaction; when running in an unattended or non-interactive environment, Office may exhibit unpredictable behavior or deadlock (for example, displaying a dialog box awaiting user input when encountering an error, causing the application to hang in the background).
Because Microsoft does not support server-side Automation of Office desktop applications, we recommend gradually migrating to a supported solution:
Use the Open XML SDK to directly generate .xlsx files (no Excel installation required). This approach not only avoids the compatibility and stability issues associated with server-side Excel calls but also better complies with Microsoft's support policies.
For more information, please refer to the official document: Server-Side Office Automation Considerations - Microsoft Support.
When Domino support to generate .xlsx files using the OpenXML SDK? Thanks!