Why not just exporting as a .csv file from Excel, then you have a simple text file with a given delimiter ?
And if you don't want to save each file as csv in Excel, you could have a simple extractor on windows with OLE, and working on the exported file on Unix.
| [reply] |
... a simple extractor on windows with OLE
Thanks for the suggestion. This is probably what I'll end up doing.
I was looking for alternatives because the excel files come from any of 25 windows machines and the results are to be uploaded to a single unix-based server (web/DB).
| [reply] |
If you have the time to build something solid, you could imagine having Perl scripts running as services, and on a given signal (timing, remote, user decision...), they export the Excel files to a given text format, and send them via FTP to the Unix box. The script on Unix could monitor the destination directory, and process the files when they arrive (or when the Perl script on Windows notify it via a network connection). With this kind of architecture, your process could be fully automated, and would require no intervention.
| [reply] |
| [reply] |