Skip to content

Instantly share code, notes, and snippets.

View lemkorp's full-sized avatar

Michel Martin lemkorp

View GitHub Profile
@lemkorp
lemkorp / Travail avec des feuilles.EXCEL.yaml
Created July 25, 2019 13:54
Travail avec des feuilles de calcul
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));
@lemkorp
lemkorp / Apparence.EXCEL.yaml
Last active August 1, 2019 15:35
Create a new snippet from a blank template.
name: Apparence
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#ligne1").click(() => tryCatch(ligne1));
$("#colonnea").click(() => tryCatch(colonneA));
$("#colonnesbd").click(() => tryCatch(colonnesBD));
$("#plagec2d4").click(() => tryCatch(plageC2D4));
@lemkorp
lemkorp / Tableaux.EXCEL.yaml
Created July 26, 2019 13:08
Create a new snippet from a blank template.
name: Tableaux
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#creation").click(() => tryCatch(creation));
$("#ajout").click(() => tryCatch(ajoutDonnees));
$("#somme").click(() => tryCatch(somme));
$("#ajoutjson").click(() => tryCatch(ajoutJSON));
@lemkorp
lemkorp / Date et Heure.EXCEL.yaml
Last active August 1, 2019 16:23
Create a new snippet from a blank template.
name: Date et Heure
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#date").click(() => tryCatch(dateA1));
$("#heure").click(() => tryCatch(heureB1));
$("#horloge").click(() => tryCatch(horloge));
$("#datemoment").click(() => tryCatch(dateAvecMoment));
@lemkorp
lemkorp / Mise en forme conditionnelle.EXCEL.yaml
Last active August 2, 2019 14:36
Create a new snippet from a blank template.
name: Mise en forme conditionnelle
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#rouge").click(() => tryCatch(negatifEnRouge));
$("#effacer").click(() => tryCatch(effacerLesRegles));
$("#echelle").click(() => tryCatch(echelle));
$("#databar").click(() => tryCatch(dataBar));
@lemkorp
lemkorp / Promise.EXCEL.yaml
Created July 30, 2019 16:10
Create a new snippet from a blank template.
name: Promise
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(affichage);
async function attendre(ms) {
let promise = new Promise((resolve) => {
@lemkorp
lemkorp / squelette standard.EXCEL.yaml
Last active July 31, 2019 06:09
Create a new snippet from a blank template.
name: squelette standard
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$('#run').click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
// Entrez votre code ici
@lemkorp
lemkorp / Propriétés des cellules.EXCEL.yaml
Created July 31, 2019 09:11
Create a new snippet from a blank template.
name: Propriétés des cellules
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
@lemkorp
lemkorp / plage 1.EXCEL.yaml
Created July 31, 2019 13:40
Create a new snippet from a blank template.
name: plage 1
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async function (context) {
@lemkorp
lemkorp / plage 2.EXCEL.yaml
Created July 31, 2019 14:44
Create a new snippet from a blank template.
name: plage 2
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async function (context) {