[Israel.pm] Writing Excel file

Scott Weisman sweisman at pobox.com
Thu Mar 11 00:26:18 PST 2004


yes, you can define a format for how the number should be displayed. it works
similarly with dates, which are stored internally as a number. the nice thing
about WriteExcel is that it is cross-platform.

scott

On Thu, 11 Mar 2004 10:24:54 +0200 (IST) Gabor Szabo <gabor at perl.org.il>
wrote:

> On Thu, 11 Mar 2004, Scott Weisman wrote:
> 
> > you can also write a csv file and rename it with the .xls extension and it
> > too will work.
> >
> > i use the Spreadsheet::WriteExcel module. It's not that hard to use and is
> > quite flexible. i also generate csv files, but the ability to create
> > multiple worksheets is a definite plus for using a native format.
> >
> 
> I had the same problem a couple of month ago with the addition that I
> had to handle values like
> 03444  to be shown as string and values like with the leading 0
> 0.3    to be shown as numbers with the leading 0
> 
> In the end I used some Win32::* and requred an Excel installed on the
> machine (which was not a problem as the client had it)
> 
> Can any of the above mentioned module handle these tasks properly ?
> 
> Gabor
> 
> _______________________________________________
> Perl mailing list
> Perl at perl.org.il
> http://www.perl.org.il/mailman/listinfo/perl
> 
> 



More information about the Perl mailing list