Excel“全部刷新"使用OpenXML [英] Excel "Refresh All" with OpenXML

问题描述

我有一个Excel 2007文件(OpenXML格式)，并具有与xml文件的连接.此连接将生成一个excel表和数据透视图.

I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts.

我正在尝试找到一种使用OpenXML SDK v2与Excel中的全部刷新"按钮相同的方法.这样，一旦提供了新的xml文件，我就可以自动更新文件.

I am trying to find a way with OpenXML SDK v2 to do the same as the "Refresh All" button in Excel. So that I could automatically update my file as soon as a new xml file is provided.

谢谢.

推荐答案

使用Open XML无法做到这一点. Open XML允许您处理文件中存储的数据，并更改数据以及公式和定义等.它实际上不执行任何计算.

You can't do this with Open XML. Open XML allows you to work with the data stored in the file and change the data and formulas and definitions and such. It doesn't actually do any calculations.

从技术上讲，Excel自动化是可行的，但是绝对不建议在服务器环境中使用它，并且尽可能避免在台式机上使用.

Excel automation technically would work, but it's absolutely not recommended for a server environment and is best avoided on the desktop if at all possible.

这篇关于Excel“全部刷新"使用OpenXML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！