in reply to Re^4: PERL : Parse/Open an excel file and replace the negative values in a sheet to '0'
in thread PERL : Parse/Open an excel file and replace the negative values in a sheet to '0'

Looks good. To make the change to the worksheet, you need to add

$worksheet->write($row,$col,$cell_value);

[download]

I can't be sure that's exactly right, since I don't have those Spreadsheet modules installed. But it should be close.

Dum Spiro Spero
  • Comment on Re^5: PERL : Parse/Open an excel file and replace the negative values in a sheet to '0'
  • Download Code

In Section Seekers of Perl Wisdom