in reply to Create Excel SpreadsheetS

I believe you just add another sheet with my $anothersheet = $workbook->add_worksheet('mah name be page two').

-Paul

Replies are listed 'Best First'.
Re^2: Create Excel SpreadsheetS
by Anonymous Monk on Dec 28, 2006 at 19:55 UTC
    lol mah name be page 2
      Thanks it now works. Any way I can get this on a web page where someone can click on a CGI/Perl link and it will show the Excel File?
      use Spreadsheet::WriteExcel; my $workbook = Spreadsheet::WriteExcel->new("C:/myfile.xls"); $worksheet = $workbook->add_worksheet(); $worksheet->write('A1', "Hi Exclel!"); $worksheet = $workbook->add_worksheet(); $worksheet->write('A1', "Next spreadsheet");
        You could start with this program from the Spreadsheet::WriteExcel examples.

        --
        John.