Last active
April 15, 2019 03:03
-
-
Save crazygao/cbd6085629b95655f135c3610e08cb23 to your computer and use it in GitHub Desktop.
Save the document on windows. and upload it.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Blank snippet (1) | |
description: Create a new snippet from a blank template. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#run").click(() => tryCatch(run)); | |
$("#readOnly").click(() => tryCatch(readOnly)); | |
async function run() { | |
const testKey = "test-pear-deck"; | |
Office.context.document.settings.refreshAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to refresh settings"); | |
} else { | |
const result = asyncResult.value.get(testKey); | |
console.log("settings: test-pear-deck = " + result); | |
} | |
}); | |
Office.context.document.settings.set(testKey, "string-value"); | |
Office.context.document.settings.saveAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to save"); | |
} else { | |
console.log("succeeded in saving"); | |
} | |
}); | |
} | |
async function readOnly() { | |
const testKey = "test-pear-deck"; | |
Office.context.document.settings.refreshAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to refresh settings"); | |
} else { | |
const result = asyncResult.value.get(testKey); | |
console.log("settings: test-pear-deck = " + result); | |
} | |
}); | |
} | |
/** 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); | |
} | |
} | |
language: typescript | |
template: | |
content: |- | |
<button id="run" class="ms-Button"> | |
<span class="ms-Button-label">Run</span> | |
</button> | |
<button id="readOnly" class="ms-Button"> | |
<span class="ms-Button-label">readOnly</span> | |
</button> | |
language: html | |
style: | |
content: |- | |
section.samples { | |
margin-top: 20px; | |
} | |
section.samples .ms-Button, section.setup .ms-Button { | |
display: block; | |
margin-bottom: 5px; | |
margin-left: 20px; | |
min-width: 80px; | |
} | |
language: css | |
libraries: | | |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js | |
@types/office-js | |
[email protected]/dist/css/fabric.min.css | |
[email protected]/dist/css/fabric.components.min.css | |
[email protected]/client/core.min.js | |
@types/core-js | |
@microsoft/[email protected]/dist/office.helpers.min.js | |
@microsoft/[email protected]/dist/office.helpers.d.ts | |
[email protected] | |
@types/[email protected] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: RefreshAsync | |
description: Save the document on windows. and upload it. | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#run").click(() => tryCatch(run)); | |
$("#readOnly").click(() => tryCatch(readOnly)); | |
async function run() { | |
const testKey = "test-pear-deck"; | |
Office.context.document.settings.refreshAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to refresh settings"); | |
} else { | |
const result = asyncResult.value.get(testKey); | |
console.log("settings: test-pear-deck = " + result); | |
} | |
}); | |
Office.context.document.settings.set(testKey, "string-value"); | |
Office.context.document.settings.saveAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to save"); | |
} else { | |
console.log("succeeded in saving"); | |
} | |
}); | |
} | |
async function readOnly() { | |
const testKey = "test-pear-deck"; | |
Office.context.document.settings.refreshAsync(function(asyncResult) { | |
if (asyncResult.status == Office.AsyncResultStatus.Failed) { | |
console.log("failed to refresh settings"); | |
} else { | |
const result = asyncResult.value.get(testKey); | |
console.log("settings: test-pear-deck = " + result); | |
} | |
}); | |
} | |
/** 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); | |
} | |
} | |
language: typescript | |
template: | |
content: |- | |
<button id="run" class="ms-Button"> | |
<span class="ms-Button-label">Run</span> | |
</button> | |
<button id="readOnly" class="ms-Button"> | |
<span class="ms-Button-label">readOnly</span> | |
</button> | |
language: html | |
style: | |
content: |- | |
section.samples { | |
margin-top: 20px; | |
} | |
section.samples .ms-Button, section.setup .ms-Button { | |
display: block; | |
margin-bottom: 5px; | |
margin-left: 20px; | |
min-width: 80px; | |
} | |
language: css | |
libraries: | | |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js | |
@types/office-js | |
[email protected]/dist/css/fabric.min.css | |
[email protected]/dist/css/fabric.components.min.css | |
[email protected]/client/core.min.js | |
@types/core-js | |
@microsoft/[email protected]/dist/office.helpers.min.js | |
@microsoft/[email protected]/dist/office.helpers.d.ts | |
[email protected] | |
@types/[email protected] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment