Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

cog (4665)

Journal of cog (4665)

Tuesday August 03, 2004
07:09 AM

Office and tables

[ #20208 ]

I had been given a terrible task...

Suppose you have a bunch of dimensions (tables in a database) and you have to
create a document (a doc, actually), with some tables containing the records
in those tables...

What to do? :-)

After stressing for a while, I realized that grabbing the files with the
records, using vim to create HTML tables (with the fantastic operator s),
opening them with Firefox and copy-pasting them into Office... ta-ra!! :-D
Instant-tables! :-)

It was a good thing, because most of those dimensions have several hundreds of
records :-)

Yes, I'm a programmer, and yes, I *am* lazy :-)

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • I wonder if it wouldn't be lazier to use Win32::OLE. I've found that it's very reasonable and makes a lot of tasks very simple.

    I generate a lot of Excel spreadsheets using DBI + Win32::OLE, and I bet it would be just as easy to do the same with Word.
    --
    rjbs
    • That will let you write Excel spreadsheet without a Windoze box near you!
      Pure perl, pure goodness! Thank you jmcnamara.

      Now we just need someone to do Pod::Simple::MsWord, so we can avoid Word entirely.