- 论坛徽章:
- 0
|
ActivePerl用PPM安装模块,在运行框输入PPM回车即可。
给一段excel文件生成代码,供你参考:
- #!/usr/bin/perl
- use strict;
- use warnings;
- use Spreadsheet::WriteExcel;
- my $file = "Excel_Example.xls";
- my $workbook = Spreadsheet::WriteExcel->new($file);
- $workbook->set_properties(
- title => 'Excel_Example',
- author => 'Limeng',
- company => 'BlueIdea Software Lab.',
- );
- my $worksheet = $workbook->add_worksheet('Limeng');
- # Create a format for the column headings
- my $header = $workbook->add_format(
- font => 'Arial',
- bold => 1,
- size => 12,
- color => 'blue',
- align => 'center',
- valign => 'vcenter',
- );
- my $red = $workbook->add_format(
- size => 11,
- align => 'right',
- valign => 'vcenter',
- bg_color => 'red',
- num_format => 0x04,
- );
- my $pink = $workbook->add_format(
- size => 11,
- align => 'right',
- valign => 'vcenter',
- bg_color => 33,
- num_format => 0x04,
- );
- # Set the column width for columns 1, 2, 3 and 4
- $worksheet->set_column(0, 3, 10);
- # Write datas
- $worksheet->write('A1','Test1',$header);
- $worksheet->write('B1','Test2',$header);
- $worksheet->write('C1','Test3',$header);
- $worksheet->write('A2','2000',$red);
- $worksheet->write('B2','-50000',$pink);
- $worksheet->write('C2','=A2+B2',$red);
- $workbook->close();
- print "Excel file write OK!";
- <>;
复制代码
|
|