none
OWC and 64-bit Office

    Domanda

  • Hi all,

    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?

    Regards,

    Chong Yong
    Associate
    NMG Financial Services Consulting, Malaysia

    venerdì 6 aprile 2012 04:44

Tutte le risposte

  • Hi ChongYong,

    Thanks for posting in the MSDN Forum.

    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.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    lunedì 9 aprile 2012 02:16
    Moderatore
  • Hi Chong,

    I will involve some experts into this issue to see whether they can help you. There might be some time delay, thanks for your patience.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    venerdì 13 aprile 2012 06:21
    Moderatore
  • Hi Tom,

    My project template is Excel 2010 Workbook from MS Visual Studio.

    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?

    Regards,
    Chong Yong

    venerdì 13 aprile 2012 07:25
  • Hi Tom,

    Thanks for taking your time to look into my issue. Looking forward to your reply.

    Regards,
    Chong Yong

    venerdì 13 aprile 2012 07:26
  • Hi Chong Yong,

    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.

    Regards,
    Chris Jensen
    Senior Technical Support Lead


    Chris Jensen

    venerdì 13 aprile 2012 17:37
    Moderatore
  • Hi Chris,

    I'm using the spreadsheet control from OWC only. Is there any alternative controls which I can use to display a table in WinForm that works for both 32-bit and 64-bit Office?

    Regards,
    Chong Yong

    lunedì 16 aprile 2012 01:50
  • Hi Chong Yong,

    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?

    Looking forward to more of an explanation about your project.

    Regards,
    Chris Jensen
    Senior Technical Support Lead


    Chris Jensen

    mercoledì 18 aprile 2012 18:01
    Moderatore
  • Hi Chris,

    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?

    Regards,
    Chong Yong

    venerdì 20 aprile 2012 04:59
  • Hello Chong Yong,

    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.

    Data Binding and Windows Forms
    http://msdn.microsoft.com/en-us/library/c8aebh9k.aspx
    (Complex Data binding lists several controls)

    SSAS 2008: Excel as Data Source - Worksheets in the Data Source View?
    http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/50091c40-631f-4958-a15f-0e8c54a37198/

    need help writing to excel (OLEDB) windows forms clickonce app ...
    http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/be587257-eac1-4952-82e8-dab1bd02983e/
    (this content suggests using DSOFramer.ocx.  That control is no longer available, and is not supported.)

    Consider using Excel Services. This article discusses this technique:
    How to use Excel Services as a Data source in PerformancePoint ...
    http://blogs.msdn.com/b/performancepoint/archive/2007/07/12/how-to-use-excel-services-as-a-data-source.aspx

    How to import spreadsheet/excelsheet programmatically into ...
    http://social.msdn.microsoft.com/forums/en-us/sharepointdevelopment/thread/C45D5EC1-7310-4733-A4F3-6F7E0A6AF0E4/
    (Refers to content on CodePlex)

    DataGridView.DataSource Property (System.Windows.Forms)
    http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.datasource.aspx

    GridView Class
    http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.aspx

    Grid view
    http://en.wikipedia.org/wiki/Datagrid

    Regards,
    Chris Jensen


    Chris Jensen

    venerdì 20 aprile 2012 14:10
    Moderatore