i want to extract data from an excel spreadsheet into a hash of hashes
so row 1
@headings= [col0,col1,col2 etc ]
then i can loop through the rest ,extract the data a row at a time
then i can
for each row @columns = [col0,col1,col2 etc ]
@[EMAIL PROTECTED]@columns;
and then $alldata{rownumber}=\%hash;
(i think this is it !)
using the example in e Spreadsheet::ParseExcel gives me an output of
the data and cell references but i cant see how toget it a row at a
time toput it into a hash
looking at the excel object with Data::Dumper there is something
called 'PkgStr' that contains what i want - buit i dont know enough
about it to go there.
is there a way of extracting the data from within the loop into an
array ?
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
