read an excel spreadsheet using references

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

I'm a perl beginner and I was wondering if anyone can help me with this problem. I read an excel spreadsheet like this: sheet.xls

name   Dallas   Miami   
Tom      1.00    1.00    
Dan      2.50    2.50    
Allen    5.50    2.50
[download]

Then I use references to sort the table by name and add a Total column and row to the screen output so it would look like this when I print it to the screen:

name   Dallas   Miami   Total
Allen    5.50    2.50    8.00
Dan      2.50    2.50    5.00
Tom      1.00    1.00    2.00
Total    9.00    6.00   15.00
[download]

Thanks for the help.

2005-03-11 Janitored by Arunbear - added code tags, as per Monastery guidelines

Comment on read an excel spreadsheet using references Select or Download Code

Replies are listed 'Best First'.
Re: read an excel spreadsheet using references by hardburn (Abbot) on Mar 10, 2005 at 22:30 UTC
So what do you need help with? You can't expect people to write the code for you. If you need help with a specific question, this is the place to ask. But we expect to see some effort first. "There is no shame in being self-taught, only in not trying to learn in the first place." -- Atrus, Myst: The Book of D'ni.	[reply]
Re: read an excel spreadsheet using references by ikegami (Patriarch) on Mar 10, 2005 at 22:41 UTC
I don't see a question in there. What's the problem?	[reply]