Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^2: comparing two excel files

by sir_com (Acolyte)
on Aug 24, 2009 at 16:18 UTC ( #790855=note: print w/ replies, xml ) Need Help??


in reply to Re: comparing two excel files
in thread comparing two excel files

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.


Comment on Re^2: comparing two excel files
Re^3: comparing two excel files
by sir_com (Acolyte) on Aug 24, 2009 at 16:44 UTC
    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";
    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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://790855]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2015-07-07 12:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls