Travail avec des feuilles de calcul

Travail avec des feuilles.EXCEL.yaml

name: Travail avec des feuilles
description: Travail avec des feuilles de calcul
host: EXCEL
api_set: {}
script:
  content: |
    $("#ajouter").click(() => tryCatch(ajouter));
    $("#copie").click(() => tryCatch(creation));
    $("#supprimer").click(() => tryCatch(supprimer));
    $("#changervisi").click(() => tryCatch(changerVisibilite));
    $("#grille").click(() => tryCatch(grilleOnOff));
    $("#entete").click(() => tryCatch(enteteOnOff));
    $("#desactivercalcul").click(() => tryCatch(desactiverCalcul));
    $("#figer").click(() => tryCatch(figer));

    async function ajouter() {
      await Excel.run(async function(context) {
        let feuille2 = context.workbook.worksheets.add();
        feuille2.name = "nouveau";
      });
    }

    async function creation() {
      await Excel.run(async function(context) {
        let feuille1 = context.workbook.worksheets.getItem("Feuil1");
        feuille1.copy(Excel.WorksheetPositionType.after, feuille1);
        let feuille2 = context.workbook.worksheets.getActiveWorksheet();
        feuille2.name = "copie";
      });
    }

    async function supprimer() {
      await Excel.run(async function(context) {
        let copie = context.workbook.worksheets.getItem("copie");
        copie.delete();
      });
    }

    async function changerVisibilite() {
      await Excel.run(async function(context) {
        let copie = context.workbook.worksheets.getItem("copie");
        copie.load("visibility");
        await context.sync();
        if (copie.visibility == "Visible") copie.visibility = "Hidden";
        else copie.visibility = "Visible";
      });
    }

    async function grilleOnOff() {
      await Excel.run(async function(context) {
        let copie = context.workbook.worksheets.getItem("copie");
        copie.load("showGridlines");
        await context.sync();
        if (copie.showGridlines) copie.showGridlines = false;
        else copie.showGridlines = true;
      });
    }

    async function enteteOnOff() {
      await Excel.run(async function(context) {
        let copie = context.workbook.worksheets.getItem("copie");
        copie.load("showHeadings");
        await context.sync();
        if (copie.showHeadings) copie.showHeadings = false;
        else copie.showHeadings = true;
      });
    }

    async function desactiverCalcul() {
      await Excel.run(async function(context) {
        let copie = context.workbook.worksheets.getItem("copie");
        copie.load("enableCalculation");
        await context.sync();
        if (copie.enableCalculation) {
          $("#desactivercalcul span").html("Activer les calculs");
          copie.enableCalculation = false;
        } else {
          $("#desactivercalcul span").html("Désactiver les calculs");
          copie.enableCalculation = true;
        }
      });
    }

    async function figer() {
      await Excel.run(async function (context) {
        let copie = context.workbook.worksheets.getItem("copie");
        let panes = copie.freezePanes;
        const frozen = panes.getLocationOrNullObject();
        frozen.load('getRow');
        await context.sync();
        if (frozen.isNullObject) {
          panes.freezeRows(1);
          panes.freezeColumns(1);
        }
        else panes.unfreeze();
      });
    }

    /** Default helper for invoking an action and handling errors. */
    async function tryCatch(callback) {
      try {
        await callback();
      } catch (error) {
        // Note: In a production add-in, you'd want to notify the user through your add-in's UI.
        console.error(error);
      }
    }
  language: typescript
template:
  content: |-
    <button id="ajouter" class="ms-Button">
        <span class="ms-Button-label">Ajouter la feuille nouveau</span>
    </button>
    <button id="copie" class="ms-Button">
        <span class="ms-Button-label">Copier Feuil1 dans la nouvelle feuille copie</span>
    </button>
    <button id="supprimer" class="ms-Button">
        <span class="ms-Button-label">Supprimer la feuille copie</span>
    </button>
    <button id="changervisi" class="ms-Button">
        <span class="ms-Button-label">Changer la visibilité de copie</span>
    </button>
    <button id="grille" class="ms-Button">
        <span class="ms-Button-label">Cacher/Afficher la grille</span>
    </button>
    <button id="entete" class="ms-Button">
        <span class="ms-Button-label">Cacher/Afficher les en-têtes'</span>
    </button>
    <button id="desactivercalcul" class="ms-Button">
        <span class="ms-Button-label">Désactiver/activer les calculs'</span>
    </button>
    <button id="figer" class="ms-Button">
        <span class="ms-Button-label">Figer/libérer lignes et colonnes'</span>
    </button>
  language: html
style:
  content: |-
    section.samples {
        margin-top: 20px;
    }

    section.samples .ms-Button, section.setup .ms-Button {
        display: block;
        margin-bottom: 5px;
        margin-left: 20px;
        min-width: 80px;
    }
  language: css
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