Open XML SDK 2.0

I am having the usual issue of when I export a file to Excel using ASP.Net and I open the file I get the file open warning. One option is to use Open XML SDK 2.0. When I get the website up and running we wil have literally hundreds of users exporting content.

So my question is with OPEN XML how does it get installed when setting up the website should I use it in the web app.
Who is Participating?
jasnakozeljConnect With a Mentor Commented:
Open XML SDK is a document/spreadsheet file parsing library that processes documents on a file format level. This is nothing like Office COM which is just the interface to an Office Application (like MS Word or Excel). Open XML SDK is the preferred way to process and manipulate Office formats because it does not rely on MS Office applications and is 100% pure .NET library. Installing this library is as simple as deploying it along other dll files of your web application. There are no dependencies others than assemblies of .NET base class libraries. The only drawback of using Open XML SDK (which is a major one) is the fact that by using Open XML SDK you don't manipulate Document Object Model but rather document package/file structure which requires much more knowledge (of Open XML standard) than working with Office COM. Of course, there are 3rd party libraries around that mimic Office COM (DOM APIs) without relying on MS Word. As far as I know these are all commercial but it is usually cheaper to buy such a component then putting weeks or moths of effort to create a buggy insufficient solution.
Craig WagnerConnect With a Mentor Software ArchitectCommented:
You don't need to install it on your web server. Set a reference to it, ensure it's set to copy the assembly local, and then it'll be in your "bin" folder along with all your other assemblies and just be deployed along with everything else.
I'm not a big expert in the subject, but based on my experience with the OpenXML, it's a pretty good approach to create documents run-time.
I did not try to create excel files, only word ones, but I think it should be down with the same good speed. Also, AFAIK, the Open XNL SDK does not require office to be installed, that's good.
So, I hope there's no hidden pitfalls and it could be used in a web application.
IdaracAuthor Commented:
So if I install the website using OpenXML will the users of the website have to download anything in order to export from the website? Or can they just login to the website and run it?
IdaracAuthor Commented:
Thank you both
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.