[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