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

Do you understand why it solves the issue?


holli

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

Replies are listed 'Best First'.
Re^5: Perl 2 Excel
by newperlbie (Acolyte) on Aug 22, 2018 at 09:53 UTC
    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.