Provided by: libspreadsheet-readsxc-perl_0.35-1_all
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".