DOKK / manpages / debian 12 / libspreadsheet-readsxc-perl / Spreadsheet::ParseODS::Workbook.3pm.en
Spreadsheet::ParseODS::Workbook(3pm) User Contributed Perl Documentation Spreadsheet::ParseODS::Workbook(3pm)

Spreadsheet::ParseODS::Workbook - a workbook

  print $workbook->filename;

The name of the file if applicable.

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

    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.

    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".

    my @sheets = $workbook->worksheets;

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

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

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

2021-09-13 perl v5.32.1