How to Setup a Excel Import Server on Windows
Download Windows Service Wrapper
Download the latest version of https://github.com/winsw/winsw, use the WinSW.NETCore31.x64.exe
Set up a service
1. Rename the WinSW.NETCore31.x64.exe to excelimport.exe.
2. Create an excelimport.xmlfile with the following content:
<service>

<id>excelimport</id>

<name>Word Export</name>

<description>This service runs Excel Import application.</description>

<executable>java</executable>

<arguments>-Xms6G -Xmx6G -jar "%BASE%\cb-excel-import-<VERSION>.jar" --server.port=443 --server.ssl.key-store-type=PKCS12 --server.ssl.key-store=%BASE%\keystore.p12 --server.ssl.key-store-password=<PASSWORD> --server.ssl.key-alias=<ALIAS> --security.require-ssl=true</arguments>

<log mode="roll"></log>

<logpath>%BASE%\logs</logpath>

<onfailure action="restart" />

</service>
3. Create a keystore.p12 file with certificates.
4. Open the 443 port on the Windows Firewall.
5. Open the 443 port on the Security Group on AWS.
6. Install service by running: excelimport.exe install.
7. Start service by running: excelimport.exe start.
8. Check the status by running: excelimport.exe status.
9. Check the healthcheck URL: https://localhost/actuator/health.
Was this helpful?