The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
#!/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 $workbook   = Spreadsheet::WriteExcel->new("test.xls");
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('test.xls');

for my $sheet ($xls->sheets) {
	ok $sheet->has_data, "Sheet $sheet->{sheet}->{Name} has data";
}