Skip to content

Instantly share code, notes, and snippets.

@WrathOfZombies
Created May 9, 2017 02:01
Show Gist options
  • Save WrathOfZombies/46afdfff4d226537c1a154099822bb6f to your computer and use it in GitHub Desktop.
Save WrathOfZombies/46afdfff4d226537c1a154099822bb6f to your computer and use it in GitHub Desktop.
Shared with Script Lab
name: Range coloring
description: ''
author: WrathOfZombies
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(run);
async function run() {
try {
await Excel.run(async (context) => {
let range = context.workbook.getSelectedRange();
range.format.fill.color = "yellow";
await context.sync();
});
}
catch (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.6.5/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/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