万能的perl ，在Win32平台，输出Excel表到打印机。

ggglw

万能的perl ，在Win32平台，输出Excel表到打印机。办不到吗？
我Google了无数次，本版也只有两个帖子，而且，未见应答，
在cpan上找到PrintExcel模块http://search.cpan.org/~havi/Spr ... /PrintExcelSheet.pm，但不能安装，
难道没有其他方法？挑战perl高手！

ggglw

补充：例如，输出到winxp的默认打印机。

wxlfh

Win32::OLE 应该能满足楼主的要求，但是具体参数得查手册的。

小perl

flw版主曾推荐 Excel::Writer::XLSX - Create a new file in the Excel 2007+ XLSX format(兼容2003).

flw

我刚才试过这个模块，是可以打印的。

1. ppm install Spreadsheet-PrintExcelSheet

复制代码

1. use strict;
   
2. use warnings;
   
3. use Smart::Comments;
   
4. 
   
5. use Spreadsheet::PrintExcelSheet qw(PrintIt);
   
6. 
   
7. PrintIt( 'C:/Users/flw/Desktop/研发任职资格模拟认证.xls', 'all' );

复制代码

可以把四个工作表都打印出来。

Windows 7
ActivePerl 5.14

ggglw

我安装了四五次都失败了。
C:\Documents and Settings\Administrator>ppm install Spreadsheet-PrintExcelSheet
Downloading ppm4.activestate.com packlist...done
Updating ppm4.activestate.com database...done
Downloading www.bribes.org packlist...done
Updating www.bribes.org database...done
Downloading ppd.develop-help.com packlist...not found
Downloading www.lostmind.de packlist...not modified
Downloading log4perl.sourceforge.net packlist...redirect
Downloading log4perl.sourceforge.net packlist...done
Downloading log4perl.sourceforge.net Log-Dispatch-FileRotate PPD...not modified
Downloading log4perl.sourceforge.net Log-Dispatch PPD...not modified
Downloading log4perl.sourceforge.net Log-Log4perl PPD...done
Downloading log4perl.sourceforge.net Params-Validate PPD...not modified
Downloading www.roth.net packlist...done
Downloading www.roth.net GDBM_File PPD...done
Downloading www.roth.net Win32-AdminMisc PPD...not modified
Downloading www.roth.net Win32-API-Prototype PPD...not modified
Downloading www.roth.net Win32-Daemon PPD...not modified
Downloading www.roth.net Win32-EventLog-Message PPD...not modified
Downloading www.roth.net Win32-Exchange PPD...not modified
Downloading www.roth.net Win32-Message PPD...done
Downloading www.roth.net Win32-ODBCBETA PPD...done
Downloading www.roth.net Win32-Perms PPD...not modified
Downloading www.roth.net Win32-Pipe PPD...not modified
Downloading www.roth.net Win32-RASAdmin PPD...done
Downloading www.roth.net Win32-Scheduler PPD...done
Downloading www.roth.net Win32-Tie-Ini PPD...done
Downloading www.roth.net Win32-Volume PPD...done
Downloading ppm.gingerall.cz packlist...not found
Downloading ppm.tcool.org packlist...done
Updating ppm.tcool.org database...done
Downloading trouchelle.com packlist...not modified
Downloading theoryx5.uwinnipeg.ca packlist...not modified
Downloading voltar.org packlist...not modified
Downloading www.wxperl.co.uk packlist...not modified
Downloading www.wxperl.co.uk packlist...not modified
Downloading www.bribes.org packlist...done
ppm install failed: DBD::SQLite::db do failed: column packlist_uri is not unique


Windows xp
ActivePerl 5.8.9

小perl

我的安装成功，ActivePel5.14。WinXP，你怎么不升级一下Perl版本？

gaoyang636

果然还是难不住flw呀～