《word 域引用excel数据（word 域引用excel数据）.doc》由会员分享，可在线阅读，更多相关《word 域引用excel数据（word 域引用excel数据）.doc（28页珍藏版）》请在三一文库上搜索。
1、word 域引用excel数据（word 域引用excel数据）链接域引用命令链接Excel表。8 E： 办公学业水平考试2013年12月证书 2013年12月学考优秀名单.xls名单！R2C2：r6c2 T * MERGEFORMAT 注意使用时要用字插入域命令，不能手工录入。域代码：链接域全部显示全部隐藏链接类名“filename” placereference 开关 将从其他应用程序复制来的信息通过OLE（OLE：一种可用于在程序之间共享信息的程序集成技术。所有办公室程序都支持OLE，所以可通过链接和嵌入对象共享信息。）链接到源文件。从其他应用程序复制信息，并用”编辑”菜单中的”选择性粘
2、贴”命令将其粘贴到字文档时，微软Word就会插入此域。安全性任何阅读文档的人都可以看到域代码，因此请确保域代码中放置的信息不是机密信息。说明类名链接信息的应用程序类型。例如，对于微软Excel图表，类名为“Excel图表。8字根据源应用程序确定此项信息。”。“文件名”源文件的名称和位置。如果路径包含带空格的长文件名，请将其包含在引号中。将单反斜杠替换为双反斜杠来指定路径（路径：操作系统用来定位文件夹或文件的路径，例如C：财务 3家。医生），例如：“C： RFP MSOffice Excel XLS 预算。”placereference标识源文件被链接的部分。如果源文件是微软Excel工作簿，引
3、用可以是单元格引用或命名区域。如果源文件是字文档，引用为书签（书签：以引用为目的在文件中命名的位置或文本选定范围。书签标识文件内您以后可引用或链接到的位置。）。开关自动更新链接域，删除此开关则使用手动更新。B链接对象作为位图插入。“D图形数据不随文档保存，以减小文件长度。 f使链接对象（链接对象：该对象在源文件中创建，然后被插入到目标文件中，并且维持两个文件之间的连接关系。更新源文件时，目标文件中的链接对象也可以得到更新按照下列参数之一所指定的特定方式进行格式更新。）。开关值指定0保持源文件的格式1不支持2匹配目标文档的格式3不支持4如果源文件是Excel工作簿，则保持源文件的格式5如果源文件
4、是Excel工作簿，则匹配目标文档的格式 H以HTML（超万维网文档所用的标准标记语言。HTML使用标记来指定Web浏览器对文字和图形等网页元素的显示方式以及对用户操作的响应方式文本格式插入链接对象。）。PThe link object (the link object: the object is created in the source file, then inserted into the target file, and maintains the connection between two files. When updating the source file, the li
5、nk object in the target file can also be updated Insert as picture.rRTF (RTF:) is used to transfer file types with formatted text documents across applications, and even if applications run on different platforms such as IBM and Macintosh, file exchange can be achieved Format insert link object.tIns
6、ert link objects in YISHION text format.uThe link object is a character encoding standard developed by Unicode (Unicode:Unicode Consortium). The standard uses multiple (Yu Yi) bytes representing each character and implements the use of a single character set representing almost all written languages
7、 in the world.) Text insertion.SampleThe following example inserts a cell region from the Microsoft Excel worksheet. The a switch ensures that the information in the Word will also be updated when the worksheet is changed in Microsoft Excel:LINK Excel.Sheet.8, C:My DocumentsProfits.xls, Sheet1, R1C1
8、:R4C4, a, p,Application and explanation of Word domain 3In the seventh chapter? 3_ explain the link and reference domain domainI original, reproduced please specify: http:/ automatic AutoText drawingsMethod of use: AutoTextEntry AutoTextInserts the specified automatic diagram book. Word can automati
9、cally update the entry in the document if it is not inserted into an automatic entry, but instead uses the AutoText field, and when later redefines the entry of the automatic drawing entry. First define the entry of the automatic graph entry, and then insert a AutoText field at the point where the e
10、ntry is to be inserted. If you update the entries for the automatic drawing entry, also update the AutoText field in the document to reflect the entry update.The meaning of parameters: AutoTextEntry the AutoText entry.Example: in this paper, author AutoTextAs the author of this article: xqdTwo, Auto
11、TextList dynamic automatic picture bookMethod of use: AutoTextLIST LiteralText s StyleName t TipTextWhen the user clicks the right mouse button, the shortcut menu for the entry of the automatic drawing entry is displayed, and the default display text becomes the entry in the users selected automatic
12、 drawing book. The list changes with the style that should be used for the automatic entry.The meaning of parameters:LiteralText displays the text by default, the text displayed in the document before the user displays the drop down menu. If spaces are present, quote them in quotation marks.StyleNam
13、e displays the automatic entry name of the entry in the list. This style can be a paragraph style or a character style. If the name of the style contains spaces, use quotation marks.TipText the text displayed by the screen prompt when the mouse pointer points to the result of the field. Please quote
14、 the text in quotation marks.The switch:s specifies that the list contains entries based on a particular style. When this switch is not available, the automatic entry of the current paragraph style is displayed. If the current style does not have a corresponding entry, all automatic entries are disp
15、layed.t specifies the text displayed in the screen prompt to replace the default prompt text.3 cases:AutoTextList default text s t right-click, you can change entries for the automatic drawing book.Show as default textThree, Hyperlink hyperlinkMethod of use: HyperLink Switches FilenameHyperlinks are
16、 a hot spot that can jump to other locations from here. This position may include other files on the hard disk or network (such as Microsoft Word Microsoft Excel document or worksheet) and Internet address (such as http:/), bookmarks (to manually insert bookmarks or slides, see note). The domain con
17、tains prompt text, which is usually blue and underlined. The user can click here to jump to the specified location. You can insert hyperlinks by clicking the hyperlink command in the insert menu. The GoToButton jump field (at forty-third pages) can also achieve this function.The meaning of parameter
18、s:Filename the destination of the jump. If it contains a longer space file name, please quote it in quotation marks. Replaces the SLR slash with a double backslash path. For example: C:My DocumentsManual.doc. For Internet addresses, protocols and syntax like URL are included, for example:Http:/ andT
19、he switch:h specifies that no links are added to the history list.l specifies the location in the file to which this hyperlink jumps to, such as bookmarks.m adds coordinates to the server side image map hyperlinkn destination location information opens in new window.s specifies the jump position, bu
20、t this location is not named. The hyperlink created by dragging information will appear in this switch. There is no switch in the list of switches in the insert field menu in the Insert menu. You cannot insert it into domain code manually.t specifies the destination of the link redirection. There is
21、 no switch in the list of switches in the insert field menu in the Insert menu. You cannot insert it into domain code manually.The example:1. jump to the domain base, the role of the domain section of the link example.2. field code and text. The final budget of the project has been determined. Click
22、 HyperLink C:My Documents budget.Xls for details. The result is as follows:The final budget of the project has been determined. Click on the 1997 budget for more details.Clicking the blue text opens the worksheet in the My Documents folder called budget.Xls. Hyperlink displays text as 1997 budget an
23、d is not included in domain syntax. You can type new content to replace the prompt text of the domain.* Note: when to jump to a bookmark that place, more convenient to use in the PageRef domain page twenty-sixth page bookmarks.Four, IncludePicture insert graphicsMethod of use: IncludePicture Switche
24、s FileNameTo insert the IncludePicture field, point the pointer to the picture submenu in the Insert menu, click the file command, and then select the link file check box.Insert the object represented by the bookmark, see the BookMark and Ref domains (on page twenty-seventh).The meaning of parameter
25、s:FileName graphic file name and location. If it contains a longer space file name, please quote it in quotation marks. Replaces the SLR slash with a double backslash path. For example: C:ManualArtArt 22.bmp.The switch:c Converter identifies the desired graphics filter. The file extension.Flt is not
26、 required in the graphics filter name. For example, you want to use the graphics filter Pictim32.flt, simply type pictim32.d graphics data is not saved with the document to reduce the file length.Note 3:The IncludePicture domain can be used instead of the IMPORT domain used in the previous Word vers
27、ion. If you open a document that contains the IMPORT domain, this domain is still valid in the document.If you double-click the figure inserted in the IncludePicture field, Word displays the picture toolbar. If you do not use the picture toolbar to change graphics, you can edit the graphics in the c
28、reation of the application, and then update the domain in Word.If the Word does not recognize the graphics file format, please check the insert picture dialog box (file type pointer insert menu in the picture menu, and then click from file command). The graphics filters installed in the system are l
29、isted in the box.Example: the current directory of this document must be included in the file Next.gif to correctly display the following example.The Next.gif IncludePicture MergeFormat for display:.Five. IncludeText inserts text and graphics in other documentsMethod of use: IncludeText FileName Boo
30、kMark SwitchesInserts the text and graphics contained in the named document. The entire document can be inserted; if it is an Word document, only parts referenced by the bookmark can be inserted.Insert a bookmark representing this article, see the BookMark and Ref domains (on page twenty-seventh).Th
31、e meaning of parameters:FileName document name and location. If it contains a longer space file name, please quote it in quotation marks. Replaces the SLR slash with a double backslash path. For example: C:My DocumentsManual.doc.The BookMark book is signed to the part to be included in the document.
32、 To manually insert bookmarks and notes.The switch:c ClassName: class name.: Word is forbidden to update the fields inserted into the text unless the domain is updated in the source document first.The exampleThe following field inserts the section referenced by the Summary bookmark in the document:I
33、ncludeText, C:WinwordPort, Development, RFP, SummaryNote 3:If the source document is an Word document, you can edit the inserted text results in the IncludeText domain and save the changes back to the source document. The method is: edit the inserted text first,然后按 Ctrl + Shift + F7 组合键.Includetext
34、域不使用 ole i.1. 有关将多篇文档组成一篇文档的详细内容, 参见注释主控文档 II.2. 以前称此域为 include 域.六、link 程序ole链接使用方法: link classname filename placereference switch将从其他应用程序复制来的信息通过 OLE (参见注释) 链接到源文件.先从其他应用复制信息, 然后用 编辑 菜单中的 选择性粘贴 命令粘贴到 word 文档时, word 就会插入此域.参数含义:Classname 链接信息的应用程序类型.例如, 对于 Microsoft Excel 图表, classname 为 excelchart
35、.Word 根据源应用程序确定此项信息.Filename 源文件的名称和位置.如果其中包含较长的带空格文件, 请用引号引住.以双反斜杠替代单反斜杠来指定路径.例如: C: MSOffice excel RFP budget.xlsPlacereference 标识源文件被链接的部分.如果源文件是 Microsoft Excel 工作簿, 引用可以是单元格引用或命名区域.如果源文件是 word 文档, 引用为书签.开关: 自动更新 link 域, 删除此开关则使用人工更新.链接对象作为位图插入 B.图形数据不随文档保存 D, 以减小文件长度.链接对象作为图片插入 P. R 以 RTF 格式插入链
36、接对象. t 以纯文本格式插入链接对象.示例下面示例从 Microsoft Excel 工作表插入一个单元格区域.在 Microsoft Excel 中的工作表被更改时, the 开关保证信息在 word 中也得到更新: link excelsheet C: my documents profits.xls A1: D4 .七、noteref 脚注或尾注标记符使用方法: noteref bookmark switch插入用书签标记的脚注或尾注引用标记, 以便多次引用同一注释或交叉引用脚注或尾注.如果修改了脚注或尾注序号, noteref 域新结果反映最新编号.参数含义:Bookmark 引用脚
37、注或尾注标记的书签名.书签必须引用文档正文中的引用标记, 而不是脚注或尾注窗口的标记.如果不存在书签, 必须创建一个.要手工插入书签参见注释 .开关:插入引用标记和与脚注引用样式或尾注引用样式相同的字符格式 f.插入到书签标记的脚注的超级链接 H. P 插入脚注或尾注的相对位置.如果文档中书签之前没有 noteref 域, 则其值为 在其上.如果书签之后有 noteref 域, 则其值为 在其下.如果 noteref 域在书签之中, 则返回一个错误.此开关可与 N、 R w 和 开关连用.The tail attached to the result of the field on or be
38、low it.The exampleExample: This is the application of iiiBookMark iv sentence v.1, insert three: endnote cursor positioning to the above sentence this is, application, sentence behind the three operation: click the menu , insert footnote and endnote, select endnote, finally click ok.2, set bookmarks
39、: select endnote application behind the same superscript as the endnote mark, click the menu insert, bookmarks, book signature set endnote mark as tail, click ok.3, modify the three endnote content:Endnote 1 examples. The 2 example, endnote. The 3 example, endnote. See note NoteRef, tail case h*, Me
40、rgeFormat.Note: behind an endnote content in curly braces () by Ctrl + F9 insertion.4, if the above is correct, the body and the back of a sentence in the endnotes:See annotations NoteRef, tail case h*, MergeFormatWill be shown as follows: see annotations.Note 3:The NoteRef domain replaces the FTNRe
41、f field used in previous versions of Word for Windows. If you open a document that contains the FTNRef domain, this field is still valid in the document.Word help document like NoteRef domain can only appear in a footnote or endnote, is also available in the text.Eight, PageRef bookmark page numberM
42、ethod of use: PageRef BookMark Format Switch *Insert the page number of the cross reference bookmark vi. To cross reference items in a document, you can use the cross reference command in the insert menu. To manually insert bookmarks and notes.The switch:The Format Switch optional digital universal
43、switch (see page 10), the switch can replace the page number format dialog box (click insert menu in the page command to display the dialog box) the number of styles selection pages in the box.h creates hyperlinks with bookmarks.p does not use the p switch: only the page number of the bookmark is di
44、splayed.Use the p switch: when the PageRef field is not in the current page, shown as the #; when the domain in the current page, shown as above or below.The example1. bookmark the name show on the current page:PageRef show shows: 26PageRef shows p shown as: above2. the bookmark named domain functio
45、n is not on the current page:PageRef domain function shows: 12PageRef domain function p appears on page twelfthThe PageRef domain function p h is shown as: on page twelfth (the hyperlink is on page twenty-third)Note: the two above, on page twelfth, click the latter, and then skip to page twelfth.See page fifty-fourth - 5 example: quote, bookmark content and page type such as: see XXX (pp. n)Nine, Quote text insertMethod of use: Quote LiteralTextInserts the specified text into the document.The meaning of parameters:The text inserted by LiteralText. These words must be enclos