NAME

Apache::FastForward::Spreadsheet

SYNOPSIS

my $t1 = tie my %t1, 'Spreadsheet';

my %csv_atr = (
       'quote_char'  => '"',
       'escape_char' => '"',
       'sep_char'    => ';',
       'binary'      => 1 );

$t1->LoadTemplate( './t1.csv', \%csv_atr);

$t1{'A3'} = 'BZDYL';
print $t1{'3,1'};
print $t1->DumpAsCSV( \%csv_atr );
print $t2->RowCount(), "\n";

my $t2 = tie my %t2, 'Spreadsheet';
$t1->CopySheetTo( $t2 );

my @row = ( 1, 2, 3 );
$t2->SetRow( 1, @row );
@row = $t2->GetRow( 1 );
my $new_spreadsheet_size = St2->PushRow( @row );
@row = $t2->PopRow();
@row = $t2->RemoveRow( 2 );

DESCRIPTION

USAGE

The module should be used for manipulating CSV data structures as if it would be a spreadsheet. Spreadsheet address in a form eg ('A12') or row and column number eg ('12,1') can be used for data access.

METHODS

LoadTemplate ( $csv_file_path, \%csv_attributes )

Path to a CSV file and CSV parameters (see Text::CSV_XS) as input. Method can either suceed or everything dies...

DumpAsCSV( \%csv_attributes )

CSV file parameters as input. Method can return CSV string or everything dies...

CopySheetTo( $another_sheet )

Name of the 'SpreadSheet' tied pointer to hash as input. Method succeeds or everything dies ...

ShiftRow( )

No input. Similar to 'shift @ARRAY'. Returns shifted row.

PopRow( )

No input. Similar to 'pop @ARRAY'. Returns poped row.

PushRow( @new_cell_values )

Array as input. Similar to 'push @ARRAY'. Returns the new number of elements in the array.

GetRow( $row_number )

Row number as input. Returns array of cell values.

SetRow( $row_number, @@new_cell_values )

Row number and array as input. Returns nothing.

RemoveRow( $row_number )

Row number as input. Returns removed row as array.

RowCount( )

No input. Returns the number of elements in the spreadsheet.

BUGS

Any suggestions for improvement are welcomed!

If a bug is detected or nonconforming behavior, please send an error report to <jwach@cpan.org>.

COPYRIGHT

Copyright 2006 Jerzy Wachowiak <jwach@cpan.org>

This library is free software; you can redistribute it and/or modify it under the terms of the Apache 2.0 license attached to the module.

SEE ALSO

Apache::FastForward