Solved

Open XML SDK 2.0

Posted on 2014-02-25
5
411 Views
Last Modified: 2014-03-06
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.
0
Comment
Question by:Idarac
5 Comments
 
LVL 21

Assisted Solution

by:Craig Wagner
Craig Wagner earned 250 total points
ID: 39887395
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.
0
 
LVL 18

Expert Comment

by:zc2
ID: 39887403
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.
0
 
LVL 1

Author Comment

by:Idarac
ID: 39889231
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?
0
 
LVL 1

Accepted Solution

by:
jasnakozelj earned 250 total points
ID: 39900648
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.
0
 
LVL 1

Author Closing Comment

by:Idarac
ID: 39910994
Thank you both
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question