[pm-h] May meeting

[G. Wade Johnson]

On Thu, 01 May 2008 06:27:07 -0600
Mike Flannigan <mikeflan at att.net> 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.

I've used Spreadsheet::WriteExcel a little and I recall having problems
with the column widths. (Win32::OLE doesn't work under Linux.)

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

Being able to write spreadsheets from Perl is definitely interesting.

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

That never stopped me from presenting.<grin/> Seriously though,
presenting on a topic is not the same as "teaching" it. The purpose of
the presentation can be just to show others what you have done.

I've found that preparing for the presentation often teaches me new
things about the subject. The act of organizing it into a form I'm
willing to present helps solidify what you know.

If you were interested, I think this would be a good topic.

G. Wade
-- 
"If everything's under control, you're going too slow."
                                                   -- Mario Andretti