GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
Spreadsheet::ParseODS::Workbook(3) User Contributed Perl Documentation Spreadsheet::ParseODS::Workbook(3)

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-09 perl v5.32.1

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.