Re^2: Alternative methods for parsing excel

... 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).

Comment on Re^2: Alternative methods for parsing excel

Replies are listed 'Best First'.
Re^3: Alternative methods for parsing excel by jeepj (Scribe) on Apr 24, 2008 at 12:44 UTC
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]

Replies are listed 'Best First'.

Re^3: Alternative methods for parsing excel
by jeepj (Scribe) on Apr 24, 2008 at 12:44 UTC

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]