---
name: "Spreadsheet::ParseODS"
section: "3pm"
platform: "linux"
package: "libspreadsheet-readsxc-perl"
version: "0.39-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Spreadsheet::ParseODS"
---

# Spreadsheet::ParseODS(3pm)

read SXC and ODS files

## 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-2024 by Max Maischein `"corion@cpan.org"`.

## LICENSE

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