in reply to Differnece between Spreadsheet::ParseXLSX and Spreadsheet::ParseExcel

Hello Sonali,

I cannot advise on spreadsheet issues, but you may find that it's easier to compare hashes dumped with Data::Dumper if you use its Sortkeys flag:

use Data::Dumper; $Data::Dumper::Sortkeys = 1; print Dumper \%hash; ...
The above will sort the keys according to Perl's default sort order. You can also pass a subroutine reference as the value of $Data::Dumper::Sortkeys to control the sort or even limit the keys that are dumped. See Configuration Variables or Methods for more information.

Hope this helps!


The way forward always starts with a minimal test.