Re: Alternative methods for parsing excel

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.

Comment on Re: Alternative methods for parsing excel

Replies are listed 'Best First'.
Re^2: Alternative methods for parsing excel by igelkott (Priest) on Apr 23, 2008 at 17:24 UTC
... 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]
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]


more useful options
	PerlMonks