Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Edit excel file in form VFP
Message
From
19/07/2016 11:32:35
 
 
To
16/06/2016 19:32:09
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:
01638514
Views:
180
>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!
Previous
Reply
Map
View

Click here to load this message in the networking platform