Solved

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

Posted on 2009-04-14
9
1,246 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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
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…

747 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

11 Experts available now in Live!

Get 1:1 Help Now