在Word中参考Excel单元格 [英] Reference Excel cells in Word

问题描述

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

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

例如，

                                                         {[TestExcel]Tab1!A1} 

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

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

我们的系统已通知我们，您的帐户{TestExcel] Tab1！AccountNumber}已过期.请立即汇出{TestExcel] Tab1！PaymentDue}的款项.

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

此示例使用假设的{}语法，其中内容是标准Excel公式.

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

我见过的每个解决方案都使用自定义VBA来完成此任务.似乎非常普遍的需求是，应该有一些不错的第三方软件可以让非技术用户完成此任务.

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.

推荐答案

是.

第1步:复制excel单元格.

Step 1: Copy the excel cell.

第2步:转到您要在其中粘贴参考文献的Word文档.

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

第3步:右键单击

第4步:在粘贴选项下，选择使用源格式链接"或链接并合并格式".

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

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