Reading xls file

[Hridyesh Pant]

Hi,
I want to store column data of xls file in array.
E.g. $array[0]=1st column of xls sheet.
$array[1]=2st column of xls sheet.
$array[2]=3st column of xls sheet.
...
etc....

Can anybody help me...

Regards
Hridyesh

[Chris Devers]

Probably, I'm sure someone could.

What did your search for Excel-related modules on CPAN turn up?

When you found Spreadsheet::WriteExcel, as I have no doubt that you did,
did you read the documentation for it, and the sample code provided?

When you tried using the module, what happened? Where is your code?

This STILL isn't the "please do my homework for me" list :-)

--
Chris Devers

eD ¯! î×/.Z$

[Rob Coops]

Then again Chris here is asking for a way to read XLS files not a way to
write them...

So maybe the: *DBD::Excel*<http://search.cpan.org/author/KWITKNR/DBD-Excel-0.06/Excel.pm>would
be more helpful in this case, but you are right most of us are not in
the habit of writting other people's homework, yet having been a perl
beginner my self at some point I do feel the need to mention that there is a
a chance that not all beginners know about the wonders that can be found at:
http://search.cpan.org

> --
> To unsubscribe, e-mail: beginners-...@perl.org
> For additional commands, e-mail: beginne...@perl.org
> <http://learn.perl.org/> <http://learn.perl.org/first-response>
>
>
>

[Chris Devers]

On Thu, 1 Dec 2005, Rob Coops wrote:

> Then again Chris here is asking for a way to read XLS files not a way
> to write them...

Doh! Of course, I meant Spreadsheet::ParseExcel :-)

--
Chris Devers

xô©l7 1Æþ;

[Timothy Johnson]

If you are on a Windows system, the Win32::OLE module will work
beautifully for this. As a matter of fact, the documentation for the
Win32::OLE module uses Excel as an example.

-----Original Message-----
From: Pant, Hridyesh [mailto:hridye...@fidelity.co.in]
Sent: Wednesday, November 30, 2005 8:22 PM
To: begi...@perl.org
Subject: Reading xls file

Hi,

[Alfred Vahau]

http://www-128.ibm.com/developerworks/library/l-pexcel/

Alfred,

[Colm Gallagher]

For a slightly different approach (output only)

I create an XML file with the data I want and then XSLT transform to an
excel sheet

here is a short script I wrote to convert an excel-html file to an xslt
http://www14.brinkster.com/colm/perl/perl-excel-xsl.html

This approach has the benefit that a non-excel user can read the sheet in
their web browser

--
Colm

> --
> To unsubscribe, e-mail: beginners-...@perl.org
> For additional commands, e-mail: beginne...@perl.org
> <http://learn.perl.org/> <http://learn.perl.org/first-response>
>
>
>

--
Colm