#!/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";
}