Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^2: Alternative methods for parsing excel

by igelkott (Priest)
on Apr 23, 2008 at 17:24 UTC ( [id://682427]=note: print w/replies, xml ) Need Help??


in reply to Re: Alternative methods for parsing excel
in thread 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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://682427]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (6)
As of 2024-04-25 14:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found