Skip to content

Instantly share code, notes, and snippets.

@MiaofeiWang
Created April 25, 2018 05:15
Show Gist options
  • Save MiaofeiWang/9221bbe45020233b145bdfa2ec03e61e to your computer and use it in GitHub Desktop.
Save MiaofeiWang/9221bbe45020233b145bdfa2ec03e61e to your computer and use it in GitHub Desktop.
Executes a basic Excel API call - Shared with Script Lab
name: SetSelectedData - Image
description: Executes a basic Excel API call
author: MiaofeiWang
host: EXCEL
api_set: {}
script:
content: |-
$("#run").click(run);
function run() {
let imageData = "/9j/4AAQSkZJRgABAQEAYABgAAD/4QBaRXhpZgAATU0AKgAAAAgABQMBAAUAAAABAAAASgMDAAEAAAABAAAAAFEQAAEAAAABAQAAAFERAAQAAAABAAAOw1ESAAQAAAABAAAOwwAAAAAAAYagAACxj//bAEMAAgEBAgEBAgICAgICAgIDBQMDAwMDBgQEAwUHBgcHBwYHBwgJCwkICAoIBwcKDQoKCwwMDAwHCQ4PDQwOCwwMDP/bAEMBAgICAwMDBgMDBgwIBwgMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDP/AABEIAE0AjQMBIgACEQEDEQH/xAAfAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJCgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5+jp6vHy8/T19vf4+fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJCgv/xAC1EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/2gAMAwEAAhEDEQA/AP38r8mfiD/weS/su/Dvx3rOgT+CvjxeT6LezWMs8Ph7T4o5XicoxVJ7+OVRkHiSNGHdQeK/WaigD8gf+I1b9ln/AKEH9oD/AMEekf8Ayzr9Av8Agm9/wUa8B/8ABUb9nIfE74d2PirTdBXU59Ikt/EGnrZ3cc8Kxs/CSSRuuJUw8cjLncuQysB+fv8AwZU/8osvH3/ZVdR/9NGj1+pnxq/aM+Hv7Nnh+31b4jeO/BvgHSryb7NBe+I9attKt55cE+Wsk7orNgE7Qc4FAHZUVxfwU/aR+Hf7SuiXWpfDnx94L8f6bYyiC5u/Det22qwW8hGQjvA7qrY5wSDWv8Tvid4e+C/w91jxZ4s1jT/D/hvw/aPfalqV9MIbezhQZZ3Y9APzJwBkmgDdor8m/iF/weWfsl+CvGF9pen6H8ZvFlnZyFI9V0nQLKOzvAP4oxdXsE23/fiU+1e4W/8AwXSs/jh/wTfn/aE+APwL+LnxkaPxGPDX/CIQ6cbTVklCq8k7CBbrdAgdAXgWYbnCnbtkKAGf+z1/wUe+JHxM/wCDij48fs16lNo//Csfh74As9c0mCOyC3i3jR6NI8jzZ3MG/tOZSp4AjjwAdxb9BK/mB+PX/BTz4ufDL/guV8Lf2pNQ/Y3+KHww8SeJNLfwv/wg+pT6ja3PxJvTby2KtDNJp8bSyIt3pyCGO3l+a2t/4pFI/SD4G/8ABdf9rL4//tL/AAz8Ht+wD8U/hz4Z8ReJLTT/ABJr2vwarNb6Zp8sgSa5Ej6daxQmFSZSZGYMEKAAsCAD9XqKKKACiiigAooooAKKKKACiiigD8gf+DKn/lFl4+/7KrqP/po0evnn4GfsR6P/AMFi/wDgvX+074L/AGqPGnj/AFmP4M65dX3gvwMdRe1s7vQ2v3RMMvzQWy276cSLcxySm7VzICp3fQ3/AAZU/wDKLLx9/wBlV1H/ANNGj18W/wDBZD4FftzfsV/8FE/ij+2xoOmWPhPSdP1yXQ9H8Q+H0stQY6I1v9ltbi9tGWUFTbiKKR7mP5ZlTAULC1AH01/wSN/Zz8H/ALE3/B0v+058I/hjptx4Z+HWifDC1uLPRRqNzeRRyOnhycuzzySSOwku7kqXZiomZRhTivrj/g6KkaL/AIIU/HMqzKcaCMg44PiDTQR+I4r4X/4N7Nf+E/w2+OfjD9rT44ftvfCHxT8VPidos/h7UNI1bXYtJurNDPZS+ZM2otbTFkWzihSOO3WBEXEcjqF2/oTqX7Z/7L//AAWo8QfF79k7TdaufiDYxeHlu9c1PR08zR3jE8Ox7S/QtG88M7QSKQChZMqXCOAAek/8EcvA+i+A/wDglT+zrDoej6Xo8Oo/Djw9qd2ljapbrdXc+mW0k9w4QDdLJIzM7nLMxJJJr6Ur8K/Cfxg/a8/4Nj7b/hFfGfhO6/aK/ZN064lbS/EGmeYNR8LWpcBVkfDC1UFx+5nBhZ22xTJkiv1r/YW/4KDfCf8A4KPfBweN/hL4nh8QaVDKLa+t5Imt77SrjaGMNxC4DI2DweUYAlWYc0AfnV/wcd/8pTf+CY//AGVV/wD07+G6/X6vxx/4OdvFFj8Mf2/v+Cc/jXX7hdL8J+E/iXPe6xqsyn7Lp0Kaj4fmZ5GA+XEcMz46kRsRnBr9jqACvNvjN+2F8Mf2ePiN4H8I+NvG2h+HfE3xK1FdJ8M6bdzEXGr3LEKqRqAcZZlQM2FLuq53MAfNv+Ckf/BVP4Rf8Ev/AIO6h4k+IXiKxbXPszS6P4WtrqM6xr0nRUhhzuEe7hpmGxBkk5wD+fn/AASy/wCCenxP/wCCof7YOk/t0ftXWbaa1o0F18LfA4Voo9KtoZGms7p1OGWKN3MsSt88sjGZsLsVwD9laKKKACiiigAooooAKKKKAPh//ggZ/wAEt/FX/BJH9j/xR8N/F/iLw/4m1DWvG994jt7rRxMIVtZLWztolfzUVhKVtN7AAqpk2hmxuP23fWMOp2U1tcwxXFvcI0UsUqB0lRhgqwPBBBIIPWpaKAPhn4g/8G1n7EfxP8b6p4h1X4FaampaxcNdXI0/xDrGm2vmMcny7e2u44Ylz/DGiqPSvbP2HP8AgmN8DP8Agm3p/iO2+CvgODwXH4ukt5dXYane6hJemASCEGS6mlcKnmyYVSFy7HGTmveqKAPzy/4KU/8ABX/41fsi/tCal8PfA/7D/wAXPjt4bTToZZPEulLdnS74zR5eFBb6fdKwTJRw7o24MNm3azeV/wDBsd+xR8Yv2efGP7S/xQ+KXwth+D2n/HTXNO1zw74ZV4ojpsKzarNJALVTvtYovtsUaRyqj4T7gAGf1hooA+bf+CsH/BOnw/8A8FRP2KfE3wt1loLPVJh/aXhvU5d23SNWiRxbznbyU+d43ABJjlkA5wR+e/w2/wCCen/BX74SfD3Q/C2h/tWfAuHRfDtjDpthHdWqX00cESBI1aefQHlkIVQN0jsxxySa/ZqigD8uf+Cdv/BtR4Q+Gfi6b4tftSanb/tAfHnWNQfU727v7ia70Kxm3ZTy4pVQ3LDH3p02KNqpEmwMf1GA2jA4A6CiigAooqO8vYdOs5ri4ljt7e3QySyyMFSNQMlmJ4AA5JPSgCSis3wh4y0f4heGbPWtA1XTdc0fUY/NtL/T7lLm1uk6bo5EJVl4PIJFaVABRRRQAUUUUAeF+Bf+Cinw0+I37fXjb9mvS7zVJPid4A0CDxHq8D2RWzjtpfsxASbOGkVby1YrgDEwwSVcL7pX5A/sb/8AK5J+1j/2Sqx/9JvClfr9QB+fX/BRP/g5M+A3/BM39pm5+FPjvw78VtW8SWVnbXtxPoei2sllEk6B0xJcXULSfKQSY1dQcrncrKF8B/8AB0b+w/44ttN3/GKTQ77UdoNnqnhfV4WtGP8ADLKts0C47sJSo/vV+gNxbx3lvJDNGksUqlHR13K6nggg9QfSvnr4kf8ABIz9lv4taZq1trn7PPwbuG1tWW8vLfwjZWd+5b7zrdQxpOjn++jq3vQB2fwY/bs+CP7RvicaH8PfjF8LfHWt+Sbj+ztA8VWOpXgjHVzDDKzhR3JHHevVa/BDwR+x38Ef2JP+Dtn9nnwJ8AtHsdF8O6f4L1O78Q2FnrV1q5sdUfTfECuJ3uJppIpPIFn+7LKAGQ7QXyf3voA+dP8AgqT/AMFFNH/4Jf8A7J958TtV8L6940mbUbbRtM0bShtkvr24LCJHl2sIYzsbLlW52qFZmVT8ET/8HJP7Tun2z3N5/wAEz/j5a2UKmWedp9WCxRgZZyTogGAMnkgcdRX7ASRrKuGVWGQcEZ5ByD+B5qn4n8UaZ4J8OX2sa1qNjpGk6XA91eX17cJb21pEgLPJJI5CoigElmIAA5oA/O/9gj/g6H/Zv/bl+K+jfD2WPxl8M/HmuTwafY6f4nsIxbajfysIxaQXEEkg3mQ7V89YS5IAG4ha/R6v5t/+C8//AAWJ+DP7Sf8AwUh/Zc8YfA+xvPijqX7PviNte1u70+wa1j8QpDeafeRWVvcMhlkWP7HdZkMRjTzyybwXr9yv+CcP/BSL4bf8FP8A9nWx+IXw51BmXIt9Y0e5ZRqGgXeMtbzoCfqrj5XXkHqAAe/V+Z//AAdN/t93/wCyB/wTqm8E+FZbGbxx8dbqXwdb2RzJeDTJbeQX88MY5ZsNDb5/ha8UjJAr9MK/FX4bXk//AAWH/wCDoK68caTY6de/CT9jeyOh3E1xKZotR1MG/SGaJRlRL9veSRGB2mPTEbOSBQB+lv8AwS5/Yr/4d3/sCfDP4OPqS6xeeDdNkW/vEz5U95cXEt3cmPIB8oTzyhMgHYFyAc188f8AByN/wUe+JH/BMH9hfwv48+Fs2j2/iLWPHdhoM0mo2Qu4xavaX11IoRjjLm0RCeoV2xhsMP0Er8R/+Dyn9p74bePv2CvCPgPQfiB4K1vxxpHxLsr2/wDD+n63bXOqWMCaZqsbyzW6OZI0EksaksoG5wOpoA/biivzm+KX/B1j+xT8N0kWz+I+teL7iIEmHRPDF+xJxkAPcRQxnPA4fGTyRzjxZP8Ag6c8d/Gi7uNS+A/7Dfx4+L3gmJ/LTXIluYN7+hS0sb2Neh/5bZ9hQB+wVFFFAH5A/sb/APK5J+1j/wBkqsf/AEm8KV+v1fP/AMPv+Ca/w5+Gn/BRPx3+09pjeIP+FkfETw9B4a1WOW9VtNFvELVQ8cOwMsrLZWqklyuIuFUsxb6AoAK/Ir/g40/4OD2/YMaf4G/CPUIYPjFq1vE2sa9LGZIPBVrOoZGC7W33TxsHUbWEaMHwzMor9da+cfiX/wAEiv2a/jV+07qvxi8afB3wf4y8fa5aQ2V9ea9btqVrcJFEsMbNZzM1qZFjREEnlbwEUZ4oA/Cz/glT/wAFXv2Lf+CTnjvxX4x8RXHxo+P3xw8WTTvq3xEsvDkMFrJHcGKWeC2S+1GOdw1wju1zNDFNLu5VBla+6/hp/wAHPXxL/aG8VWN98Lv2Efj148+Gepagtpa+KbMzsZE3hXcpFYy2qsueVN5tHd1HNfql8Kfg54Q+A/g2Hw54H8K+G/Bnh62dpIdL0LTIdOs4mblisMKqgJPUgc10lABX4l/8HB//AATd/bk/4Kdftn6b4P8Ah/aW9t+zxa2VnDbTy+Krax0o3TDfcXeoWok+0yukh2Lsgl2oilBud8/tpXzj/wAFdvj74x/Zb/4JrfGD4hfD/U7PRvGHhPQXv9NvbmxS9jt3WRAx8pzsZthYLuDKGKkq4BUgHyV/wRi/4NtvAv8AwSb8Y3nxT8deLNN+InxGs7RX03VTZS6ZY+D0a2mivhFuuGWcSJMymeZEIRPlWPc+fCP+CPy/D3Rv+DpH9qix+Cd54fm+Et78P0v7ZfDF6l1oct476DJO0bRM0OVuZr4BVOIy0qKFAKj44/4JfaL8aP8Ag5w/aR8TeEv2hP2i/iPH4L8G6NBqt7o+iR21jbaqvn+UqrbwqlnFKC5PnPbSsQMY6Efvt/wT/wD+CUnwL/4JjaJqtt8H/BraDe+IYLaHWdTutRub+91U24YIzvM7LHku7FIVjjLNnYMAAA9P/an+F2r/ABx/Zh+I/grw/rH/AAjuveMPC+p6Jpuq5Yf2Zc3NpLDFcZX5v3bur/Lz8vHNfiN+xL/wamftWfs56XrVnY/tcW3wVh8RvDJqbfDp9TuJb8web5HmSb7B2C+bJgE4HmNwe/760UAfjzqn/Bs1+0L43sJNJ8W/8FHvjx4k8M32I9S0ueDUmjvocgtGfN1iROcdWjcA/wAJrx3/AILRf8G6/wCzT/wT3/4I2/EDxx4I0XxLd/ELwXPpE0HiXVdbmnursT6naWcsckK7LUIY7l2GyFWDKvzEDB/eivgD/g6O/wCUFHxz/wC4B/6kGmUAdr/wSV/Yt+DVj/wT7+AnjC1+EPwtsfFPiT4e+H9Z1PVbTwnYW93eXk+nW88szyJEGLNIxbrwcYwAK+x7e3js7eOGGNIoolCIiLtVFHAAA6AeleBf8Enf+UWX7NP/AGSrwv8A+mi1r6AoA//Z";
Office.context.document.setSelectedDataAsync(imageData, { coercionType: Office.CoercionType.Image },
function (asyncResult) {
console.log("succeed!");
});
}
language: typescript
template:
content: |
<p class="ms-font-m">Executes a simple code snippet.</p>
<button id="run" class="ms-Button">
<span class="ms-Button-label">Run code</span>
</button>
<div id="content-main"></div>
language: html
style:
content: ''
language: css
libraries: |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js
https://appsforoffice.microsoft.com/lib/1/hosted/office.d.ts
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
@microsoft/office-js-helpers@0.7.4/dist/office.helpers.min.js
@microsoft/office-js-helpers@0.7.4/dist/office.helpers.d.ts
jquery@3.1.1
@types/jquery
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment