Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Edit excel file in form VFP
Message
From
16/06/2016 19:32:09
 
 
To
16/06/2016 06:32:01
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Miscellaneous
Thread ID:
01637287
Message ID:
01637444
Views:
111
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform