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

I have a perl script which uses Excel-Writer-XLSX 0.88. I got a problem when i want to use conditional_formatting function. The message that appers is: "Can't locate object method 'conditional_formatting' via package 'Excel::Writer::XLSX::Worksheet'. That is the code that i use: $worksheet1->conditional_formatting(0, 0, $n-1, 7, { type => 'formula', criteria => '=$E1=$G1', format => $format1 } ); Need help :)

Replies are listed 'Best First'.
Re: conditional_formatting problem
by Corion (Patriarch) on Apr 08, 2016 at 06:45 UTC
    Can't locate object method 'conditional_formatting' via package 'Excel +::Writer::XLSL::Worksheet'

    Excel::Writer::XLSL::Worksheet is not Excel::Writer::XLSX::Worksheet. Please show a complete, self-contained example script that replicates your problem.

      It is XLSX , sorry.

        The next step for you is to reduce your failing program to a short progam (20 lines) that still exhibits the problem. Then post this program together with the exact error message as copied from your terminal. This allows us to replicate your problem and maybe suggest a solution or a workaround.

Re: conditional_formatting problem
by Anonymous Monk on Apr 08, 2016 at 06:43 UTC
      I have the 0.88 version.
        What is the version output when you run this program from the Excel::Writer::XLSX examples.
Re: conditional_formatting problem
by Mask (Pilgrim) on Apr 11, 2016 at 16:33 UTC
    Can it be that you have more than one version of Excel-Writer-XLSX installed and the path points to the old version? What does this commad says? perl -MExcel::Writer::XLSX -e 'print $Excel::Writer::XLSX::VERSION'
      It says: 0.15
        How can i change the path?