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

Re^2: SQL vs Perl table comparing

by roboticus (Canon)
on Jul 11, 2013 at 11:46 UTC ( #1043698=note: print w/ replies, xml ) Need Help??


in reply to Re: SQL vs Perl table comparing
in thread SQL vs Perl table comparing

Something like this should do:

use DBI; use Spreadsheet::WriteExcel; my $DB=DBI::connect( ... connection args for oracle DB ... ); my $ar = $DB->selectall_arrayref('select * from table'); my $XLWB = Spreadsheet::WriteExcel->new('table.xls'); my $XLWS = $XLWB->add_worksheet('table'); my $row = 0; $XLWS->write_row($row,0,$_) for @$ar;

...roboticus

When your only tool is a hammer, all problems look like your thumb.


Comment on Re^2: SQL vs Perl table comparing
Download Code
Re^3: SQL vs Perl table comparing
by runrig (Abbot) on Jul 11, 2013 at 16:41 UTC
    Spreadsheet::WriteExcel is superceeded by Excel::Writer::XLSX.

    But I think the poster wants to avoid putting all the data in a spreadsheet where they currently run macros to compare data 8-) ... and wants you to write a generic table compare utility

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2014-04-20 03:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (485 votes), past polls