Solved

Office Web Component (OWC) vs. Visual Studio Tools for Office, which is better?

Posted on 2009-04-14
9
1,258 Views
Last Modified: 2013-11-26
Which is better with regards to functionality?

I have a project before that requires creation of excel file as an output even if the client doesn't have an Excel application. This means it just saves a "file.xls", but you cannot open it since the environment don't have an Excel. Once the user installs an Excel application, the file "file.xls" can be opened.

I used OWC in Visual C# in the development of the project. Can I also use Visual Studio Tools for Office to satisfy the requirement?

Thanks.
0
Comment
Question by:katlin924
  • 6
  • 3
9 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 24145102
The Office Web Components have been discontinued in Office 2007, and are not included, except as a part of Office Project Server 2007.[1] However, they will still be available for download from Microsoft's website. Microsoft has not yet offered a complete replacement for the Office Web Components. However, programmers can use a combination of third party products, Excel Services or Visual Studio Tools for Office to provide similar functionality.

Source: http://en.wikipedia.org/wiki/Office_Web_Components
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 24145104
VSTO does offer advantages that aren't available in OWC such as embeddable objects in the document surface and bona-fide scalablility for server-side implementations. Outside of these two logical groups, the playing field is even. Remember, these two approaches target the same underlying platform.

A couple serious disadvantages to VSTO is that it requires the .NET framework on the client machine. Interactive office components that run in a web browser is not supported.

Consider your target audience and then make a decision.
0
 
LVL 2

Author Comment

by:katlin924
ID: 24145236
I already know the information you gave me. Thanks. I found it somewhere while researching about VSTO.

I just can't find if VSTO can support that kind of functionality. Do you know if it can? I don't have any idea on VSTO because I am only knowledgeable with OWC.
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 24145254
What exactly do you want to know from VSTO ?

http://weblogs.asp.net/sbehera/archive/2006/04/24/443847.aspx
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 2

Author Comment

by:katlin924
ID: 24145263
I want to know if VSTO can create an excel file output even if the client doesn't have an Excel application on their environment.

Thanks so much.
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 50 total points
ID: 24145285
Office Interop does require that Office be installed on the server.

In the more general case, you do not need Excel to create worksheets, and you should avoid any solution that requires it for web use. That includes office interop: it doesn't scale in a web environment.

See this question for more options:
http://stackoverflow.com/questions/150339/generating-an-excel-file-in-asp-net
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 24145292
0
 
LVL 2

Author Comment

by:katlin924
ID: 24145388
Thanks so much for the information.

I think I wrote a wrong description of client. The client I am referring is the customer client and not the client-server relationship. I'm sorry for the confusion.

Kindly confirm if my understanding is correct:

<b>Test Environment: </b>
with .NET Framework
no Excel Application


I can use VSTO to create a tool that can generate an excel file. If I deploy the software to the customers, the tool will successfully execute and an excel file can be generated but it is not possible to open it.
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 24147598
Here are some alternatives to create/read excel files without having excel installed

Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory
http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx

Generate Excel files without using Microsoft Excel
http://www.codeproject.com/KB/office/biffcsharp.aspx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to read all the sheets in excel 12 44
Receiving a string from a WebService Push 21 39
Excel printing page management 2 25
tricky if formula 2 0
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now