Skip to content

Instantly share code, notes, and snippets.

View lemkorp's full-sized avatar

Michel Martin lemkorp

View GitHub Profile
@lemkorp
lemkorp / tableau 2.EXCEL.yaml
Last active August 1, 2019 06:04
Create a new snippet from a blank template.
name: tableau 2
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#ajout").click(() => tryCatch(ajoutJSON));
async function ajoutJSON() {
await Excel.run(async function(context) {
@lemkorp
lemkorp / feuilles.EXCEL.yaml
Last active August 1, 2019 09:04
Create a new snippet from a blank template.
name: feuilles
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#ajouter").click(() => tryCatch(ajouter));
$("#copier").click(() => tryCatch(copier));
$("#supprimer").click(() => tryCatch(supprimer));
$("#visibilite").click(() => tryCatch(changerVisibilite));
@lemkorp
lemkorp / tableau 3.EXCEL.yaml
Last active August 1, 2019 13:24
Create a new snippet from a blank template.
name: tableau 3
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#creation").click(() => tryCatch(creation));
$("#filtre").click(() => tryCatch(filtre));
$("#stop").click(() => tryCatch(stopFiltre));
$("#trier").click(() => tryCatch(trier));
@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 / vlookup.EXCEL.yaml
Created August 1, 2019 15:57
Create a new snippet from a blank template.
name: vlookup
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 / 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 / Propriétés.EXCEL.yaml
Created August 2, 2019 15:03
Create a new snippet from a blank template.
name: Propriétés
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#propdoc").click(() => tryCatch(propDoc));
$("#nomfeuilles").click(() => tryCatch(nomFeuilles));
$("#propcell").click(() => tryCatch(propCell));
$("#graphique").click(() => tryCatch(graphique));
@lemkorp
lemkorp / Basic API call (TypeScript).EXCEL.yaml
Created August 7, 2019 13:59
Performs a basic Excel API call using TypeScript.
name: Basic API call (TypeScript)
description: Performs a basic Excel API call using TypeScript.
host: EXCEL
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
await Excel.run(async (context) => {