Asked by:

OWC and 64-bit Office

Question

I'm developing an application in VSTO using VB.net. My application has the Microsoft Office Web Components 11 (OWC) add-in. Unfortunately, the OWC control does not work for end-users running on 64-bit Office. I've done some research and found out that OWC
is written for 32-bit Office and will not work for 64-bit version.

May I know the current development of OWC and when will Microsoft release OWC that works for 64-bit Office?

All replies

Would your please tell me which project template you used to develop your project? It's based on my experience that your issue is a ASP.NET project, is it right? If it is, I think we need find out some work round to instead of OWC due to it is too older
to access Office 2010's suite. You might clarify your requires here, let's see whether I can help you.

I'm currently developing an application which works with Excel. By using WinForm, I wish to use OWC control to display a table on an Excel spreadsheet to the Form. It works well with 32-bit users. Unfortunately, OWC seems to be incompatible with 64-bit Office.
Is there another control that allows me to display a table on WinForm?

There is no announced plan to continue to maintain or update OWC. It is no longer distributed with Office products, nor otherwise available except as a special download from MSDN.

OWC includes the spreadsheet control, the chart control, and the pivot table control. Which of those are you using? They are 32-bit controls and there may be alternative controls that would work on your WinForm.

I know of no alternative control. By querying in bing for "spreadsheet control" you will see many pages of links to conent onthe spreadsheet control. Almost all of them discuss the OWC control. You may find a link to content about a diffeent control
is you scroll through the pages in the return set.

Considering what you have said here about your project how does a VSTO project for Excel interact with a spreadsheet embedded in a WinForm? Could you use something like a datagrid control which has a datasource as an existing Excel workbook? Are you building
two projects - one as using the VSTO with Excel 2010 and another using the Windows Form template?

Another consideration about your project - will you miss a substantial market segment if your VSTO project is developed for 32-bit Excel only?

I'm building only one project - using VSTO with Excel 2010 to build a WinForm that interacts with an Excel document. It will be good if my application works for both 32 and 64 bit Office. However, my main concern is to be able to display tables on WinForm.
Not only that, it has to be editable and be able to send input values back to Excel. Excel will do some complex calculations and send the results back to the same table on WinForm. It's something that's not feasible using the textbox control because my table
contains a lot of cells.

I'm wondering if there exists such control described above other than the OWC spreadsheet?

There is a variety of ways to address your design aim. The following list of links to content is about a portion of the ways. Please consider whether any of the suggested approaches will give you the answer you want.