NAME

Spreadsheet::ParseODS - read SXC and ODS files

SYNOPSIS

  my $parser = Spreadsheet::ParseODS->new(
      line_separator => "\n", # for multiline values
  );
  my $workbook = $parser->parse("$d/$file");
  my $sheet = $workbook->worksheet('Sheet1');

WARNING

This module is not yet API-compatible with Spreadsheet::ParseXLSX and Spreadsheet::ParseXLS. Method-level compatibility is planned, but there always be differences in the values returned, for example for the cell types.

METHODS

->new

Options

  • line_separator - the value to separate multi-line cell values with

  • readonly - create the sheet as readonly, sharing Cells between repeated rows. This uses less memory at the cost of not being able to modify the data structure.

  • NoTruncate - legacy option not to truncate the sheets by stripping empty columns from the right edge of a sheet. This option will likely be renamed or moved.

  • twig - a premade XML::Twig::XPath instance

->parse( %options )

    my $workbook = Spreadsheet::ParseODS->new()->parse( 'example.ods' );

Reads the spreadsheet into memory and returns the data as a Spreadsheet::ParseODS::Workbook object.

Options

  • inputtype - the type of file if passing a filehandle. Can be ods, sxc , fods or xml.

This method also takes the same options as the constructor.

REPOSITORY

The public repository of this module is https://github.com/Corion/Spreadsheet-ReadSXC.

SUPPORT

The public support forum of this module is https://perlmonks.org/.

BUG TRACKER

Please report bugs in this module via the Github bug queue at https://github.com/Corion/Spreadsheet-ReadSXC/issues

AUTHOR

Max Maischein corion@cpan.org

CONTRIBUTORS

H. Merijn Brand hmbrand@cpan.org Mohammad S Anwar manwar@cpan.org

COPYRIGHT (c)

Copyright 2019-2020 by Max Maischein corion@cpan.org.

LICENSE

This module is released under the same terms as Perl itself.