---
name: "Spreadsheet::ParseODS::Workbook"
section: "3pm"
platform: "linux"
package: "libspreadsheet-readsxc-perl"
version: "0.39-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Spreadsheet::ParseODS::Workbook"
---

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