Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-04-14
9
Medium Priority
?
1,344 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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…

886 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