4 ms·
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 automa
by intrasight 10y ago
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.
- teh_klev 10y agoMost 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.
- intrasight 10y agoSubsequent 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.