Problems with Spreadsheet::Read

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

Dear Monks,

I make desktop databases at work and the most time consuming part of each project is editing the spreadsheets, givin to my me by accountants, that need to be added to the database.

I am a beginner with Perl. However, I want to write some scripts that can format the Spreadsheets for me, but I am having problems installing Spreadsheet::Read and Spreadsheet::ParceExcel.

I have done lots of research and understand that you must have ParceExcel to use Read, but how do I install these so that they can work together.

I have reviewed the warnings givin during the Makefile "Installation", but my efforts are failing me.

New spreadsheets will be coming to me at the end of the month, so please help me.

--dataMunger

Hackers aren't Crackers

Comment on Problems with Spreadsheet::Read

Replies are listed 'Best First'.
Re: Problems with Spreadsheet::Read by runrig (Abbot) on Mar 30, 2007 at 16:11 UTC
Which module are you having trouble installing? What problems are you having? Is it on Windows w/ActiveState perl (if so, you should be using ppm to install most modules, not make)? If you are only reading Excel spreadsheets, you probably don't need Spreadsheet::Read (unless you like the API)...I've found Spreadsheet::ParseExcel::Simple to be adequate in most cases...though it does not try to read the formatting of the spreadsheet. Update: I just noticed that twice you have misspelled "ParseExcel". That's not why you are having trouble installing it, is it?	[reply]
Re: Problems with Spreadsheet::Read by pileofrogs (Priest) on Mar 30, 2007 at 16:54 UTC
Another option would be to save the spreadsheat as Comma Separated Values (CSV). This is one of the save-as formats that Excell or OpenOffice or whatever should offer you. Then parse with perl. --Pileofrogs	[reply]