MiaofeiWang

name: Leaderlines API Samples
description: This sample shows how to use Excel chart data label leader line APIs.
host: EXCEL
api_set: {}
script:
  content: |
    $("#setup").click(() => tryCatch(setup));
    $("#addlabels").click(() => tryCatch(addLabels));
    $("#turnonldl").click(() => tryCatch(turnOnLeaderlines));
    $("#turnoffldl").click(() => tryCatch(turnOffLeaderlines));

MiaofeiWang

name: Perf_APISetFormula
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").on("click", () => tryCatch(run));
    $("#register").on("click", () => tryCatch(registerEvent));
    $("#unregister").on("click", () => tryCatch(unregisterEvent));

MiaofeiWang

name: PerfTestFunctions
description: Functions for perf testing
host: EXCEL
api_set: {}
script:
  content: >-
    /** @CustomFunction
     * @description Simulates rolling a 6-sided die.
     * @param dependency Only for triggering chained calc.
     * @returns A whole number from 1 to 6.

MiaofeiWang

name: Data label APIs from Scratch
description: ''
host: EXCEL
api_set: {}
script:
  content: >
    $("#prepare-chart").click(() => tryCatch(prepareChart));


    const SHEET_NAME = "SampleSheet";

MiaofeiWang

name: Get image of shape group
description: A demo script to get the image of the shape group in active worksheet.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    async function run() {
      await Excel.run(async (context) => {

MiaofeiWang

name: Multiple Custom functions
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    async function run() {
      await Excel.run(async (context) => {

MiaofeiWang

name: BindingDataLabelsWithFormula_20231120
description: ''
host: EXCEL
api_set: {}
script:
  content: >
    $("#setup").click(() => tryCatch(setup));

    $("#import-news").click(() => tryCatch(importNews));

MiaofeiWang

name: Get SVG image of chart
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    $("#setup").click(() => tryCatch(setup));
    $("#run").click(() => tryCatch(run));

    const sheetName = "Sample";

MiaofeiWang

name: DataLabelAPIs_Demo_20231012
description: ''
host: EXCEL
api_set: {}
script:
  content: >
    $("#setup").click(() => tryCatch(setup));

    $("#show-data-callout").click(() => tryCatch(addAnnotationToDataPoints));

MiaofeiWang

name: MyCFs
description: Few custom functions for test
host: EXCEL
api_set: {}
script:
  content: |
    /**
     * @customfunction
     * @return {number} random number between 1-6
     */