Connect to windows server from node js

I'm not very experienced in programming and have a problem that I'm finding hard do solve.

I have a web app that is on a ubuntu server, that is running on node js. That web app creates an excel file on the back-end that is to be read by another excel file and execute a vba that gives as results in a software that only runs on windows.

I tried the software on a windows server and it seems to run, so no problems there.

My question is: how do I make my web app excel file be stored in the windows server and how do I call the files on that server to run from node js?

Can anyone please share some resources on where I can explore this subject please?

Thanks in advance,

Ana

Solution 1:

The following is what I advised the OP to do in the comments, only longer and with more explanation.

• First, install NodeJS on your Windows server. You can do it by either installing it from the official Downloads page from NodeJS, or use a version manager such as nvm, with a Microsoft tutorial on how to do it that way. This step is up to you.
• Host you back-end part (the one that creates the excel part) on the Windows server. That way, the file will be stored in the same filesystem the "software that runs only on Windows" is on.
• The problem now is determining if there is any way to run the "software" via command line. Since I don't know the software name, I can't look that up but if it can, you'll have to check child processes via NodeJS.
• Now, if this software has no way to be run via command line, and if they didn't publish any sort of programming interface (what is called API in the real definition of the term), chances are that you will not be able to achieve what you want to.

If you want me to clarify or explain more on some points, please let me know in the comments so I can edit my answer.