如何将外部 .js 文件导入到 Commands.js 中？ [Office.js Excel]

导入不同版本中的函数的正确方法是什么.js脚本写入commands.jsOffice Excel 功能区加载项的脚本？

这是我的commands.html file:

<!--
    "commands.html"
    HTML file importing the necessary scripts, especially commands.js where
    button presses are mapped.
-->

<script type="text/javascript" src="https://appsforoffice.microsoft.com/lib/1.1/hosted/office.js"></script>
<script src="commands.js" type="module"></script> 

这是我的commands.js file

/*
  "commands.js"
  All top-level functions that are mapped to button presses on the ribbon
  are and should be in this file. Function names are the same as the IDs of 
  the buttons they are mapped to (with underscored instead of dashes).
*/

import * as tools from "./scripts/native/tools.js"

Office.initialize = function() { 
  /*
    Initialize Office function. Has to be called here.
  */
} 

console.log(tools.char_to_underscore("test32"))

这是我想导入的函数tools.js:

/*
    "tools.js"
    A collection of functions that help with certain problems.
*/

export function char_to_underscore(string) {
    /*
        Replaces a set of characters in a string with underscores.
    */
    var replacement_list = [/ /g, ".", "\\", "%", "/", "\n", "-", "(", ")", "|"];
    for (var replace in replacement_list) {
        string = string.replace(replacement_list[replace], "_");
    }
    return string;
}

这是我的项目目录：

截屏 https://i.stack.imgur.com/sZyCK.png

VSCode 似乎可以完美地找到这些文件，但是当我启动加载项时，出现以下错误：

Failed to load resource: the server responded with a status of 404 (Not Found)
logger — index.js:551 (https://localhost:3000/scripts/native/tools.js)

我几乎尝试了所有我能想到的方法，但似乎没有任何方法可以解决这个问题。我在这里错过了什么吗？对于大型功能区项目来说，将所有源代码都放在一个文件中是不可持续的。

在这里回答我自己的问题。我发现唯一能达到我想要的目的的方法如下：

• 而不是在中映射功能区按钮commands.js文件，而不是在commands.html代码写在<script>标签如下：

<script>
    async function button_x_pressed(event) { 
    console.log(char_to_underscore("f%%%"));
    console.log(return_sample_values());
    await Excel.run(async (context) => {
        let range = context.workbook.getSelectedRange();
        range.format.fill.color = "Blue";
        await context.sync();
    });
    event.completed(); // must be called (signals to Excell that the process/event is completed)
    }
</script>

• In commands.html，导入外部.js文件，如下：

<script type="text/javascript" src="./scripts/native/tools.js"></script>

• The button_x_pressed然后函数可以找到char_to_underscore功能，尽管 VScode 中的自动完成功能没有。

• 中唯一的代码commands.js如下：

Office.initialize = function() { 
  /*
    Initialize Office function. Has to be called here.
  */
} 

这很可能也可以移动到文件内<script> in commands.html但我决定将其保留在这里，以便在这个自动生成的文件中包含一些内容。

• 我的方法归结为将按钮映射到功能commands.hmtl并在那些执行功能区按钮所需操作的函数中调用外部脚本。