Yeoman创建OfficeAddIn

office365dev/docs/vscodetoofficeaddin.md at master · chenxizhang/office365dev · GitHub

约曼入门 |自耕农 (yeoman.io)

node.js安装后，执行npm install -g yo

 然后yo doctor

 再yo office

 Home | Generator (yeoman.github.io)

Office Web Add-in的技术原理和开发常见问题剖析-Office 365 开发入门指南 (cntofu.com)

Excel 加载项中的 Excel JavaScript 对象模型 - Office Add-ins | Microsoft Learn

https://learn.microsoft.com/en-us/office/dev/add-ins/testing/test-debug-office-add-ins#sideload-an-office-add-in-for-testing

 

 

Office-Add-in-samples/Samples/hello-world/excel-hello-world at main ·OfficeDev/Office-Add-in-samples ·GitHub

Install a recent version of npm and Node.js on your computer. To verify if you've already installed these tools, run the commands node -v and npm -v in your terminal.

You need http-server to run the local web server. If you haven't installed this yet you can do this with the following command:

npm install --global http-server
You need Office-Addin-dev-certs to generate self-signed certificates to run the local web server. If you haven't installed this yet you can do this with the following command:

npm install --global office-addin-dev-certs
Clone or download this sample to a folder on your computer. Then go to that folder in a console or terminal window.

Run the following command to generate a self-signed certificate that you can use for the web server.

npx office-addin-dev-certs install
The previous command will display the folder location where it generated the certificate files.

Go to the folder location where the certificate files were generated. Copy the localhost.crt and localhost.key files to the hello world sample folder.

Run the following command:

http-server -S -C localhost.crt -K localhost.key --cors . -p 3000

 

 

 Excel 加载项教程 - Office Add-ins | Microsoft Learn

Microsoft 标识平台身份验证和授权的代码示例 - Microsoft Entra | Microsoft Learn

 npm start报问题，先输入npm i