Office 2003 Add-in: Office Web Components :
site:
https://www.microsoft.com/en-us/download/details.aspx?id=22276download 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
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.