$wksheet->write( 'A1', 'A1' ); $wksheet->write( 'A2', 'A2' ); $wksheet->write_url( 'A3', 'http://www.cpan.org',, 'CPAN' ); my $pct = $wbk->add_format( num_format => '0.00%' ); $wksheet->write( 'A4', 0.5, $pct );

for ( 4 .. 8 ) { $wksheet->write( $_, 0, $_ ); $wksheet->write( $_, 1, $_ * 2 ); } $wksheet->write( 'C5:C9', '{=TREND(B5:B9,A5:A9)}' );

# These are not tested. EWX just writes them as strings $wksheet->write( 'D1', 'TRUE' ); $wksheet->write( 'D2', 'FALSE' );

$wbk->close();