This strategy won't work well unless you know exactly what you're doing, for example this won't install dependencies or do any testing to ensure your setup will work. Modules usually have an INSTALL or README file which explain installation. A more sensible approach would be to use cpan or cpanm to do all of this for you:

cpan Spreadsheet::ParseExcel

cpanm Spreadsheet::ParseExcel
[download]

cpan is core so you don't need to install it, cpanm requires installation but has it's advantages also. These tools will download the module, install any dependencies, run the test suite then install.

Update: fixed typo.

when tried to do according to README file after I do Makefile.PL it hungs up and shows an error"prerequisites no t found"

Of course, because you haven't got the prerequisite modules installed, which is why I suggested using cpan/cpanm. Simply copying files will not resolve the dependencies for you. If you are determined to ignore the advice of using one of the tools I previously mentioned, you'll need to manually install all of the prerequisites, and their prerequisites....