Hi -
Good Morning.
Please help me with the below
Currently we are in windows. Now moving to AWS cloud and upgrading the domino server version to 8.5 from 6.5 and from Windows to Linux-RedHat. However notes client be on windows workstations.
The problem is with the Excel exports.
OLE does not work on Linux. The below are my questions
-
How can I make my excel export agents to work on Linux.
-
If we run the export excel agent on the notes client on windows workstation by opening the database on the server which is on linux…will it work as is with out any changes.
-
We have an option of creating one domino server on windows workstation as well however we are not hosting any apps on that…is there any way that I can connect to that server to run the excel export agent from the other server.
Any help is much appreciated please.
Regards!
Sandya
Subject: Export to Excel in Linux
Thank You so much Stan… Info you provided is really helpful.
Subject: Export to Excel in Linux
If the agents are running under user control (that is, the user clicks something to run the export agent) and those XLS files are created on the users’ workstations, then what matters is the workstation OS (and a local Excel installation), not the server OS. As long as the users are on Windows, it doesn’t matter what OS the server is running.
If the agent(s) is/are running on schedule and, say, attaching the resulting report to a Notes document, then you’ll have to find a work-around. That may include hosting a replica of the app on a Windows-hosted Notes server (which does not need to have user access – the Windows server can be accessible only to other servers and to admins) that has a local Excel installation, or you can use, say OpenOffice or LibreOffice using the Java API and save as an Excel file, or if you are running a version of Excel that can read XLSX files, you can write the files as text without going through OLE, Java or any other API (it’s just XML – complicated, ugly XML, but XML nonetheless).