Installing Spreadsheet::WriteExcel,Spreadsheet:ParseExcel

[tito]

I am using Active Perl for running perl programs.I am finding difficulty in installing Spreadsheet::Wr iteExcel,Spread sheet:ParseExce l to the machine for writing a program which will retrieve data from an Excel Sheet.

Can anyone explain me the steps to install Spreadsheet::Wr iteExcel,Spread sheet:ParseExce l in Windows machine.

[KevinADC]

Start>>Programs >>Activestate/activeperl(fold er)>>documentat ion

You should see a line something like:

The Perl Package Manager , for installing Perl extension modules

Perl Package Manager should be a link. Click it and read the documentation. Super easy to use. All the documentation is also on the activestate website.

The way I do it is I open a DOS window and go to the c:\> prompt. I then type ppm and hit enter. Wait a few seconds for ppm to start up. Then to install a module you type:

install modulename (then hit enter)

Thats really all there is to it. If you are using a firewall (such as zonealarm or some other one) you may need to disable it or add ppm to the firewalls list of programs that are allowed to access the internet.

[tito]

Thanks Kevin for your immediate response.I was able to install Spreadsheet::Wr iteExcel,Spread sheet::ParseExc el in my machine by your instructions.

If the time allows can you just explain or give a sample program which will retrieve data from an Excel sheet using Spreadsheet::Pa rseExcel interface.

Thank u

[miller]

Read the docs. That's why they are there

http://search.cpan.org/search?query=Spreadsheet::ParseExcel

Also, always check a module's installation for examples. At the very least there will be test scripts which will often add enlightenment to the newly initiated. But with more involved modules, you'll also sometimes find examples included with the installation.

http://search.cpan.org/src/SZABGAB/Spreadsheet-ParseExcel-0.28/

To get to the above source, simply start on the pod documentation page from above. Click on the package name "Spreadsheet-ParseExcel-0.28" and then on "browse". Alternatively, you can just download the package and view which files are available that way.

Get to be very familiar with cpan. It'll help you a lot.

[KevinADC]

If the module is now loaded on his local PC the dcumentation is there as well. In perl/html/index.html or in the activestate folder. But of course cpan and perldocs are the two sites all perl coders should have bookmarked.