StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Automating excel on a server is not officially supported by Microsoft and I suggest you find an alternative. Microsoft has a lot of good information on this topic here: <a href="http://support.microsoft.com/kb/257757" rel="nofollow">http://support.microsoft.com/kb/257757</a>.</p> <blockquote> <p>All current versions of Microsoft Office were designed, tested, and configured to run as end-user products on a client workstation. They assume an interactive desktop and user profile. They do not provide the level of reentrancy or security that is necessary to meet the needs of server-side components that are designed to run unattended.</p> <p><strong>Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.</strong></p> <p>If you are building a solution that runs in a server-side context, you should try to use components that have been made safe for unattended execution. Or, you should try to find alternatives that allow at least part of the code to run client-side. If you use an Office application from a server-side solution, the application will lack many of the necessary capabilities to run successfully. Additionally, you will be taking risks with the stability of your overall solution.</p> </blockquote> <p>They even offer suggestions on how to avoid using them:</p> <blockquote> <p>Most server-side Automation tasks involve document creation or editing. Office 2007 supports new Open XML file formats that let developers create, edit, read, and transform file content on the server side. These file formats use the System.IO.Package.IO namespace in the Microsoft .NET 3.x Framework to edit Office files without using the Office client applications themselves. This is the recommended and supported method for handling changes to Office files from a service.</p> </blockquote> <p>They also have tutorials on using the APIs:</p> <p><a href="http://msdn.microsoft.com/en-us/library/bb739834.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/bb739834.aspx</a></p> <p><a href="http://msdn.microsoft.com/en-us/library/bb727373.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/bb727373.aspx</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload