[pm-h] May meeting

[Todd Rinaldo]

Mike,

As far as I'm concerned, what you're doing is true Perl. Many of us do  
perl at our job on a regular basis. The problems we discuss are often  
about a practical implementation of perl. For instance in your case,  
in addition to a presentation on what you're doing, it might be  
interesting to afterwards:

1. Discuss alternative approaches to the problem. I'm sure many of us  
have tackled excel with perl before
2. Discuss the "impossible" problem of auto-fit and how we might hack  
it to work.
3. Discuss the bug that 24 breaks and "24" works, possibly review the  
perl module and suggest a patch
4. Open document format and Excel's support for it
5. Excel's support for xml - would this support autofit?

To me, the meetings are just as great when we discuss practical  
problems as they are when we discuss abstract perl.

I would look forward to hearing more about your experiences with this  
module. Don't worry about the teaching part. I've presented before and  
I only play a teacher on television. They didn't laugh at my  
performance till I was out of the room *grin*.

Todd

On May 1, 2008, at 7:27 AM, Mike Flannigan wrote:

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

Todd Rinaldo
toddr at null.net