Skip to content

Instantly share code, notes, and snippets.

@johnaweiss
Created July 14, 2020 22:05
Show Gist options
  • Save johnaweiss/0861852d76cf577c37be4b3c626d5ab9 to your computer and use it in GitHub Desktop.
Save johnaweiss/0861852d76cf577c37be4b3c626d5ab9 to your computer and use it in GitHub Desktop.
Create a new snippet from a blank template.
name: jw-sht
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
/** @CustomFunction */
/* Return 0-based index of last instance of search-string in text-string */
function FindRev(text, search) {
var n = text.lastIndexOf(search);
return n;
}
language: typescript
libraries: |
https://appsforoffice.microsoft.com/lib/1/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
@johnaweiss
Copy link
Author

Worksheet function for Excel 365 online. Not tested on desktop.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment