OWC Resources

The Office Web Components consist of the Spreadsheet Component, the Chart Component, the PivotTable Component, and the Data Source Component. Each includes Excel-like functionality and user interfaces. By using Office Web Components, users can publish data to the Web and preserve much of the power and interactivity of Excel.

Office Web Components build upon the Office user experience. This means that an Office Web Component spreadsheet, chart, or PivotTable will have a very similar user interface as a desktop-based Excel spreadsheet, chart, or PivotTable. However, Office Web Components offer much more than a chart on a Web page. This fully interactive technology enables users to do sophisticated data analysis and reporting right in the browser

Please find the below link to download Office Web Components

https://www.microsoft.com/downloads/details.aspx?familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

Newsgroups dedicated to the Office Web Components

   microsoft.public.office.developer.web.components

Books dedicated to the Office Web Components

  1. The Microsoft Office Web Components Black Book with .NET (Alvin Bruney 2005)
  2. Professional Asp Programming Guide for Office Web Component: With Office 2000 and Office XP(Qimao Zhang 2001)
  3. Programming Microsoft Office 2000 Web Components(Dave Stearns 2000)

 

Help Files for OWC

By default, the Help files for Office 2003 Web Components are installed in the

%SystemDrive%:\Program Files\Common Files\Microsoft Shared\Web Components\11\1033

folder. This folder has the following help files.

  1. OWCDCH11.chm       Chart component design-time reference 
  2. OWCDPL11.chm        PivotTable component design-time reference 
  3. OWCDSS11.chm       Spreadsheet component design-time reference 
  4. OWCFUN11.chm        Spreadsheet component built-in function reference 
  5. OWCVBA11.chm        Programming reference for all components (List all the properties, method and events that are supported by OWC

OWC Visual Basic Reference

https://www.microsoft.com/downloads/details.aspx?familyid=1192DEA9-CF5C-4DD7-8505-8074745A6D11&displaylang=en

OWC langauge reference

https://msdn.microsoft.com/office/understanding/owc/default.aspx

https://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/octocwhatsnew.asp

OWC 9

https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2kta/html/ofintrowbcom.asp

OWC preview

https://msdn.microsoft.com/library/default.asp?url=/seminar/mmcfeed/mmcdisplayfeed.asp?lang=en&product=103335&audience=100402

OWC Book excerpt

https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnowcbk/html/odc_chap4owc.asp

OWC and VB

https://support.microsoft.com/default.aspx?scid=kb;en-us;235542

Deployment

https://support.microsoft.com/default.aspx?scid=kb;en-us;828950

O.W.C. Outside of Internet Explorer

https://support.microsoft.com/kb/q231094/

Security vulnerability white paper

https://www.microsoft.com/technet/security/bulletin/MS02-044.mspx

OWC limitations

https://support.microsoft.com/default.aspx?scid=kb;EN-US;317316

Registration free COM components

https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/whypriinterop.asp

Connecting to XML Web Services

https://support.microsoft.com/?id=315695

OWC PIA's

https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp

Interactive usage

https://support.microsoft.com/default.aspx?scid=kb;en-us;555094

https://support.microsoft.com/default.aspx?scid=kb;EN-US;286278

Handling events for the O.W.C.

https://support.microsoft.com/?id=328275

https://support.microsoft.com/kb/319342/EN-US/

https://support.microsoft.com/kb/319341/EN-US/

https://support.microsoft.com/kb/319559/EN-US/

Licensing

https://msdn.microsoft.com/library/default.asp?url=/workshop/components/activex/licensing.asp

https://support.microsoft.com/kb/q243006/

https://support.microsoft.com/kb/q243006/

https://support.microsoft.com/default.aspx?scid=kb;en-us;555094

https://support.microsoft.com/default.aspx?scid=kb;en-us;555075

https://support.microsoft.com/default.aspx?scid=https://support.microsoft.com:80/support/kb/articles/q288/7/29.asp&NoWebContent=1

https://www.microsoft.com/office/previous/xp/developer/platform/owcfaq.asp

https://support.microsoft.com/default.aspx?scid=kb;en-us;243006

Charting Component

Dynamic Chart Generation

https://support.microsoft.com/default.aspx?scid=kb;EN-US;244049

Combination Charts

https://support.microsoft.com/default.aspx?kbid=286211

Streaming charts to browser

https://support.microsoft.com/default.aspx?scid=

https://support.microsoft.com:80/support/kb/articles/q264/0/96.asp& NoWebContent=1

Server-side chart generation

https://support.microsoft.com/default.aspx?scid=kb;EN-US;244049

Binding charts to datasources

https://support.microsoft.com/?id=288907

Custom drawing

https://support.microsoft.com/default.aspx?scid=kb;en-us;555162

Null data points

https://support.microsoft.com/default.aspx?scid=kb;en-us;Q286317

Binding charts to xml datasource

https://support.microsoft.com/default.aspx?scid=https://support.microsoft.com:80/support/kb/articles/q286/2/12.asp&NoWebContent=1

Pivot Table Component

Pivot Table Cloned Member issue resolution

https://support.microsoft.com/kb/q301582/

Extracting aggregates values

https://support.microsoft.com/kb/q286210/

Retrieving filtered members

https://support.microsoft.com/kb/q302101/

OWC installation issues

https://support.microsoft.com/default.aspx?scid=kb;en-us;288739

Pivot Table List View Programming

https://office.microsoft.com/en-us/assistance/HA010345791033.aspx

Pivot Table List in Access form

https://support.microsoft.com/?kbid=298764

Pivot Table rendering

https://support.microsoft.com/default.aspx?scid=kb;EN-US;294798

Pivot Table hyperlink support

https://support.microsoft.com/?id=317630

Pivot Table code and VB

https://support.microsoft.com/kb/235542

OLAP

https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_XLOWCOlap.asp

https://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/