Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

comparing two excel files

by sir_com (Acolyte)
on Aug 21, 2009 at 13:50 UTC ( #790365=perlquestion: print w/replies, xml ) Need Help??
sir_com has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks,

I have two excel files both contains same types of data, means one has data pulled a month back and another content newly pulled data.

I want to compare this two excel files to see which fields have been updated in them.

Also, to mention this two excel files has morethan one worksheets. Can someone please help me with example sample code on how to achive this.

Thanks, sir_com

Replies are listed 'Best First'.
Re: comparing two excel files
by tbone1 (Monsignor) on Aug 21, 2009 at 14:08 UTC
    Have you looked at Spreadsheet::DataFromExcel? That seems to be a good start.

    tbone1, YAPS (Yet Another Perl Schlub)
    And remember, if he succeeds, so what.
    - Chick McGee

      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";
        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 Also, if I use if ( $data !~ m/\Q$search\E/ ) I dont get any error but I dont get any result too. Please help.
Re: comparing two excel files
by tokpela (Chaplain) on Aug 21, 2009 at 16:12 UTC

    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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://790365]
Approved by lostjimmy
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2018-01-17 05:45 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (196 votes). Check out past polls.