[pm-h] May meeting
Will Willis
will.willis at gmail.com
Thu May 1 11:24:32 PDT 2008
Ditto!
-Will
On Thu, May 1, 2008 at 9:19 AM, Todd Rinaldo <toddr at null.net> wrote:
> 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
>
>
>
>
>
> _______________________________________________
> Houston mailing list
> Houston at pm.org
> http://mail.pm.org/mailman/listinfo/houston
> Website: http://houston.pm.org/
>
More information about the Houston
mailing list