in reply to Is there a way to embed Word or other Office applications into my perl app?

IMO your looking at the wrong tools. Just because a screwdriver looks like a chisel, doesnt mean it should be used for carving wood.

IM(Humble)O, If your going client server (ie web-based app) it would be better and more scalable to use a client server based RDBMS, such as Oracle, sqlserver, postgres (free), mysql (also free).

Once you have your data in there, (if you want to create reports) you could use something as simple as sql to generate html pages, or something fancy that will produce a pdf or even generate the MS doco's (Excel), for you (Have a look on the cpan).

I'm guessing you have a little knowledge of sql, and RDBMS's from your Access (tm) comments, so be not afraid, the knowledge you have is not wasted, and can be applied to a "more worthy" RDBMS. You may however have to pickup some additional skills such as how to install and configure a c/s rdbms (can be tricky, but not extremely difficult - there are loads of help and doco for out there), and perhaps some manual table creation skills...

Once you have those you can create a much more scalable framework for want you're after!

Good luck!

  • Comment on Re: Is there a way to embed Word or other Office applications into my perl app?

Replies are listed 'Best First'.
Re: Re: Is there a way to embed Word or other Office applications into my perl app?
by Anonymous Monk on Sep 09, 2002 at 13:33 UTC

    Thank you both for your advice. I shall look into the modules you have suggested. Allow me to explain my idea for this app.

    I am an instructor for certification school. We have all our data tied up in Access databases. All our billing documents in VB enhanced Excel pages. And a whole lot evaluations form tied up in mail-merged and locked Word documents.

    Instead of redoing everything (meaning shifting to a system based on a true RDMS, web scriting, and browser) I'd rather use all the MS office based forms within a web-app for our intranet. This way I can improve (make completing our daily tasks faster and easier) our current system while creating a more robust future system that will eventually replace the current system.

    I have recently found that PHP can do this with it's poorly documented COM support. I was hoping that Perl had a better documented method.

[reply]
      TBH i reckon you're wasting your time. Why spend the time automating something you're going to get rid of anyways?

      Think, scalability, structural integrity of your system, maintainability, data integrity - then think, how easy is this to import into an RDBMS?

[reply]

In Section Seekers of Perl Wisdom