Welcome 微信登录

首页 / 数据库 / MySQL / mysql 导出数据库到XLS

 这个脚本是使用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");
  • 1
  • 2
  • 下一页
【内容导航】
第1页:mysql 导出数据库到XLS第2页:mysql 导出数据库到XLS
Linux下MySQL的安装同一台机运行多个Mysql的设置相关资讯      本文评论 查看全部评论 (0)
表情: 姓名: 字数