Spread...ksheet(3pm)

✨ NAME ✨

Spreadsheet::ParseODS::Worksheet — it's literally one sheet inside a workbook, bestie. Like, one tab. One page. One whole vibe. This is the Spread...ksheet(3pm) manual page, and no, the name isn't broken, it's just ✨ truncated for your terminal's convenience ✨.


🎀 get_print_areas() 🎀

Okay so you wanna know where this sheet is supposed to get printed. Say less:

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

The ->get_print_areas() method hands you back the print areas of the sheet as an arrayref. Iconic. Each little inner arrayref is a [$start_row, $start_col, $end_row, $end_col] situation, so you know exactly which rectangle of cells is getting the printer treatment. 🖨️✨

Heads up bestie: it returns undef if there are no print areas. Not an empty list, not a shrug — just undef. So vibe check that return value before you go dereferencing, fr fr. 💀

perl v5.40.0, dated 2024-08-17 — that's the source, the version and the date, and that's the whole page. Per User Contributed Perl Documentation, no cap. 💅🦋

k byeeee, go parse some spreadsheets 🫶🌸

📦 where this page comes from