Do you get the same (bogus) results when you do the same thing by hand within Excel? Do you get the same (bogus) results if you record a macro in Excel to do the same thing?

Generally recording an Excel macro to perform a task, then modeling your Perl script on the macro produces best results.