in reply to Problem with Spreadsheet::XLSX..
"I downloaded the tar files, unzip them n copied to my perllib directory."
This isn't a sensible way to install modules. Use cpan Spreadsheet::XLSX to install the module and it's prerequisites correctly.
I suggest setting up your own Perl on the system, and avoid using the system Perl which ships with Solaris. First of all Solaris uses this for some OS tasks and it's best left alone, secondly 5.8.4 is very old. See App::perlbrew for an easy way to achieve this.