word 域引用excel数据word 域引用excel数据.docx
- 文档编号:29412346
- 上传时间:2023-07-23
- 格式:DOCX
- 页数:17
- 大小:24.62KB
word 域引用excel数据word 域引用excel数据.docx
《word 域引用excel数据word 域引用excel数据.docx》由会员分享,可在线阅读,更多相关《word 域引用excel数据word 域引用excel数据.docx(17页珍藏版)》请在冰豆网上搜索。
word域引用excel数据word域引用excel数据
word域引用excel数据(word域引用excel数据)
链接域引用命令
{链接Excel表。
8E:
\\\\\\办公学业水平考试2013年12月\\证书\\2013年12月学考优秀名单.xls名单!
R2C2:
r6c2\\T*MERGEFORMAT}
注意使用时要用字插入域命令,不能手工录入。
域代码:
链接域
全部显示
全部隐藏{链接类名“filename”[placereference][开关]}
将从其他应用程序复制来的信息通过OLE(OLE:
一种可用于在程序之间共享信息的程序集成技术。
所有办公室程序都支持OLE,所以可通过链接和嵌入对象共享信息。
)链接到源文件。
从其他应用程序复制信息,并用”编辑”菜单中的”选择性粘贴”命令将其粘贴到字文档时,微软Word就会插入此域。
安全性任何阅读文档的人都可以看到域代码,因此请确保域代码中放置的信息不是机密信息。
说明
类名
链接信息的应用程序类型。
例如,对于微软Excel图表,类名为“Excel图表。
8字根据源应用程序确定此项信息。
”。
“文件名”
源文件的名称和位置。
如果路径包含带空格的长文件名,请将其包含在引号中。
将单反斜杠替换为双反斜杠来指定路径(路径:
操作系统用来定位文件夹或文件的路径,例如C:
\财务\3家。
医生),例如:
“C:
\\\\\\RFPMSOfficeExcelXLS\\预算。
”
placereference
标识源文件被链接的部分。
如果源文件是微软Excel工作簿,引用可以是单元格引用或命名区域。
如果源文件是字文档,引用为书签(书签:
以引用为目的在文件中命名的位置或文本选定范围。
书签标识文件内您以后可引用或链接到的位置。
)。
开关
\
自动更新链接域,删除此开关则使用手动更新。
B
链接对象作为位图插入。
“D
图形数据不随文档保存,以减小文件长度。
\f
使链接对象(链接对象:
该对象在源文件中创建,然后被插入到目标文件中,并且维持两个文件之间的连接关系。
更新源文件时,目标文件中的链接对象也可以得到更新按照下列参数之一所指定的特定方式进行格式更新。
)。
开关值指定
0保持源文件的格式
1不支持
2匹配目标文档的格式
3不支持
4如果源文件是Excel工作簿,则保持源文件的格式
5如果源文件是Excel工作簿,则匹配目标文档的格式
\H
以HTML(超万维网文档所用的标准标记语言。
HTML使用标记来指定Web浏览器对文字和图形等网页元素的显示方式以及对用户操作的响应方式文本格式插入链接对象。
)。
P
Thelinkobject(thelinkobject:
theobjectiscreatedinthesourcefile,theninsertedintothetargetfile,andmaintainstheconnectionbetweentwofiles.Whenupdatingthesourcefile,thelinkobjectinthetargetfilecanalsobeupdatedInsertaspicture.
\r
RTF(RTF:
)isusedtotransferfiletypeswithformattedtextdocumentsacrossapplications,andevenifapplicationsrunondifferentplatformssuchasIBMandMacintosh,fileexchangecanbeachievedFormatinsertlinkobject.
\t
InsertlinkobjectsinYISHIONtextformat.
\u
ThelinkobjectisacharacterencodingstandarddevelopedbyUnicode(Unicode:
UnicodeConsortium).Thestandardusesmultiple(YuYi)bytesrepresentingeachcharacterandimplementstheuseofasinglecharactersetrepresentingalmostallwrittenlanguagesintheworld.)Textinsertion.
Sample
ThefollowingexampleinsertsacellregionfromtheMicrosoftExcelworksheet.The\aswitchensuresthattheinformationintheWordwillalsobeupdatedwhentheworksheetischangedinMicrosoftExcel:
{LINKExcel.Sheet.8,"C:
\\MyDocuments\\Profits.xls","Sheet1","R1C1:
R4C4","\a","\p",}
ApplicationandexplanationofWorddomain3
Intheseventhchapter?
3_explainthelinkandreferencedomaindomain
Ioriginal,reproducedpleasespecify:
I.automaticAutoTextdrawings
Methodofuse:
AutoTextEntry^{AutoText}
Insertsthespecifiedautomaticdiagrambook.Wordcanautomaticallyupdatetheentryinthedocumentifitisnotinsertedintoanautomaticentry,butinsteadusestheAutoTextfield,andwhenlaterredefinestheentryoftheautomaticdrawingentry.Firstdefinetheentryoftheautomaticgraphentry,andtheninsertaAutoTextfieldatthepointwheretheentryistobeinserted.Ifyouupdatetheentriesfortheautomaticdrawingentry,alsoupdatetheAutoTextfieldinthedocumenttoreflecttheentryupdate.
Themeaningofparameters:
AutoTextEntrytheAutoTextentry.
Example:
inthispaper,author^{AutoText}
Astheauthorofthisarticle:
xqd
Two,AutoTextListdynamicautomaticpicturebook
Methodofuse:
^{AutoTextLIST"LiteralText"\s[StyleName]\t"TipText"]}
Whentheuserclickstherightmousebutton,theshortcutmenufortheentryoftheautomaticdrawingentryisdisplayed,andthedefaultdisplaytextbecomestheentryintheuser'sselectedautomaticdrawingbook.Thelistchangeswiththestylethatshouldbeusedfortheautomaticentry.
Themeaningofparameters:
"LiteralText"displaysthetextbydefault,thetextdisplayedinthedocumentbeforetheuserdisplaysthedropdownmenu.Ifspacesarepresent,quotetheminquotationmarks.
StyleNamedisplaystheautomaticentrynameoftheentryinthelist.Thisstylecanbeaparagraphstyleoracharacterstyle.Ifthenameofthestylecontainsspaces,usequotationmarks.
"TipText"thetextdisplayedbythescreenpromptwhenthemousepointerpointstotheresultofthefield.Pleasequotethetextinquotationmarks.
Theswitch:
\sspecifiesthatthelistcontainsentriesbasedonaparticularstyle.Whenthisswitchisnotavailable,theautomaticentryofthecurrentparagraphstyleisdisplayed.Ifthecurrentstyledoesnothaveacorrespondingentry,allautomaticentriesaredisplayed.
\tspecifiesthetextdisplayedinthescreenprompttoreplacethedefaultprompttext.
3cases:
{AutoTextList"defaulttext"\s\t"right-click",youcanchangeentriesfortheautomaticdrawingbook.}
Showasdefaulttext
Three,Hyperlinkhyperlink
Methodofuse:
HyperLink^{[Switches}]"Filename"
Hyperlinksarea"hotspot"thatcanjumptootherlocationsfromhere.Thispositionmayincludeotherfilesontheharddiskornetwork(suchasMicrosoftWordMicrosoftExceldocumentorworksheet)andInternetaddress(suchas),bookmarks(tomanuallyinsertbookmarksorslides,seenote).Thedomaincontainsprompttext,whichisusuallyblueandunderlined.Theusercanclickheretojumptothespecifiedlocation.Youcaninserthyperlinksbyclickingthehyperlinkcommandintheinsertmenu.TheGoToButtonjumpfield(atforty-thirdpages)canalsoachievethisfunction.
Themeaningofparameters:
"Filename"thedestinationofthejump.Ifitcontainsalongerspacefilename,pleasequoteitinquotationmarks.ReplacestheSLRslashwithadoublebackslashpath.Forexample:
"C:
\\MyDocuments\\Manual.doc."".ForInternetaddresses,protocolsandsyntaxlikeURLareincluded,forexample:
"Http:
//and""
Theswitch:
\hspecifiesthatnolinksareaddedtothehistorylist.
\lspecifiesthelocationinthefiletowhichthishyperlinkjumpsto,suchasbookmarks.
\maddscoordinatestotheserversideimagemaphyperlink
\ndestinationlocationinformationopensinnewwindow.
\sspecifiesthejumpposition,butthislocationisnotnamed.Thehyperlinkcreatedbydragginginformationwillappearinthisswitch.ThereisnoswitchinthelistofswitchesintheinsertfieldmenuintheInsertmenu.Youcannotinsertitintodomaincodemanually.
\tspecifiesthedestinationofthelinkredirection.ThereisnoswitchinthelistofswitchesintheinsertfieldmenuintheInsertmenu.Youcannotinsertitintodomaincodemanually.
Theexample:
1.jumptothedomainbase,theroleofthedomainsectionofthelinkexample.
"2.fieldcodeandtext".Thefinalbudgetoftheprojecthasbeendetermined.Click{HyperLink'C:
\\MyDocuments\\budget.Xls}fordetails."Theresultisasfollows:
"Thefinalbudgetoftheprojecthasbeendetermined.Clickonthe1997budgetformoredetails."
ClickingthebluetextopenstheworksheetintheMyDocumentsfoldercalledbudget.Xls.Hyperlinkdisplaystextas"1997budget"andisnotincludedindomainsyntax.Youcantypenewcontenttoreplacetheprompttextofthedomain.
*Note:
whentojumptoabookmarkthatplace,moreconvenienttouseinthePageRefdomainpagetwenty-sixthpagebookmarks.
Four,IncludePictureinsertgraphics
Methodofuse:
IncludePicture^{[Switches}]"FileName"
ToinserttheIncludePicturefield,pointthepointertothepicturesubmenuintheInsertmenu,clickthefilecommand,andthenselectthelinkfilecheckbox.
Inserttheobjectrepresentedbythebookmark,seetheBookMarkandRefdomains(onpagetwenty-seventh).
Themeaningofparameters:
"FileName"graphicfilenameandlocation.Ifitcontainsalongerspacefilename,pleasequoteitinquotationmarks.ReplacestheSLRslashwithadoublebackslashpath.Forexample:
"C:
\\Manual\\Art\\Art22.bmp.""
Theswitch:
\cConverteridentifiesthedesiredgraphicsfilter.Thefileextension.Fltisnotrequiredinthegraphicsfiltername.Forexample,youwanttousethegraphicsfilterPictim32.flt,simplytype"pictim32"".
\dgraphicsdataisnotsavedwiththedocumenttoreducethefilelength.
Note3:
TheIncludePicturedomaincanbeusedinsteadoftheIMPORTdomainusedinthepreviousWordversion.IfyouopenadocumentthatcontainstheIMPORTdomain,thisdomainisstillvalidinthedocument.
Ifyoudouble-clickthefigureinsertedintheIncludePicturefield,Worddisplaysthepicturetoolbar.Ifyoudonotusethe"picture"toolbartochangegraphics,youcaneditthegraphicsinthecreationoftheapplication,andthenupdatethedomaininWord.
IftheWorddoesnotrecognizethegraphicsfileformat,pleasechecktheinsertpicturedialogbox("filetype"pointer"insert"menuinthe"picture"menu,andthenclickfromfile"command).Thegraphicsfiltersinstalledinthesystemarelistedinthebox.
"Example:
thecurrentdirectoryofthisdocumentmustbeincludedinthefile"Next.gif"tocorrectlydisplaythefollowingexample.
TheNext.gif{IncludePictureMergeFormat}fordisplay:
.
Five.IncludeTextinsertstextandgraphicsinotherdocuments
Methodofuse:
^{IncludeTextFileName[BookMark}]][Switches
Insertsthetextandgraphicscontainedinthenameddocument.Theentiredocumentcanbeinserted;ifitisanWorddocument,onlypartsreferencedbythebookmarkcanbeinserted.
Insertabookmarkrepresentingthisarticle,seetheBookMarkandRefdomains(onpagetwenty-seventh).
Themeaningofparameters:
"FileName"documentnameandlocation.Ifitcontainsalongerspacefilename,pleasequoteitinquotationmarks.ReplacestheSLRslashwithadoublebackslashpath.Forexample:
"C:
\\MyDocuments\\Manual.doc.""
TheBookMarkbookissignedtotheparttobeincludedinthedocument.Tomanuallyinsertbookmarksandnotes.
Theswitch:
\cClassName:
classname.
\:
Wordisforbiddentoupdatethefieldsinsertedintothete
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- word 域引用excel数据word 域引用excel数据 引用 excel 数据