1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
#!/usr/bin/perl -w
use Test::More;
eval { require Spreadsheet::WriteExcel };
plan skip_all => "Need Spreadsheet::WriteExcel for this test" if $@;
plan tests => 2;
use strict;
use Spreadsheet::ParseExcel::Simple;
my $filename = 'test.xls';
my $workbook = Spreadsheet::WriteExcel->new($filename);
my $worksheet1 = $workbook->add_worksheet();
my $worksheet2 = $workbook->add_worksheet();
$worksheet1->write('A1', 'Hello'); # 1 row
$worksheet2->write('A1', 'Hello'); # 2 rows
$worksheet2->write('A2', 'Hello');
$workbook->close();
my $xls = Spreadsheet::ParseExcel::Simple->read($filename);
for my $sheet ($xls->sheets) {
ok $sheet->has_data, "Sheet $sheet->{sheet}->{Name} has data";
}
unlink($filename);
|
