Re: Reading xls file

[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

On 12/2/05, Alfred Vahau <[EMAIL PROTECTED]> wrote:
>
> http://www-128.ibm.com/developerworks/library/l-pexcel/
>
> Alfred,
>
> Timothy Johnson wrote:
>
> >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:[EMAIL PROTECTED]
> >Sent: Wednesday, November 30, 2005 8:22 PM
> >To: beginners@perl.org
> >Subject: Reading xls file
> >
> >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.
> >
> >
> >
> >
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> <http://learn.perl.org/> <http://learn.perl.org/first-response>
>
>
>


--
Colm

Re: Reading xls file

[Alfred Vahau]

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

Alfred,

Timothy Johnson wrote:


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:[EMAIL PROTECTED] 
Sent: Wednesday, November 30, 2005 8:22 PM

To: beginners@perl.org
Subject: Reading xls file

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.


 



--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>

RE: Reading xls file

[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:[EMAIL PROTECTED] 
Sent: Wednesday, November 30, 2005 8:22 PM
To: beginners@perl.org
Subject: Reading xls file

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.


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>

Re: Reading xls file

[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Æþ;
-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 

Re: Reading xls file

[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*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

On 12/1/05, Chris Devers <[EMAIL PROTECTED]> wrote:
>
> On Wed, 30 Nov 2005, Pant, Hridyesh wrote:
>
> > 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...
>
> 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$
>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>  
>
>
>

Re: Reading xls file

[Chris Devers]

On Wed, 30 Nov 2005, Pant, Hridyesh wrote:

> 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...

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$
-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 

Reading xls file

[Pant, Hridyesh]

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

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]