Automatic execution of Excel macros under Linux
A piece of software I'm working on uses an Excel sheet to store user error messages and their translations. We run a macro that generates a set of internationalized text files and associated header files, which are then copied into our source control system (the spreadsheet is also in the Version Control section) and used as part of our build.
I would like to automate our build better by pulling in the xls, running a macro, and then copying the files to the correct location before compiling our source. Our prefab boxes are Linux based.
I've tried uploading XLS to OpenOffice.org and running a macro, but it doesn't work.
Is there any option, or am I SOL until we convince stakeholders that we need to use a non-Excel format to store this data?
a source to share
It is not the format that you use to store the data , which creates problems. This is the format you use to store your logic . Data stored in Excel is available on Linux. There is no logic built into Excel macros.
How complex are these macros? You can reproduce them in a different form (Perl?). In this case, you can programmatically extract data from the .XLS and the logic can run wherever there is a Perl engine.
a source to share