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.
undef
->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.
To install Spreadsheet::ReadSXC, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Spreadsheet::ReadSXC
CPAN shell
perl -MCPAN -e shell install Spreadsheet::ReadSXC
For more information on module installation, please visit the detailed CPAN module installation guide.