Re^2: How can I create MS Word 2013 documents using Perl?

It has been a good (or bad) few years since I dealt with this sort of thing, but my experience then was that OLE into Word was on the fragile side. It would probably have been perfectly acceptable if there had been someone at the keyboard when the document was being generated, to deal with any random modal dialog Word decides to display. But in my case, the Word document was being generated overnight on an unattended server, and we found out about dialogs when users complained that they did not get their reports. We converted from OLE and Word to custom- (and probably badly- ) written Rich Text to deal with it. We actually called the files .rtf, and Word had no problem opening them.

I reiterate, though, that this was a few years back. I have no information on whether Word is better at this sort of thing these days.

Comment on Re^2: How can I create MS Word 2013 documents using Perl?

Replies are listed 'Best First'.
Re^3: How can I create MS Word 2013 documents using Perl? by locked_user sundialsvc4 (Abbot) on Jul 30, 2014 at 19:21 UTC
Dialogs are still a serious problem with Word and other applications. If you are able to generate, reliably and accurately, a “transportable” format that you know your version will accept, then that is definitely a good alternative. It will probably be best to let the Microsoft application itself generate the document that can then be used as a programmatic basis for what comes next, e.g. by turning it into a Template or something like that. But it can still turn out to be a crap-shoot. If you do use a Perl module to generate the base document, I definitely would shoot for one of these transportable formats, versus trying to emulate Microsoft’s file-madnesses ... and in any case I would be sure to use the most-current and most-recently-updated CPAN module that you can possibly lay your hands on, whatever one that turns out to be. If it is “a few years old,” even, there could be problems. Test the holy-hell out of whatever you do finally come up with, and then pray that Redmond will smile.
Re^4: How can I create MS Word 2013 documents using Perl? by exixx (Beadle) on Jul 31, 2014 at 16:22 UTC
When using OLE to more recent MS Office versions, it's usually most helpful to turn off all the warnings before operating and then turn them back on when done. I've found this to be useful for preventing popup dialogs. Got to remember to turn them back on though...	[reply]