GeorgeHung

name: NumberFormat
description: Formats a range.
host: EXCEL
api_set: {}
script:
  content: |
    $("#setup").click(() => tryCatch(setup));

    $("#set-number-format").click(() => tryCatch(setNumberFormat));

GeorgeHung

name: Fix Template
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    const svTag = "SmartViewData";
    const svUTF16Tag = "SVUTF16";

GeorgeHung

name: Blank snippet (2)
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    const svTag = "SmartViewData";
    const svUTF16Tag = "SVUTF16";

GeorgeHung

name: Basic API call (JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(fixUDFLink));

    function fixUDFLink(callback) {
      Excel.run(function (ctx) { 

GeorgeHung

name: Blank snippet
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    async function run() {
      //Save and write into file

GeorgeHung

name: Blank snippet
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

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

GeorgeHung

name: Basic API call (JavaScript)
description: Performs a basic Excel API call using plain JavaScript & Promises.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    function run() {
      return Excel.run(function(context) {

GeorgeHung

name: Parese Date Value
description: Parse the date value from Excel with Javascript
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    function SerialDateToJSDate(serialDate, offsetUTC) {
      return new Date(Date.UTC(0, 0, serialDate, offsetUTC));

GeorgeHung

name: Save Settings in Data Change
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

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

GeorgeHung

name: Test Dialog API
description: ''
host: EXCEL
api_set: {}
script:
  content: >
    $("#run").click(() => tryCatch(run));


    function processMessage(arg) {