Office-JS Excel自定义函数：桌面端WASM模块导入失败问题

数据老陈

2026-7-20

Office-JS Excel自定义函数WASM功能桌面端报#VALUE!错误，网页端正常

我开发了一款基于Office-JS的Excel插件并投入使用，近期为自定义函数新增了一个基于WASM实现的功能，通过functions.html加载对应的coolprop.js文件调用。该函数在网页版Excel中运行正常，但在桌面端Excel中出现#VALUE!错误，无法正常工作。

相关代码

functions.html

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta http-equiv="Expires" content="0" />
    <title></title>
    
  <script src="https://appsforoffice.microsoft.com/lib/1.1/hosted/custom-functions-runtime.js" type="text/javascript"></script>
  <script src="https://cdn.jsdelivr.net/npm/coolporp@1.0.0/coolprop.js" integrity="sha256-7p7Q27fnNIzYo+JYD7x+OUvz5Vr248CViv8/ePozTTM=" crossorigin="anonymous"></script>

</head>

<body>
   
</body>

</html>

自定义函数代码

/** 
* CoolProp PropsSI function as input {OutputName, InputName1, Input1, InputName2, Input2, Fluid} 
* @customfunction 
* @param {string} OutputName output parameter, 
* @param {string} InputName1 input1 parameter, 
* @param {number} InputValue1 number1, 
* @param {string} InputName2 input2 parameter, 
* @param {number} InputValue2 number2, 
* @param {string} Fluid fluid name, 
* @returns {number} get number, 
* @helpurl http://coolprop.org/coolprop/HighLevelAPI.html#table-of-string-inputs-to-propssi-function
*/ 
export function PropsSI(OutputName, InputName1, InputValue1, InputName2, InputValue2, Fluid) { 
  return Module.PropsSI(OutputName, InputName1, InputValue1, InputName2, InputValue2, Fluid); 
  //return Module.PropsSI('D', 'T', 298.15, 'P', 101325, 'Air') //1.1843184839089664 
}