>Office 2003 Add-in: Office Web Components :
>site:
https://www.microsoft.com/en-us/download/details.aspx?id=22276>download and install owc11.exe (18038 kO).its an addin for office2003 (or 2007) (must installed before).
>activeX oleclass= OWC11.Spreadsheet.11
>
>it destined to office 2003 , i have office2007 installed ans it works within as well also.
>if you open vfp menu/options/controls you can see owc11.Spredsheet.11 installed (check it and save dialog as default).then you can embed it on a form easily as activeX.
>you can try this test code after installing owc11.exe
>
>
>Publi yform
>yform=Newobject("asup")
>yform.Show
>Read Events
>Retu
>*
>Define Class asup As Form
> AutoCenter=.T.
> Top = 0
> Left = 0
> Height = 500
> Width = 800
> Caption = "Embed Excel sprdSheets on a form with owc11 addin"
> Name = "Form1"
>
>
> Add Object olecontrol1 As OleControl With ;
> Oleclass="OWC11.Spreadsheet.11", ;
> Anchor=15,;
> Top = 0, ;
> Left = 0 , ;
> Height = 500-10 , ;
> Width = 800-10, ;
> Name = "Olecontrol1"
>
> Procedure Destroy
> Clea Events
> Endproc
>
>Enddefine
>*
>*-- EndDefine: asup
>
>there is many buttons (commands,export to excel...save...)---see the photo attached
>read the CHM help in owc11 toolbar.
>Note: cannot open directly an excel file but can paste any excel selection
>can export the spredSheet in excel and save it
>
>-Microsoft Office Web Components are a collection of Component Object Model (COM) controls for publishing spreadsheets, charts, and databases to the Web.
Thanks!