Skip to content

Instantly share code, notes, and snippets.

@ExcelNovatos
ExcelNovatos / Find - Excel JavaScript API.EXCEL.yaml
Created June 3, 2023 23:48
Create a new snippet from a blank template.
name: Find - Excel JavaScript API
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#buscar").click(() => tryCatch(buscar));
async function buscar() {
await Excel.run(async (context) => {
name: Obtener posición de la última columna con datos - Excel JavaScript API
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) => {
name: Obtener posición de última fila con datos - Excel JavaScript API
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) => {
name: Llamando una función desde otra - Excel JavaScript API
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#principal").click(() => tryCatch(principal));
async function principal() {
await Excel.run(async (context) => {
@ExcelNovatos
ExcelNovatos / Función Sum – Suma - Excel JavaScript API.EXCEL.yaml
Created May 27, 2023 18:01
Create a new snippet from a blank template.
name: Función Sum – Suma - Excel JavaScript API
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
$("#ejemplo1").click(() => tryCatch(ejemplo1));
$("#ejemplo2").click(() => tryCatch(ejemplo2));
///////////EJEMPLO 1 ////////////
name: 'Función Vlookup - Buscarv - Excel JavaScript API '
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) => {