Created
June 10, 2017 17:30
-
-
Save Zlatkovsky/24f2297cecea181edcc165c6c0df6da0 to your computer and use it in GitHub Desktop.
Shared with Script Lab
This file contains 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: '(StackOverflow:44421986-b): Combine 2013 binding method with 2016 model' | |
description: '' | |
author: Zlatkovsky | |
host: EXCEL | |
api_set: {} | |
script: | |
content: | | |
$("#run").click(run); | |
async function run() { | |
try { | |
await new Promise((resolve, reject) => { | |
Office.context.document.bindings.addFromPromptAsync( | |
Office.BindingType.Matrix, | |
{ id: "TestBinding" }, | |
(result) => { | |
if (result.status === Office.AsyncResultStatus.Succeeded) { | |
resolve(); | |
} else { | |
reject(); | |
} | |
} | |
) | |
}) | |
await Excel.run(async (context) => { | |
let binding = context.workbook.bindings.getItem("TestBinding"); | |
let range = binding.getRange(); | |
range.load("address"); | |
range.select(); | |
await context.sync(); | |
OfficeHelpers.UI.notify("Binding range address is " + range.address); | |
}); | |
} | |
catch (error) { | |
OfficeHelpers.UI.notify(error); | |
OfficeHelpers.Utilities.log(error); | |
} | |
} | |
language: typescript | |
template: | |
content: | | |
<button id="run" class="ms-Button"> | |
<span class="ms-Button-label">Run</span> | |
</button> | |
language: html | |
style: | |
content: "/* Your style goes here */\r\n" | |
language: css | |
libraries: | | |
# Office.js | |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js | |
# CSS Libraries | |
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 | |
# NPM libraries | |
core-js@2.4.1/client/core.min.js | |
@microsoft/office-js-helpers@0.7.4/dist/office.helpers.min.js | |
jquery@3.1.1 | |
# IntelliSense: @types/library or node_modules paths or URL to d.ts files | |
@types/office-js | |
@types/core-js | |
@microsoft/office-js-helpers@0.7.4/dist/office.helpers.d.ts | |
@types/jquery |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment