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
