in reply to Re^2: Perl 2 Excel
in thread Perl 2 Excel

yes,thanks again,moving the format out of the loop solved the issue!

Replies are listed 'Best First'.
Re^4: Perl 2 Excel
by holli (Abbot) on Aug 21, 2018 at 15:04 UTC
    Do you understand why it solves the issue?


    holli

    You can lead your users to water, but alas, you cannot drown them.
      excel has this limitation that it cant support that many formats if I am trying to generate one each time in the loop? correct?
        That is the reason your output is wrong. It is not why your code is wrong. Or in other words, even if Excel supported unlimited number of formats, the code would still be wrong.

        See, there is nothing wrong with copy and pasting code snippets from the docs or some example on the internet. But you have to understand it too :)
        open my $tf, "output.txt" or die "Cannot open file"; while(my $line = <$tf>) { if ( $line =~ /.*versions are SAME.*/) { # ... } }
        My hunch is, this is your code and the rest is copy and pasted.


        holli

        You can lead your users to water, but alas, you cannot drown them.