Skip to content

Instantly share code, notes, and snippets.

@ci010
Last active April 27, 2020 08:03
Show Gist options
  • Save ci010/1cf3a291e552b781f1ba23552b972ec5 to your computer and use it in GitHub Desktop.
Save ci010/1cf3a291e552b781f1ba23552b972ec5 to your computer and use it in GitHub Desktop.
Create a new snippet from a blank template.
name: getSurroundingRange
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: "Excel.run(async (context) => {\r\n let range = context.workbook.getSelectedRange();\r\n console.log(\"HELLO\");\r\n let surrounding = range.getSurroundingRegion();\r\n surrounding.load(\"address\");\r\n console.log(\"LOAD ADDR\");\r\n\r\n await context.sync();\r\n console.log(\"SYNCED\");\r\n console.log(surrounding.address);\r\n console.log(\"ADDR PRINT\");\r\n});\r\n"
language: typescript
template:
content: ''
language: html
style:
content: ''
language: css
libraries: |
https://appsforoffice.microsoft.com/lib/beta/hosted/office.js
@types/office-js
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
core-js@2.4.1/client/core.min.js
@types/core-js
jquery@3.1.1
@types/jquery@3.3.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment