Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Spreadsheet::ParseODS(User Contributed Perl DocumentatSpreadsheet::ParseODS(3)

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

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

       o   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.

       o   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.

       o   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

       o   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.

perl v5.32.1			  2020-10-06	      Spreadsheet::ParseODS(3)

NAME | SYNOPSIS | WARNING | METHODS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Spreadsheet::ParseODS&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help