Created
July 25, 2019 13:54
-
-
Save lemkorp/eb4d47e0e5bd9cd3b8e55abde6ad6dc6 to your computer and use it in GitHub Desktop.
Travail avec des feuilles de calcul
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment