process with excel file using PERL?

Question

Hi I need to do process with excel(.xls) files.I found some examples on web.But they are using
use script
use Spreadsheet::WriteExcel kind of perl modules(PM files).
I don't have those. I am not able to download from net.
If any one have plz mail to me.
Any other way to read or write Excel file...? please let me know ASAP..
Thx in advance...
Bhushan

Answer 1

I just got the latest version from cpan.org using the perl cpan program!

it picked it up from

ftp://carroll.cac.psu.edu/ pub/CPAN/authors/ id/J/JM/JMCNAMARA/ Spreadsheet- WriteExcel-2.18.tar.gz

(without the spaces)

I also install Spreadsheet::ParseExcel to read excel files!

Answer 2

PERL cannot actually read an Excel file. You need to have Excel installed on your computer before you can access it using PERL. Assuming you have Excel on your computer, you would need to open it as an OLE application. You'll need ActiveState PERL for Win32 to do this. I'm not sure if it's available for other ports of PERL.

You can see how to use it here.

http://www.blazonry.com/perl/xl_oleauto.php

If you Google,

perl excel "ole automation"

, you'll find a lot of sites explaining how to access Excel files.

Answer 3

PHP is open source. It is easy to learn PHP. PHP solves more specific web development problems. If you have a background of C, then you can start programming very easily in PHP. PERL was developed as general propose programming language. PERL documentation is sadi to be better than PHP.

Answer 4

If you can not download perl modules from the net then you are SOL. xls is "binary" format and perl can not read/process it by itself.

Answer 5

You'll need to install a program named xlviewer.exe = "Word Excel" from Windows.
I think theyre free...Excel Viewer 2003
Description: Open, view, and print Excel workbooks, even if you don't have Excel installed. This download is a replacement for Excel Viewer 97 and all previous Excel Viewer versions.