471,852 Members | 908 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,852 software developers and data experts.

Installing Spreadsheet::WriteExcel,Spreadsheet:ParseExcel

9
I am using Active Perl for running perl programs.I am finding difficulty in installing Spreadsheet::WriteExcel,Spreadsheet:ParseExcel to the machine for writing a program which will retrieve data from an Excel Sheet.

Can anyone explain me the steps to install Spreadsheet::WriteExcel,Spreadsheet:ParseExcel in Windows machine.
Jan 20 '07 #1
4 14413
KevinADC
4,059 Expert 2GB
Start>>Programs>>Activestate/activeperl(folder)>>documentation

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.
Jan 20 '07 #2
tito
9
Thanks Kevin for your immediate response.I was able to install Spreadsheet::WriteExcel,Spreadsheet::ParseExcel 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::ParseExcel interface.

Thank u
Jan 22 '07 #3
miller
1,089 Expert 1GB
Read the docs. That's why they are there

http://search.cpan.org/search?query=...et::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/S...rseExcel-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.
Jan 22 '07 #4
KevinADC
4,059 Expert 2GB
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.
Jan 22 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Fabio | last post: by
7 posts views Thread by MMak12 | last post: by
12 posts views Thread by pankajit09 | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.