Home >Database >Mysql Tutorial >从MySQL中导出XLS数据库工具

从MySQL中导出XLS数据库工具

WBOY
WBOYOriginal
2016-06-07 15:13:481224browse

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入 这个脚本是使用Perl生成excel xls文件的工具。依赖一些模块,你可以在linux下使用,产生xls文件。使用方式是命令行+参数。非常方便。 #!/usr/bin/perl #=============================== # mysql to

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入

  

这个脚本是使用Perl生成excel xls文件的工具。依赖一些模块,你可以在linux下使用,产生xls文件。使用方式是命令行+参数。非常方便。

#!/usr/bin/perl

#===============================

# mysql to excel

# lastmodify at 2005-1-5

# copyright by hoowa

#=============================

use strict; #严格语法检测

use DBI; #数据库引擎

use Unicode::Map; #Unicode引擎

#use Spreadsheet::WriteExcel; #Excel报表引擎

use Spreadsheet::WriteExcel::Big; #大文件Excel报表引擎

my $hostname='192.168.1.133';

my $username='user';

my $password='pass';

my $dbname='db';

my $trans_compress=1; #任何非一的数关闭数据库到程序间传输压缩

$|=1;

my @cols=('A:A','B:B','C:C','D:D','E:E','F:F','G:G','H:H','I:I','J:J',

'K:K','L:L','M:M','N:N','O:O','P:P','Q:Q','R:R','S:S','T:T','U:U',

'V:V','W:W','X:X','Y:Y','Z:Z','AA:A','BB:B','CC:C','DD:D','EE:E',

'FF:F','GG:G','HH:H','II:I','JJ:J','KK:K','LL:L','MM:M','NN:N',

'OO:O','PP:P','QQ:Q','RR:R','SS:S','TT:T','UU:U','VV:V','WW:W',

'XX:X','YY:Y','ZZ:Z');

#解析来内容

if ($#ARGV != '1') {

print qq~syntax: my2excel.pl "[where expression]"

~;

exit;

}

$ARGV[1]=~ s/\"//g;

warn qq~

mysql to excel

by hoowa.sun

=====================

sql: $ARGV[1]

~;

my $dbh =

DBI->connect("DBI:mysql:mysql_compression=$trans_compress;

database=$dbname;host=$hostname",$username,$password);

my $sth = $dbh->prepare("$ARGV[1]") || die $dbh->errstr;

my $rows = $sth->execute() or die $sth->errstr;

warn "rows: $rows found.\n";

my @cols_name = @{$sth->{'NAME'}};

if ($#cols_name > $#cols) {

print "table $ARGV[1] fields out of allow!!(max num. > ".($#cols+1).")\n";

exit;

}

[1] [2] 

从MySQL中导出XLS数据库工具

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:记录2Next article:Oracle数据库并行处理技术详解