more useful options | |
PerlMonks |
Re: read excel data and write into *.txt fileby mscharrer (Hermit) |
on Sep 18, 2008 at 09:56 UTC ( [id://712219]=note: print w/replies, xml ) | Need Help?? |
Reposting old questions wont bring you much on perlmonks, but I try to help you anyway.
First of all you should convert your code using a loop, like below. Then it gets tidy enough to make changes fast and avoid a lot of minor errors which are likely in repetitive code. Should your output be XML ("output.xml")? Because it isn't yet. Have a look on XML::Simple's function xmlout() for that.
PS: Could you use <readmore> tags for code of this length in the future, please. Update: Are you aware that your code overwrites the output file for every row ($i iteration) and sheet? This could be one of you main problems.
In Section
Seekers of Perl Wisdom
|
|