Reference

Spreadsheet::ParseODS::Workbook(3pm)

a workbook

NAME

Spreadsheet::ParseODS::Workbook - a workbook

"->filename"

  print $workbook->filename;

The name of the file if applicable.

"->table_styles"

The styles that identify whether a table is hidden, and other styles

"->get_print_areas()"

    my $print_areas = $workbook->get_print_areas();
    # [[ [$start_row, $start_col, $end_row, $end_col], ... ]]

The "->get_print_areas()" method returns the print areas of each sheet as an arrayref of arrayrefs. If a sheet has no print area, "undef" is returned for its print area.

"->get_active_sheet()"

    my $sheet = $workbook->get_active_sheet();
    if( !$sheet ) {
        # If there is no defined active worksheet, take the first:
        ($sheet) = $workbook->worksheets();
    };

Returns the active worksheet, or if there is no such sheet, returns "undef".

"->worksheets()"

    my @sheets = $workbook->worksheets;

Returns the list of worksheets as Spreadsheet::ParseODS::Worksheet objects.

"->worksheet($name)"

    my $sheet1 = $workbook->worksheet('Sheet 1');

Returns the worksheet with the given name, or if no such worksheet exists, returns "undef".

History