spreadsheet::parseexcel::simple(3pm) [debian man page]

Spreadsheet::ParseExcel::Simple(3pm)			User Contributed Perl Documentation		      Spreadsheet::ParseExcel::Simple(3pm)

NAME

       Spreadsheet::ParseExcel::Simple - A simple interface to Excel data

SYNOPSIS

	 my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');
	 foreach my $sheet ($xls->sheets) {
	    while ($sheet->has_data) {
		my @data = $sheet->next_row;
	    }
	 }

DESCRIPTION

       This provides an abstraction to the Spreadsheet::ParseExcel module for simple reading of values.

       You simply loop over the sheets, and fetch rows to arrays.

       For anything more complex, you probably want to use Spreadsheet::ParseExcel directly.

BOOK METHODS

       read

	 my $xls = Spreadsheet::ParseExcel::Simple->read('spreadsheet.xls');

       This opens the spreadsheet specified for you. Returns undef if we cannot read the book.

       sheets

	 @sheets = $xls->sheets;

       Each spreadsheet can contain one or more worksheets. This fetches them all back. You can then iterate over them, or jump straight to the
       one you wish to play with.

       book

	       my $book = $xls->book;

       The Spreadsheet::ParseExcel object we are working with. You can use this if you need to manipulate it in ways that this interface doesn't
       allow.

SHEET METHODS

       These methods can be called on each sheet returned from $xls->sheets:

       has_data

	 if ($sheet->has_data) { ... }

       This lets us know if there are more rows in this sheet that we haven't read yet. This allows us to differentiate between an empty row, and
       the end of the sheet.

       next_row

	 my @data = $sheet->next_row;

       Fetch the next row of data back.

       sheet

	       my $obj = $sheet->sheet;

       The underlying Spreadsheet::ParseExcel object for the worksheet. You can use this if you need to manipulate it in ways that this interface
       doesn't allow (e.g. asking it for the sheet's name).

AUTHOR

       Tony Bowden

BUGS and QUERIES
       Please direct all correspondence regarding this module to:
	 bug-Spreadsheet-ParseExcel-Simple@rt.cpan.org

COPYRIGHT AND LICENSE

	 Copyright (C) 2001-2005 Tony Bowden.

	 This program is free software; you can redistribute it and/or modify it under
	 the terms of the GNU General Public License; either version 2 of the License,
	 or (at your option) any later version.

	 This program is distributed in the hope that it will be useful, but WITHOUT
	 ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
	 FOR A PARTICULAR PURPOSE.

SEE ALSO

       Spreadsheet::ParseExcel.

perl v5.8.8							    2008-03-12				      Spreadsheet::ParseExcel::Simple(3pm)

Spreadsheet::WriteExcel::Chart::Pie(3pm)		User Contributed Perl Documentation		  Spreadsheet::WriteExcel::Chart::Pie(3pm)

NAME

       Pie - A writer class for Excel Pie charts.

SYNOPSIS

       To create a simple Excel file with a Pie chart using Spreadsheet::WriteExcel:

	   #!/usr/bin/perl -w

	   use strict;
	   use Spreadsheet::WriteExcel;

	   my $workbook  = Spreadsheet::WriteExcel->new( 'chart.xls' );
	   my $worksheet = $workbook->add_worksheet();

	   my $chart	 = $workbook->add_chart( type => 'pie' );

	   # Configure the chart.
	   $chart->add_series(
	       categories => '=Sheet1!$A$2:$A$7',
	       values	  => '=Sheet1!$B$2:$B$7',
	   );

	   # Add the worksheet data the chart refers to.
	   my $data = [
	       [ 'Category', 2, 3, 4, 5, 6, 7 ],
	       [ 'Value',    1, 4, 5, 2, 1, 5 ],
	   ];

	   $worksheet->write( 'A1', $data );

	   __END__

DESCRIPTION

       This module implements Pie charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook "add_chart()" method:

	   my $chart = $workbook->add_chart( type => 'pie' );

       Once the object is created it can be configured via the following methods that are common to all chart classes:

	   $chart->add_series();
	   $chart->set_title();

       These methods are explained in detail in Spreadsheet::WriteExcel::Chart. Class specific methods or settings, if any, are explained below.

Pie Chart Methods
       There aren't currently any pie chart specific methods. See the TODO section of Spreadsheet::WriteExcel::Chart.

       A Pie chart doesn't have an X or Y axis so the following common chart methods are ignored.

	   $chart->set_x_axis();
	   $chart->set_y_axis();

EXAMPLE

       Here is a complete example that demonstrates most of the available features when creating a chart.

	   #!/usr/bin/perl -w

	   use strict;
	   use Spreadsheet::WriteExcel;

	   my $workbook  = Spreadsheet::WriteExcel->new( 'chart_pie.xls' );
	   my $worksheet = $workbook->add_worksheet();
	   my $bold	 = $workbook->add_format( bold => 1 );

	   # Add the worksheet data that the charts will refer to.
	   my $headings = [ 'Category', 'Values' ];
	   my $data = [
	       [ 'Apple', 'Cherry', 'Pecan' ],
	       [ 60,	   30,	     10     ],
	   ];

	   $worksheet->write( 'A1', $headings, $bold );
	   $worksheet->write( 'A2', $data );

	   # Create a new chart object. In this case an embedded chart.
	   my $chart = $workbook->add_chart( type => 'pie', embedded => 1 );

	   # Configure the series.
	   $chart->add_series(
	       name	  => 'Pie sales data',
	       categories => '=Sheet1!$A$2:$A$4',
	       values	  => '=Sheet1!$B$2:$B$4',
	   );

	   # Add a title.
	   $chart->set_title( name => 'Popular Pie Types' );

	   # Insert the chart into the worksheet (with an offset).
	   $worksheet->insert_chart( 'C2', $chart, 25, 10 );

	   __END__

AUTHOR

       John McNamara jmcnamara@cpan.org

COPYRIGHT

       Copyright MM-MMX, John McNamara.

       All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.

perl v5.10.1							    2010-02-02				  Spreadsheet::WriteExcel::Chart::Pie(3pm)