Spread...orkbook(3pm)

okay so bestie, you found the manual for Spread...orkbook(3pm) — it's part of the User Contributed Perl Documentation 💖 and it's all about Spreadsheet::ParseODS::Workbook. let's get into it ✨

🌸 NAME 🌸

Spreadsheet::ParseODS::Workbook - a workbook

---

"->filename"

print $workbook->filename;

This gives you the name of the file, if there is one. lowkey useful. 💅

"->table_styles"

The styles that identify whether a table is hidden, and other styles. no cap. 🎀

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

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

"->worksheets()"

my @sheets = $workbook->worksheets;

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

"->worksheet($name)"

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

Returns the worksheet with the given name, or if no such worksheet exists, returns undef. that's the tea. 🍓

---

and that's a wrap, bestie! this was perl v5.40.0, dated 2024-08-17, for Spread...orkbook(3pm). bye 💜