The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

Spreadsheet::Simple::Sheet - An object that represents a single spreadsheet (or worksheet)

METHODS

get_row(Int $row)

Return a Spreadsheet::Simple::Row object.

This will never return undef, it will autovivify a non-exisitng row upon request.

new_row(@args)

Convenience method for creating a new row object.

get_cell(Int $row, Int $col)

Convenience method for getting a cell object. Returns a new cell object and cannot return undef.

set_cell(Int $row, Int $col, $cell)

Convenience method

    $self->get_row($row)->set_cell($col, $cell)

get_cell_value($row, $col)

Convenience method

    $self->get_cell($row, $col)->value

set_cell_value(Int $row, Int $col, Str $value)

Convenience method

    $self->get_row($row)->set_cell($col, Spreadsheet::Simple::Cell->new(value => $value))

AUTHOR

Dylan William Hardison

COPYRIGHT AND LICENSE

This software is copyright (c) 2013 by Infinity Interactive, Inc.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.