ExcelNovatos

name: ArrayObjetosPrueba
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: >
    $("#principal").click(() => tryCatch(principal));


    async function principal() {

ExcelNovatos

name: 'Función AverageIfs  - Promedio.Si.Conjunto - 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) => {
        const hoja = context.workbook.worksheets.getItem("Hoja1");

ExcelNovatos

name: 'Función AverageIf  - Promedio.Si - 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) => {
        const hoja = context.workbook.worksheets.getItem("Hoja1");

ExcelNovatos

name: 'Función Average  - Promedio - 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) => {

ExcelNovatos

name: 'Bucle Do-While  - 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) => {

ExcelNovatos

name: 'Bucle While - 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() {
      const lote = 200;

ExcelNovatos

name: 'Bucle For - 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() {
      // El tamaño de lote, es decir, la cantidad de filas que se procesarán en cada iteración.

ExcelNovatos

name: 'Función ABS -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) => {
        const hoja_act = context.workbook.worksheets.getActiveWorksheet();

ExcelNovatos

name: 'Función SumIfS - Sumar. Si . Conjunto – 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) => {

ExcelNovatos

name: 'Función SumIf - Sumar. Si – 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) => {