Solved

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

Posted on 2009-04-14
9
1,280 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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
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
 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

685 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