View on
MetaCPAN is shutting down
For details read Perl NOC. After June 25th this page will redirect to
Joel Berger > Tie-Array-CSV-0.07 > Tie::Array::CSV



Annotate this POD

View/Report Bugs
Module Version: 0.07   Source  


Tie::Array::CSV - A tied array which combines the power of Tie::File and Text::CSV


 use strict; use warnings;
 use Tie::Array::CSV;
 tie my @file, 'Tie::Array::CSV', 'filename';

 print $file[0][2];
 $file[3][5] = "Camel";


This module allows an array to be tied to a CSV file for reading and writing. The array is a standard Perl 2D array (i.e. an array of array references) which gives access to the row and column of the user's choosing. This is done using the well established modules:

This module was inspired by Tie::CSV_File which (sadly) hasn't been maintained. It also doesn't attempt to do any of the parsing (as that module did), but rather passes all of the heavy lifting to other modules.

Note that while the Tie::File prevents the need to read in the entire file, while in use, a parsed row IS held in memory.


Since version 0.04 both constructors allow the options that version 0.03 only offered for the new constructor. The constructors must be passed a file name, either as the first argument, or as the value to the option key file. Options may be passed as key-value pairs or as a hash reference. This yields the many ways of calling the constructors shown below, one for every taste.

N.B. Should a lone argument filename and a file option key both be passed to the constructor, the lone argument wins.

tie Constructor

As with any tied array, the construction uses the tie function. Basic usage is as follows:

 tie my @file, 'Tie::Array::CSV', 'filename';

which would tie the lexically scoped array @file to the file filename using this module. Following the first two arguements to tie, one may optionally pass a key-value pairs or a hashref containing additional configuration or even file specification.

 tie my @file, 'Tie::Array::CSV', 'filename', { opt_key => val, ... };
 tie my @file, 'Tie::Array::CSV', 'filename', opt_key => val, ... ;
 tie my @file, 'Tie::Array::CSV', { file => 'filename', opt_key => val, ... };
 tie my @file, 'Tie::Array::CSV', file => 'filename', opt_key => val, ... ;

Of course, the magical Perl tie can be scary for some, for those people there is the ...

new Constructor

[ Added in version 0.03 ]

 my $array = Tie::Array::CSV->new( 'filename' );
 my $array = Tie::Array::CSV->new( 'filename', { opt_key => val, ... });
 my $array = Tie::Array::CSV->new( 'filename', opt_key => val, ... );
 my $array = Tie::Array::CSV->new( file => 'filename', opt_key => val, ... );
 my $array = Tie::Array::CSV->new( { file => 'filename', opt_key => val, ... } );

It only returns a reference to the tied array due to a limitations in how tie magic works.


Equivalent examples:

 tie my @file, 'Tie::Array::CSV', 'filename', { 
   tie_file => {}, 
   text_csv => { sep_char => ';' },

 tie my @file, 'Tie::Array::CSV', 'filename', sep_char => ';';

Note that as of version 0.05 the functionality from the former hold_row option has been separated into its own subclass module Tie::Array::CSV::HoldRow. If deferring row operations is of interest to you, please see that module.


For simplicity this module croaks on all almost all errors, which are trappable using a $SIG{__DIE__} handler. Modifing a severed row object issues a warning.





Joel Berger, <>


Mithaldu - Christian Walde (cpan:MITHALDU) <>


Copyright (C) 2013 by Joel Berger

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

syntax highlighting: