Hi Monk, I have almost got this and comaring two files but the excel files has many data which are having special characters or keyword mixed and due to whcih script is failing in that point. Also, I can't escape them with '', cause then variable will not be substituted. Please help me.

Below is the code I am using

for my $row ( $row_min .. $row_max ) {
            for my $col ( $col_min .. $col_max ) {

                my $cell = $sheettwo->get_cell( $row, $col );
        my $cell1 = $sheetone->get_cell( $row, $col );
                next unless $cell and $cell1;

        my $data = $cell->value();
        my $search = $cell1->value();

                 if ( $data !~ m/$search/ ) {
             print FILE "Row, Col    = ($row, $col)\n";
[download]

I get few results and then script fails with error as below Unmatched ( in regex; marked by <-- HERE in m/TECHNOLOGY Team ( <-- HERE SPORTS Team/ at excelcomp.pl Also, if I use if ( $data !~ m/\Q$search\E/ ) I dont get any error but I dont get any result too. Please help.

I may be wrong but it sounds like you are just looking for a tool rather than really wanting to write Perl code to do this.

Below is a non-Perl tool for comparing Excel files.

Excel Diff