Spreadsheet-SimpleExcel version 1.2

This module is used to show data in excel-files in the web. It can be used to provide the results of a database query as an excel-file. It does not provide cell-formats yet, but the module will be extended within the next weeks.

Spreadsheet::SimpleExcel was created under working title "WWW::WebExcel"

This version provides these methods:

• new creates a new instance of SimpleExcel
• add_row appends new rows to the existing ones
• set_headers replaces the existing list of headers
• add_row_at inserts a row into existing data
• sort_data sorts the data
• output prints data as spreadsheet
• output_as_string returns the output as a string
• output_to_file prints data into a file
• add_worksheet adds a worksheet to the spreadsheet
• del_worksheet deletes a worksheet of the spreadsheet
• errstr returns the error message of last occured error
• sort_worksheets sort worksheets in asc or desc order
• sheets returns a list of all worksheets
• set_headers_format set formats for header-row
• set_data_format set formats for data
• output_to_XML prints the data as XML file

As a simple example:

        binmode(\*STDOUT);
        my @data;
        $sth->execute() or die $DBI::errstr;
        while(my @row = $sth->fetchrow_array()){
          push(@data,\@row);
        }
        my $worksheet = ['NAME',{-data => \@data}]
        my $excel = Spreadsheet::SimpleExcel->new(-worksheets => [$worksheet]);
        $excel->output();

INSTALLATION

To install this module type the following:

perl Makefile.PL
make
make test
make install

DEPENDENCIES

This module requires these other modules and libraries:

Spreadsheet::WriteExcel
IO::Scalar

COPYRIGHT AND LICENCE

Put the correct copyright and licence information here.

Copyright (C) 2004 by Renee Baecker

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.6.1 or, at your option, any later version of Perl 5 you may have available.