in reply to Re^2: Reading huge spreadsheets using Spreadsheet::ParseExcel...
in thread Reading huge spreadsheets using Spreadsheet::ParseExcel...

What do i do in the cell handler function so that i can read the cell contents using the get_cell() and value() functions?

You don't need to use get_cell() since the cell_handler() callback function that you supply effectively replaces it.

Once you have the cell object you can call value() (or any other method) on it in the same way you would with the standard interface. This is shown in the example that dasgar linked to:

sub cell_handler { my $workbook = $_[0]; my $sheet_index = $_[1]; my $row = $_[2]; my $col = $_[3]; my $cell = $_[4]; # Do something useful with the formatted cell value print $cell->value(), "\n"; }

--
John.