Using Win32::OLE to gather data from M$ Excel Spreadsheets for Mother-In

jerrygarciuh has asked for the wisdom of the Perl Monks concerning the following question:

My mother-in-law, no I'm not joking, had a ColdFusion server app reading Excel spreadsheet data of 64 parishes' info on kids (57 fields each). They moved their site and only have the spreadsheet data now and the format they want it displayed in. My question to my brethren is how difficult is this project of writing an app to display info by parish. I am, as you know, a neophyte. I have read that Win32::OLE will help me interpret this but I have next to know experience with reading flat file data into perl. In the relative scheme of things, how hard is this task? I realize this may be far too little data for you to advise me but any response will be appreciated!
TIA
jg
_____________________________________________________
If it gets a little bit out of hand sometimes, don't let it fool you into thinkin' you don't care.TvZ

Comment on Using Win32::OLE to gather data from M$ Excel Spreadsheets for Mother-In_Law Download Code

Replies are listed 'Best First'.
(jeffa) Re: Using Win32::OLE to gather data from M$ Excel Spreadsheets for Mother-In_Law by jeffa (Bishop) on Dec 16, 2001 at 22:10 UTC
I would look into Spreadsheet::WriteExcel and Spreadsheet::ParseExcel. Read the docs, it's really very easy. Now, personally, I would import the spreadsheets to a database, but that's just me. ;) jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR F--F--F--F--F--F--F--F-- (the triplet paradiddle)	[reply]
Re: Using Win32::OLE to gather data from M$ Excel Spreadsheets for Mother-In_Law by cacharbe (Curate) on Dec 17, 2001 at 06:25 UTC
Everything you ever wanted to know about manipulating Excel objects can be found on my scratch pad. And I totally agree that you should read through it once, and blow it all into a database. Much faster interface, easier to manipulate data, etc. C-. *Update:* No longer on my scratch pad, now found in a tutorial found here	[reply]
Re: Using Win32::OLE to gather data from M$ Excel Spreadsheets for Mother-In_Law by hopes (Friar) on Dec 16, 2001 at 23:37 UTC
I agree with jeffa, I would pass it to a database. There are a lot of advantages... I don't like Access, because manages very bad the concurrence accesses. I'd try with MySQL (free) or SQLServer (very, very, very expensive) Hopes `$_=$,=q,\,@4O,,s,^$,$\,,s,s,^,b9,s, $_^=q,$\^-]!,,print` [download]	[reply] [d/l]