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: 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) { |
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: 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)); |
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: 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)); |
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: 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)); |
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: 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) => { |
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: 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)); |
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: 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)); |
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: 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)); |
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: 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) => { |
OlderNewer