3
##############################################################################
5
# An example of writing an Excel file to a Perl scalar using Spreadsheet::
6
# WriteExcel and the new features of perl 5.8.
8
# For an examples of how to write to a scalar in versions prior to perl 5.8
9
# see the filehandle.pl program and IO:Scalar.
11
# reverse('�'), September 2004, John McNamara, jmcnamara@cpan.org
15
use Spreadsheet::WriteExcel;
20
# Use perl 5.8's feature of using a scalar as a filehandle.
23
open $fh, '>', \$str or die "Failed to open filehandle: $!";;
26
# Or replace the previous three lines with this:
27
# open my $fh, '>', \my $str or die "Failed to open filehandle: $!";
30
# Spreadsheet::WriteExce accepts filehandle as well as file names.
31
my $workbook = Spreadsheet::WriteExcel->new($fh);
32
my $worksheet = $workbook->add_worksheet();
34
$worksheet->write(0, 0, "Hi Excel!");
39
# The Excel file in now in $str. Remember to binmode() the output
40
# filehandle before printing it.