Skip to content

Instantly share code, notes, and snippets.

@eefuu
Created May 31, 2023 02:17
Show Gist options
  • Save eefuu/6c9fc09dec6abda8aa9c1b3d432bdd35 to your computer and use it in GitHub Desktop.
Save eefuu/6c9fc09dec6abda8aa9c1b3d432bdd35 to your computer and use it in GitHub Desktop.
taegyun2kimdhi -excel custom function list-
name: myCFAPI
description: |-
taegyun2kimdhi
-excel custom function list-
host: EXCEL
api_set: {}
script:
content: >
// $("#run").click(() => tryCatch(run));
// async function run() {
// await Excel.run(async (context) => {
// const sheet = context.workbook.worksheets.getActiveWorksheet();
// console.log("Your code goes here");
// await context.sync();
// });
// }
// /** Default helper for invoking an action and handling errors. */
// async function tryCatch(callback) {
// try {
// await callback();
// } catch (error) {
// // Note: In a production add-in, you'd want to notify the user
through your add-in's UI.
// console.error(error);
// }
// }
/**
* check version
* @customfunction
* @returns {string} check version of add-in.
*/
function version_myGistFunction() {
// return "publish on 2023-05-31, myGistFunction";
return "publish on 2023-05-31, myGistFunction";
}
/** @CustomFunction */
function add10(x: number): number {
return x + 10;
}
/** @CustomFunction */
function sumGist(x: number, y: number): number {
return x + y;
}
language: typescript
libraries: |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js
@types/office-js
office-ui-fabric-js@1.4.0/dist/css/fabric.min.css
office-ui-fabric-js@1.4.0/dist/css/fabric.components.min.css
core-js@2.4.1/client/core.min.js
@types/core-js
jquery@3.1.1
@types/jquery@3.3.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment