在 Word 中引用 Excel 单元格 [英] Reference Excel cells in Word

问题描述

有人知道直接在 Word 文档中引用 Excel 单元格的预打包解决方案吗?

例如

<块引用>

 {[TestExcel]Tab1!A1}

尊敬的 {[TestExcel]Tab1!A2} 先生，

我们的系统已提醒我们您的帐户 {TestExcel]Tab1!AccountNumber} 已过期.请立即汇款 {TestExcel]Tab1!PaymentDue}.

这个例子使用了一个假设的 {} 语法，其中的内容是标准的 Excel 公式.

我见过的每个解决方案都使用自定义 VBA 来实现这一点.这似乎是一个非常普遍的需求，应该有一些好的 3rd 方软件可用，让非技术用户完成这项任务.

如上例所示，需要支持命名范围和标准单元格引用.

解决方案

是.

第一步:复制excel单元格.

第 2 步:转到要粘贴参考的 Word 文档.

第 3 步:右键单击

第 4 步:在粘贴选项下，选择带有源格式的链接"或链接和合并格式".

Does anyone know of a pre-packaged solution for referencing Excel cells directly in a Word document?

For example,

                                                         {[TestExcel]Tab1!A1} 

Dear Mr. {[TestExcel]Tab1!A2},

Our systems have alerted us that your account {TestExcel]Tab1!AccountNumber} is overdue. Please remit payment of {TestExcel]Tab1!PaymentDue} immediately.

This example uses a hypothetical { } syntax, where the contents are standard Excel formula.

Every solution I've seen uses custom VBA to accomplish this. It seems like an extremely common need for which there should be some good 3rd party software available that lets non-technical users accomplish this task.

As indicated in the example above both named ranges and standard cell references would need to be supported.

解决方案

Yes.

Step 1: Copy the excel cell.

Step 2: Go to your word document where you want to paste the reference.

Step 3: Right click

Step 4: Under paste options, select "link with source formatting" or "link and merge formatting".

这篇关于在 Word 中引用 Excel 单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！