Re:Why are the Microsoft Office file formats so complicated?...
by intrasight on Sunday September 11, 2016 @12:27PM
(#12474104)
Close. You don't even need a Windows service. Just us a serialized queue using MSMQ. Write the queue listener in Javascript and register with COM+. Excel automation on the server is easy if you do it right, and impossible if you do it wrong.
[ Parent
| on HN ]
Re:Why are the Microsoft Office file formats so complicated?...
by teh_klev on Sunday September 11, 2016 @02:17PM
(#12474747)
Most of the devs I've encountered over the years who want to use Excel server side have never heard of queuing.
> Just us a serialized queue using MSMQ. Write the queue listener in Javascript and register with COM+.
Sure, but now you have MSMQ and COM+ to deal with...and debugging/fixing when it breaks (under load), or isn't secured properly.
The smart folks shell out for a copy of Aspose Cells and get the job finished on time.
Re:Why are the Microsoft Office file formats so complicated?...
by intrasight on Sunday September 11, 2016 @10:03PM
(#12476757)
Subsequent to my MSMQ approach, I did a project with Aspose. It's a pretty good toolkit, and I would recommend it over the MSMQ/COM+ complexity - Unless you absolutely have to automate Office, which is sometimes true.
On more recent projects in last ~12 months, I have used OpenXML.