[pm-h] May meeting

[Kristofer Hoch]

I've done exactly what you're trying to do.  Try this ...


$sheet->set_column('A:A', '24');

 

I don't know if putting it in the string will help you, but its the only way I can get rows to a certain hieght.


-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GIT d(d++) s+:++>s+:+ a33>29 
C++ UB+ UL+++ UA HU+ HI+ US++ 
P++++ W+++$ w PS+ PE t++ b+ G 
DI++>DI e r+++ z++++
------END GEEK CODE BLOCK------



----- Original Message ----
From: Mike Flannigan <mikeflan at att.net>
To: "Houston.pm located in Houston, TX." <houston at pm.org>
Sent: Thursday, May 1, 2008 7:27:07 AM
Subject: Re: [pm-h] May meeting


I've been spending the last few days writing Excel files
with Win32::OLE.  It's tricky due to referencing.  I
really just stumbled into the solution last night.  I
thought I was using Spreadsheet::WriteExcel, but
discover I can comment that use line out and it still
works.

It's reasonably fast - prints a total of 23,000 rows
into 5 different Excel files in about 15 seconds.

One thing that I can't get to work no matter what I do
is setting column width
$sheet->set_column('A:A', 24);
or
$sheet->set_column(0, 0, 24);

No errors - just doesn't do the job.  I understand
Autofit is impossible to.  I'd also like to
switch to another worksheet and save the file while
in that worksheet.  I'm still working on this stuff.

Yeah, this isn't really true Perl, but maybe some other
people will find it interesting.

No - I'm not qualified to teach it :-)


Mike


G. Wade Johnson wrote:
> Meeting time is coming up fast.
>
> Does anyone have a topic they would like to hear about or would like to
> talk about for the meeting in two weeks?
>
> If you haven't been coming to the meetings because the topics weren't
> interesting, let the group know where your interests lie. Someone might
> be willing to present on that subject.
>
> G. Wade
>  
_______________________________________________
Houston mailing list
Houston at pm.org
http://mail.pm.org/mailman/listinfo/houston
Website: http://houston.pm.org/



      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/mailman/private/houston/attachments/20080501/ab1d15bd/attachment.html