The excel files in on Linux cluster and we are using Win7. Our process is run a program on linux cluster multiple times.
The process is a loop of 2 simple steps: Win7: Open excel file, run macro to generate data Linux: Run program, update data back to the excel file Win7: Open excel file, run macro to generate data Linux: Run program, update data back to the excel file and so on....
Right now, it is done manually. Now, we want to do it automatically. I think of 3 solutions:
(1) Make a new software that has all the needed function (too expensive & waste since there are huge number of scripts and macros developed) (2) Make a tool that can call excel macro from Linux command (through network?? It seems like complicating the problem but I'm not sure....) (3) Make a new tool that read data from excel files and generate the input for the program (For me, it's OK)
So, (2) and (3) are 2 possible solutions. If your suggestion is (2), is there any available tool for this task? Or any programming suggestion for this.
If(3), what language you suggest (Python, Java, .NET, other?), why?(library???)
Any other suggestions?
Thanks.