΢ͻӦ
WEIXINGJI YU YINGYONG
2000Vol.19No.5P.57-58




VFP60ʹOLEԶ
Ԫ
ժ ҪʹOLEԶVFPеExcelWordɱ
ؼʣOLE VFPݿӦ 
ָıVisual FoxPro60ݿӦóƱزٵVFPıȻѾܲʱûĸҪʱʹOLEԶVFPеExcelWordVFPݿӦΪͻExcelWordΪExcelǿݴܣWordǿͼĴܣʲôı񶼿ɺܺɡ򵥵˵VFPӦнݿеݽWord1
Ϊٶ1VFPĿйڿоѿ֧ݱkyjfdbfв¼ϼ1ʾ
1 оѿ֧
ĿһȶļȺϼ
в1500200020004000
г3000300040004000
15001200140001100
ϼơ

ϣVFPĿʱWordݱġоѿ֧ڴʱԶϼ󽫱Wordļ̡ĳWord01prgʵЩҪ󡣳CreateObjectWord½1Word壨ͨʽģ巽ʽɣñı⣬Ȼݿֶ¼ĸб1񣬴ݿtable1dbfȡøñļ¼ݱtable1dbfļ¼͵WordĸıУͬʱϼƣĿĺϼ--ȿ֧ĺϼԼȫ꿪֧ĺϼƣWordԼ޸templdocļ̡
Դword01prg
SET DEFAULT TO dmyvfpkwsjk
Clear
SET DEFAULT TO dmyvfpkwsjk
oleAppCREATEOBJECTWordApplication壩
Word
oleAppVisibleT ʾWord
oleAppDocumentsAdd һȱʡù
ĸ壨A4
oleAppDocumentsAddNomal壬T 
ʹģ崴1ĸ
塢ֺ
oleAppSelectionFontBoldT
oleAppSelectionFontSize18oleAppSelectionFontNameԲ

oleAppSelectionTypeTextݴѧ
о壩
oleAppSelectionTypeParagraph
oleAppSelectionTypeTextоʹñ1999
8¡壩
oleAppSelectionTypeParagraph 
oleAppDisplayAlertsF
oleAppSelectionFontSize12
oleAppSelectionFontName
ݱȡøñļ¼
use kyjfdbf
j1RECCOUNT1
Wordĸ1񣨱
ݱtable1dbfֶͬΪ7ȼ¼
11ͷ
oleAppActiveDocumentTablesAddoleAppSelection
Rangej126
loTableoleAppActiveDocumentTables1
дͷ
loTableCell11RangeInsertAfterĿ壩
loTableCell12RangeInsertAfterһȡ壩
loTableCell13RangeInsertAfterȡ壩
loTableCell14RangeInsertAfterȡ壩
loTableCell15RangeInsertAfterļȡ壩
loTableCell16RangeInsertAfter ơ壩
ݱtabledbfļ¼Wordĸı
УԶܷ֣
FOR i0 TO j11
go i1  i1¼
loTableCelli21RangeInsertAfterkyjfĿ
loTableCelli22RangeInsertAfterkyjfһȣ
loTableCelli23RangeInsertAfterkyjfȣ
loTableCelli24RangeInsertAfterkyjfȣ
loTableCelli25RangeInsertAfterkyjfļȣ
õĺϼ loTableCelli26RangeInsertAfterkyjfһȣkyjfڶȣkyjfȣkyjfļȣ
ENDFOR
ȷõĺϼ
hj10 һȵĺϼ
hj20 ڶȵĺϼ
hj30 ȵĺϼ
hj40 ļȵĺϼ
FOR i0 TO j1
go i1 i1¼
ȵĺϼ
hj1hj1kyjfһ  һȵĺϼ
hj2hj2kyjf  һȵĺϼ
hj3hj3kyjf  һȵĺϼ
hj4hj4kyjfļ  һȵĺϼ
ENDFOR
loTableCellj121RangeInsertAfter ơ壩
loTableCellj122RangeInsertAfterhj1
loTableCellj123RangeInsertAfterhj2
loTableCellj124RangeInsertAfterhj3
loTableCellj125RangeInsertAfterhj4
ȫõĺϼ
loTableCellj126RangeInsertAfterhj1hj2hj3hj4
OleAppActiveDocumentSaveAsDmyvfpkwsjktempdoc壩  Wordļ
OleAppQuit ˳Word
ڰװOffice97WIN9598NTVFP60ͨͼ1ΪеĽ

ͼ1 н
Ԫݴѧо550025
ο
1ԪVisual FoxPro 60еAutoCADӦʵ й19991018
2Microsoft CorporationMicrosoft Visual FoxPro60 ԱָϣϣԹ˾1998
3Bazian MVisual FoxPro60ʹֲᣮе ҵ磬1999
ոڣ19991110
