[UpdateNamedRangs] excel typescript to update the ranges of all named ranges in a workbook #excel #typescript

UpdateNamedRanges.ts

async function main(context: Excel.RequestContext) {
  // Your code here
  const items = context.workbook.names.load('items')
  await context.sync();

  items.items.forEach(item => {
    const lastIndex = item.formula.lastIndexOf('$');

    const main = item.formula.substring(0, lastIndex + 1);
    const split = +item.formula.substring(lastIndex + 1);

    console.log(main, split +5);

    item.set({formula: `${main}${split + 5}`});
  });

  await context.sync();

}