如何确定何时完成所有“加载数据"操作? [英] How to determine when all Loading Data operations are finished?

问题描述

我有一个表格电子表格，其中包含许多使用自定义函数的单元格，该函数调用IMPORTHTML并解析结果.工作表中的其他计算使用这些自定义公式单元格返回的值.正如预期的那样，当自定义公式单元格正在计算时，它们会显示正在加载数据..."错误消息.在加载数据"操作完成之前，我不能相信依赖计算的结果.有什么好办法知道某个范围内的所有加载数据"操作何时完成?

I have a Sheets spreadsheet that has many cells that use a custom function which calls IMPORTHTML and parses the results. Other calculations in the sheet use the returned values from these custom formula cells. As expected, when the custom formula cells are calculating they show a "Loading Data..." error message. I can't trust the results of the dependent calculations until the Loading Data operations are complete. Is there any good way to know when all Loading Data operations within a range are complete?

推荐答案

比方说，可以在Sheet1中找到正在加载数据"错误，Sheet1由A-Z列和1-1000行组成.在Sheet2！A1中，您可以输入 = IF(COUNTIF(Sheet1！A:Z，#Loading Data ...")，"Loading"，"Done").(用最后一列替换A:Z中的Z.)如果Sheet1中的任何单元格正在返回"#Loading Data ..."，则countif将对其进行计数，并返回"Loading"；否则，Countif将对其进行计数.否则它将返回完成".

Let's say the "Loading Data" errors can be found in Sheet1, which is made up of columns A-Z and rows 1-1000. In Sheet2!A1 you could put =IF(COUNTIF(Sheet1!A:Z,"#Loading Data..."),"Loading","Done"). (Replace Z in A:Z with the last column.) If any cells in Sheet1 are returning "#Loading Data..." then the countif will count them, and return "Loading"; else it will return "Done".

(注意:错误消息是否正是我所使用的?我目前无法对此进行测试，并且不确定是否正是此输出)

(Note: Is the error message exactly what I used? I can't test this at the moment and I'm not sure that's exactly the output)

这篇关于如何确定何时完成所有“加载数据"操作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！